My Oracle Support Banner

Corrected and Successfully Uploaded Records from Inject Tables are Still Retained in WKSHT Status (Doc ID 2455924.1)

Last updated on AUGUST 14, 2020

Applies to:

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

Symptoms

When a rejected invoice was corrected, the status of the record in IM_INJECT_DOC_HEAD table remain in 'WKSHT' though the invoice was successfully created in IM_DOC_HEAD and other related tables.

Steps to Recreate:

  1. Create an EDI file for one merchandise invoice.
  2. Edit the EDI file such that the item is invalid.
  3. Run injector batch and notice the invoice was rejected with 'VALID_ITEM' error.
  4. Correct the item using 'Mass Correct' option.
  5. Notice that the invoice was successfully created in IM_DOC_HEAD table. However, the status of the record in IM_INJECT_DOC_HEAD table remain in 'WKSHT'.

 

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


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