My Oracle Support Banner

EDIDLORD.PC Batch Does Not Create TSHIP Records For All Items In Closed Purchase Order With Partial Receiving (Doc ID 2677802.1)

Last updated on JUNE 25, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

EDIDLORD.PC Batch does not create TSHIP records against every TITEM record for the item which are not cancelled inside a closed PO.
This is a discrepancy in the file layout as it says that under every TORDR record there will be 1 TITEM and 1 TSHIP for every line item (non pack).

Steps to reproduce:

  1. Create a PO through PO Upload Process (Using front end screen) in Approved status. PO has 4 line items (non pack).
  2. Run ordrev.pc and edidlord.pc batch programs one after another.
  3. Note that an EDI file has been generated for all 4 items. There are 4 TITEM and 4 TSHIP for corresponding line item.
  4. Receive 3 line items fully and 1 line item partially.
  5. Through screen, open the PO in edit mode and click on 'Cancel All Item' from screen. PO status will be 'Closed'. And 1 partially line item will be cancelled with cancel_code = 'B'.
  6. Observe one record for the PO will be inserted into rev_orders table.
  7. Run ordrev.pc and edidlord.pc batch programs one after another.
  8. Note that an EDI file has been generated for all 4 items. There are 4 TITEM but only 1 TSHIP record for the cancelled item.

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.