My Oracle Support Banner

Edidlord Extracts Redundant CH Order Files (Doc ID 2891004.1)

Last updated on AUGUST 22, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

If an EDI PO is un-approved and then re-approved in MFCS, then edidlord batch extracts a PO file with "CH" Order change type, even if no changes were made in the PO.


Steps To recreate:
 1. Pick a test supplier with EDI_PO_IND = 'Y' and EDI_PO_CHG = 'Y'
2. Create a PO and approve it
3. Run ordrev, edidlord batches. Note that the PO is extracted as New (NW)
4. Put the PO back to Worksheet status via MFCS UI, close the screen
5. Open the PO management screen again and approve the PO. Do not make any changes in dates, items, quantities, cost etc.
6. Note that PO number is inserted into REV_ORDERS table via a DB trigger
7. Run ordrev --> edidlord. Note that PO was extracted again with TORDER.Order change type = 'CH' (Changed). But the extracted data is the same as in the first file with change type = 'NW' (New).

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


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