Credit Checking API Error CREATE_CREDIT_REQUEST ORA-01400 CREDIT_REQUEST_ID (Doc ID 1491019.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Credit Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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")

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms