Non-merchandise Invoice With $0 Getting Stuck in IM_INJECT_DOC_ERROR Table (Doc ID 2565203.1)

Last updated on APRIL 11, 2022

Applies to:

Symptoms

Non-merchandise invoice with $0 getting stuck in IM_INJECT_DOC_ERROR table with rule PV_ZERO_COST_MERCH_INV_ONLY.

Steps To Reproduce :

   1. Obligation created with 0 Cost.
   2. Obligation is approved and records captured in INVC* tables.
   3. INVC_NON_MERCH - cost value is 0.
   4. Downloaded the invoice in Electronic Data Interchange(EDI) and try to process it via reim injector batch.
   5. Invoice record is rejected and records captured in IM_INJECT_DOC_ERROR with rule PV_ZERO_COST_MERCH_INV_ONLY. This rule means : Only merchandise invoices can have zero total cost.
   6. Hence Zero cost invoice (approved obligation) is not imported from Retail Merchandising System(RMS) to Retail Invoice Matching(REIM) (expected).

Changes

Cause

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