E1: 47: EDI Advanced Ship Notice Extraction (R47032) Does Not Write Sales Ledger (F42199) if Last Status 900 Because Order Initially Backordered (Doc ID 3040844.1)

Last updated on AUGUST 12, 2024

Applies to:

Symptoms

EDI Advanced Ship Notice Extraction (R47032) does not write a Sales Ledger (F42199) record if the order line has a Last Status of 900 because it was originally on backorder.

Steps to Duplicate:

1. Verify that Order Activity Rules (P40204) for SO Order Type and S Line Type are set with Ledger (Y/N) = Y on all lines.
2. In Customer Master (P03013) setup EDI Customer 59334 with Pick Pack Config = “S O I”
3. Set up Hierarchical Configuration Definition (P47HL) for Address Number 59334 as follows:
   1. S - SDCNID
   2. O - SDDOCO
   3. I - SDLITM
4. Setup a version of EDI Advanced Ship Notice Extraction (R47032)
   1. Set Update Tab Option #1 to Run in Final Mode and set Override Status to 560
   2. Set Defaults Tab Option #2 = 856
   3. Set Heir Levels Tab first option to S O I and second option to 2 (Container ID)
   4. Set Process Tab Option #6 to 1 to override customer configuration with the configuration specified in these processing options.
5. Set Data Sequencing on EDI Advanced Ship Notice Extraction (R47032)
   1. Container ID (CNID)
   2. Order Number (DOCO)
   3. 2nd Item Number (LNID)
6. Enter a 1-line sales order for the customer for an item with no inventory. Order goes on backorder Status 900/540.
7. Adjust Inventory (P4114) so Item has Inventory.
8. Release Backorder (R42118).
   1. Last Status Remains 900 but Next Status is advanced to 545.
9. Create a version of Pick Confirm (P4205).
   1. Do Not Relieve Inventory.
   2. Advance Status of Confirmed Sales Lines to 555.
10. Pick Confirm (P4205) the sales order and remember to populate the Container ID (CNID).
11. Run EDI Advanced Ship Notice Extraction (R47032) version AFTER Pick Confirm (P4205) but BEFORE Ship Confirm (P4205). Job is processed successfully.
12. Check Status Inquiry - Work With Ship Notice Details (P470371).
    1. The EDI 856 Outbound Data was extracted to be sent to the customer.
13. Refresh Customer Service Inquiry (P4210). Status was Advanced to 900/560.
14. In databrowser, check the Sales Ledger (F42199). There was no Sales Ledger (F42199) record created by EDI Advanced Ship Notice Extraction (R47032).

Changes

Cause

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