My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.