Invalid Edi Structure Error (Doc ID 2955674.1)

Last updated on JUNE 16, 2023

Applies to:

Symptoms

When attempting to process an invoice <INVC_*.dat> file using REIM_EDI_INJECTOR batch the below error is seen.

The POC and the previous successfully processed invoices, there can be multiple TALLW records under the TDETL record. Its also mentioned in the OG (3-6 Oracle Retail Invoice Matching Operations Guide) that "TALLW (0…n): Allowance records for this item. TALLW is optional." 

ERROR
-----------------------
Couldn't stage data for dataSource /u01/retail/reim/reim-batch/batch/data/in/INVC_20230410070501770/INVC_20230410070501770.dat-Invalid edi structure, previous record was TALLW and new record was TALLW. Valid records can be [TALLT, TDETL, TNMRC, TPORD, TVATS, TTAIL]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Uploaded INV file to Incoming/reim folder
2. Ran REIM_EDI_INJECTOR batch via POM.
3. Check the IM_DOC_HEAD table, invoice is not created
4. Checked the Job_Audit_logs table with the below query

select a.*, to_char(log_datetime, 'DD-MON-RR HH24:MI:SS') from job_audit_logs a where upper(job_name) = 'EDIINJECTOR' and log_type='E' order by log_datetime desc,JOB_SEQ_NO desc;

5. The below error with JOB_SEQ_NO-50024432,PLEASE CHECK
Couldn't stage data for dataSource /u01/retail/reim/reim-batch/batch/data/in/INVC_20230410070501770/INVC_20230410070501770.dat-Invalid edi structure, previous record was TALLW and new record was TALLW. Valid records can be [TALLT, TDETL, TNMRC, TPORD, TVATS, TTAIL]


 POM job is skipped on error and the invoice is not created in IMCS

Cause

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