"Settle Customer Claims" Program error: Error in AR_INVOICE_TABLE_HANDLER.insert_row, ROLLBACK ORA-01400: cannot insert NULL into (???) (Doc ID 2900128.1)

Last updated on NOVEMBER 06, 2022

Applies to:

Symptoms

On : 11.13.22.07.0 version, Customer Billing (Transactions)

"Settle Customer Claims" program failing to create Receivable Invoice

ERROR
-----------------------
Error in AR_INVOICE_TABLE_HANDLER.insert_row, ROLLBACK ORA-01400: cannot insert NULL into (???)

*--------------------------------------------------*
Settle Customer Claims Execution Report:
*--------------------------------------------------*
Execution Starts On : 09-13-2022 13:33:31
Request ID : 1647XXX
*--------------------------------------------------*
Input Parameters
*--------------------------------------------------*
Business Unit : XXXXXXXXXXXX
Bill-to Account :
Claim :
*--------------------------------------------------*
Execution Results
*--------------------------------------------------*
Claim Number : XXX16000
Bill-to Customer : Xxxxx Inc
Bill-to Account : 1
Claim Amount : -45.00 USD
Resolved Amount : -45.00 USD
Status : FAILED: Unexpected error.
----------------------------------------------------
Number of claims successfully settled : 0
Number of claims awaiting partner tax : 0
Number of failures : 1
*--------------------------------------------------*
Execution Ends On : 09-13-2022 13:33:37
*--------------------------------------------------*

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.