This content has been marked as final. Show 5 replies
I recommend performing following setups and then try importing the standard PO.
1. Create a blanket purchase agreement mentioning the respective supplier, site, item and price.
2. Create a sourcing rule for the supplier and site used in the BPA.
3. Note the assignment set value from the profile option of "MRP: Default Sourcing Assignment Set".
4. Assign the sourcing rule created in step-2 to the assignment set noted in step-3 as "Item-Organization" assignment.
5. Setup Approved Supplier List (ASL) for the item and map supplier and site mentioned in the BPA.
6. Go to ASL attributes and map the BPA number in the "Source Documents" tab.
7. Next, go to "Inventory" tab of the same form and check the "Consigned from Supplier" checkbox.
Now you try importing the standard PO for the item, supplier and site involved in the above setups.
It should get the CONSIGNED_FLAG checked in the line_locations table, as the standard PO created through front end does the same.
Let me know how you go.
Thanks PS for the reply . We already have this setup ,What we are doing is ,We are trying to import PO through Open Interface Program. As per note 758976.1 - It is not possible to import PO with consigned_flag ='Y', So, I was trying to update this flag programatically with an API.
In that case, apply datafix in the line_locations table to update the consigned_flag, as this may not have any referential integrity.
True, That's exactly what i wanted to do. Since we are violating oracle policy of 'Not touching the base tables' , Was checking for any API.
Yes, Updating the base tables are not supported.
There are few more reference columns that you need to make sure, the po will be closed for invoicing by default.
The destination type is always set to Inventory.
Invoice Close Tolerance is 100 percent.
Match Approval Level value is 2 Way Matching.
Accrue on Receipt cannot be enabled.
Make sure all these conditions are satisfied.