VCP->JDE - Manually Created Planned Orders Not Generated In Outbound XML Files
(Doc ID 2222162.1)
Last updated on MARCH 08, 2017
Oracle Value Chain Planning Integration Base Pack - Version 11.6 and later Information in this document applies to any platform.
12.2.5 with AIA 11.6
Users are creating manual planned orders (PO) and releasing to JDE. After releasing, data is populated in msc_po_requisitions_interface table and msc_supplies table. But it is NOT generated in purchaseplan.xml after "publish planning results" program.
STEPS -------------- For comparison - released two rows - 1 created by plan, 1 created by user 1. Get order_number (transaction_id) for both and query msc_supplies select * from msc_supplies where transaction_id in (&order_no1,&order_no2);
2. Now click release button and save Run again select * from msc_supplies where transaction_id in (&order_no1,&order_no2);
3. Now click Plan /release to release both orders Run SQL again select * from msc_supplies where transaction_id in (&order_no1,&order_no2); AND also select * from msc_po_requisitions_interface where source_line_id in (&order_no1,&order_no2);
4. Generate PurchasePlan.xml see that only 1 row is present in file - the one for order created by ASCP plan is in XML
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!