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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms