Oracle EBS R12: Link PR and RFQ (By Populating PR Number on PR Lines)

Oracle Purchasing does not provide a link between PR and RFQ by any standard functionality. It is however possible to achieve the aforementioned, via a small and easy customization.

The customization consists of setting up an alert in Alert Manager, to update the “Supplier Item” field at PR line level, with the concatenation of PR Number and PR Lines, after the PR is authorized.

This field is available on RFQ, Quotations, PO and also the GRN form.

Steps:

  1. Create Alert:

1

SELECT prla.line_num, prha.segment1, prha.requisition_header_id,
prla.requisition_line_id, prla.SUGGESTED_VENDOR_PRODUCT_CODE
INTO &pr_ln,
&pr_num,
&pr_hid,
&pr_lid
FROM apps.po_requisition_headers_all prha,
apps.po_requisition_lines_all prla
WHERE prha.requisition_header_id = prla.requisition_header_id
AND nvl(prla.SUGGESTED_VENDOR_PRODUCT_CODE,0) not in (
SELECT NVL(pla.vendor_product_num,’x’)
FROM po_lines_all pla, po_headers_all pha
WHERE 1 = 1
AND pla.po_header_id = pha.po_header_id
AND NVL(pla.CANCEL_FLAG,’N’) = ‘N’
AND pha.type_lookup_code = ‘RFQ’
AND pha.ORG_ID = prla.ORG_ID
)
AND prla.ROWID = :ROWID

 

2. Create Actions

2.jpg

3. Create Action Details

3.jpg

Update po_requisition_lines_all
set SUGGESTED_VENDOR_PRODUCT_CODE = &pr_num||’.’||&pr_ln
where requisition_header_id = &pr_hid
and requisition_line_id = &pr_lid;

commit;

 

4. Create Action Sets:

4

 

5

 

5. Add your relevant Operating Units in the installation tab of Alert Details.

 

6. Watch the Magic happen:

6.jpg

 

7.jpg

Advertisements

4 thoughts on “Oracle EBS R12: Link PR and RFQ (By Populating PR Number on PR Lines)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s