Receiving Fails Due To Validation Of I_tran_date Of Program STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT Is Null.
(Doc ID 2998818.1)
Last updated on JANUARY 19, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
PO receipts are failed in RIB with below error.
ERROR
-----------------------
Exception while processing request: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?)}: [E] The required input parameter I_tran_date of program STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT is null.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish PO receipts
2. Check rib_message tables and rib-rms Receipt Subscriber adaptor logs
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot subscribe receipt messages
Changes
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 |
Changes |
Cause |
Solution |
References |