Receive Error ORA-01400: Cannot Insert NULL When Running Third Party Accrual From Interface Table In Draft Mode (Doc ID 2992497.1)

Last updated on DECEMBER 11, 2023

Applies to:

Symptoms

User is running the concurrent program Third Party Accrual From Interface Table in Draft mode and receives the following error.

Error
OTHER ERROR in Process_Order ORA-01400: cannot insert NULL into
("OZF"."OZF_FUNDS_UTILIZED_DRAFT_ALL"."ACCTD_AMOUNT")
UNEXPECTED ERROR in Process_TP_ACCRUAL: User-Defined Exception
 value of x_ret_sts_custom_benef from Process_TP_ACCRUAL
(1) Tolerence info populating
(2) Mandate Party Mapping N
(3) Mandate Party Mapping N
(4) value of l_acc_selling_price is :Y
(5) value of l_amt is :1
(6) value of l_acc_selling_price is :Y
(7) value of l_amt is :1
(8) Error happened when processing resale orders.


Steps:
1. Navigate to (R) Oracle Trade Management Administrator
2. Go to concurrent requests > Run program Third Party Accrual From Interface Table in Draft mode.

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.