My Oracle Support Banner

VENDINVC_JOB FAILING - ORA-02290: Check Constraint (RMS01.CHK_SCDH_INVOICE_PROC_LOG) (Doc ID 3004374.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

VENDINVC_JOB FAILING - ORA-02290: check constraint (RMS01.CHK_SCDH_INVOICE_PROC_LOG)

SYS_OUT:@RMSAlias: vendinvc_1~20240203042441~insert_complex_head~stage_complex_deal_head~-2290~ORA-02290: check constraint (RMS01.CHK_SCDH_INVOICE_PROC_LOG) violated~ARRAY INSERT: deal no <deal_no>, deal detail id <Deal Detail ID>

ERROR
-----------------------
2024-02-03T04:24:42,021 [Thread-7790] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: vendinvc_1~20240203042441~insert_complex_head~stage_complex_deal_head~-2290~ORA-02290: check constraint (RMS01.CHK_SCDH_INVOICE_PROC_LOG) violated~ARRAY INSERT: deal no <deal_no>, deal detail id <Deal Detail ID>
 

Solution

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
Goal
Solution


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