Automatic Sourcing

Automatic Sourcing

Set Up Automatic Sourcing (Optional)

 You can set up Purchasing to automatically default source document information from a blanket purchase agreement or catalog quotation onto a requisition or purchase order line for a particular item and supplier. Or you can default just a supplier and optionally a supplier site.

You can set up automatic sourcing now or at any time on an ongoing basis.

 Profile Option Settings 

MRP: Default Sourcing Assignment Set

        This profile option indicates which sourcing rules assignment set will be used in Purchasing and Supplier Scheduling.             Planning allows you to use multiple Assignment Sets, but Purchasing looks at only a single Assignment Set—the one             that is specified in this profile option. Therefore, the Assignment Set name you choose for this profile option is the                 Assignment Set name you should specify when you assign sourcing rules in the Sourcing Rule/Bill of Distribution                 Assignments window. This profile option must be set if you are using sourcing rules in Purchasing.

 MRP: Sourcing Rule Category Set

        If you are using sourcing rules in Purchasing, this profile needs to be set to the name of the default category set used by         Purchasing as indicated in the Default Category Sets window. Otherwise, you will not be able to display Category and            Category–Organization assignments in the Sourcing Rule / Bill of Distribution Assignments window.

Profile Options:

PO: Allow Auto-generate Sourcing Rules => CREATE AND UPDATE

PO: Allow Autocreation of Oracle Sourcing Documents => Yes

MRP: Default Assignment Set => Define with desired Assignment Set

Sql Statements
 

Select * from po_headers_all
WHERE segment1 = '41017'
 
Select * from po_lines_all
WHERE PO_HEADER_ID = 334170
 
Select * from po_approved_supplier_list
where ASL_ID = 23568
order by creation_date desc
 
Select * from po_asl_attributes
where ASL_ID = 23568
order by creation_date desc
 
Select * from PO_ASL_DOCUMENTS
where ASL_ID = 23568
and DOCUMENT_HEADER_ID = 334170
 
Select * from MRP_SOURCING_RULES
where sourcing_rule_id = 8186
order by creation_date desc
 
Select * from MRP_SR_RECEIPT_ORG
where sourcing_rule_id = 8186
order by creation_date desc
 
Select * from MRP_SR_SOURCE_ORG
where sr_receipt_id = 7066
order by creation_date desc
 
Select * from MRP_ASSIGNMENT_SETS
 
Select * from MRP_SR_ASSIGNMENTS
where sourcing_rule_id = 8186

order by creation_date desc