Credit Checking API Error CREATE_CREDIT_REQUEST ORA-01400 CREDIT_REQUEST_ID
(Doc ID 1491019.1)
Last updated on OCTOBER 01, 2020
Oracle Credit Management - Version 12.1.3 and later Information in this document applies to any platform.
Receiving 'CREDIT CHECKING PACKAGE API ERROR' error and the credit check failure hold is being applied again and again while pick release or purchase release.
This is happening only when the order is created by a user who is not an employee.
The exact error from the workflow debug is:
Credit review has not been submitted l_request_id= x_return_status= U l_msg_count= 1 l_msg_data= CREATE_CREDIT_REQUEST : ORA-01400: cannot insert NULL into ("AR"."AR_CMGT_HOLD_DETAILS"."CREDIT_REQUEST_ID")
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!