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:

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

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