Return Transactions of Consignment Items Are Failing in RMS (Doc ID 2096612.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Retail Sales Audit - Version 14.0.2 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.

Symptoms

 

When loading a RETURN transaction for a consignment item, the following error occurs:



Steps to Reproduce:

1. Create a new consignment item (100171069).
2. Create a new child item (100171077).
3. Create a grandchild item (100171085).
4. Create store day 12/15 after incrementing VDATE to 12/15.
5. Run sagetref.
6. Run saimptlogi and saimptlogfin to load SALES transaction for the ref item
    SALE_RTLOG_1215.dat
7. Run saexprms to generate POSU file.
8. Run uploadsales.ksh in Unix to upload POSU file for processing.
9. Execute salesprocess.ksh to process the staged data.
10. Create store day 12/16 after incrementing VDATE to 12/16.
11. Run sagetref.
12. Run saimptlogi and saimptlogfin to load RETURN transaction for the ref item
      RETURN_RTLOG_1216.dat
13. Run saexprms to generate POSU file.
14. Run uploadsales.ksh in Unix to upload POSU file for processing.
15. Execute salesprocess.ksh to process the staged data.
16. Query SVC_POSUPLD_STATUS
      SELECT * FROM SVC_POSUPLD_STATUS WHERE REFERENCE_ID IN ('POSU_1111_20151215_20151215094908.1','POSU_1111_20151216_20151215095802.1');

17. The error appears in the table due to having 2 lines in the ADDR table for ADDR_TYPE 3 for the supplier site.

Changes

 

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