When Running Posting Batch IM_RECEIPT_ITEM_POSTING_STAGE and IM_RCPT_ITEM_POSTING_INV_STAGE Are Empty Though Invoice Got Posted
(Doc ID 2554808.1)
Last updated on APRIL 11, 2022
Applies to:Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.
During matching, the posted receipt records are written to the tables IM_RECEIPT_ITEM_POSTING and IM_RCPT_ITEM_POSTING_INVOICE.
When posting occurs, this data is moved to the IM_RECEIPT_ITEM_POSTING_STAGE and IM_RCPT_ITEM_POSTING_INV_STAGE tables.
But when Running Posting Batch, IM_RECEIPT_ITEM_POSTING.QTY_POSTED is null even though Invoice got Posted.
Steps To Recreate :
1. Create a Purchase Order (PO), ship and receive fully. with 2 items.
2. Create a merchandise invoice for the order for 1 item from receipt.
3. Match Invoice with Receipt, Invoice gets matched and receipt still remains U status.
4. Run Posting batch.
Verified the data hasn't moved from IM_RCPT_ITEM_POSTING_INVOICE and IM_RECEIPT_ITEM_POSTING to IM_RCPT_ITEM_POSTING_INV_STAGE and IM_RECEIPT_ITEM_POSTING_STAGE.
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