My Oracle Support Banner

VCP->JDE - Manually Created Planned Orders Not Generated In Outbound XML Files (Doc ID 2222162.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.6 and later
Information in this document applies to any platform.


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.

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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.