My Oracle Support Banner

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 DECEMBER 04, 2019

Applies to:

Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

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.

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.