Booking Activity Has Errored Out after Setting up Credit Checking

(Doc ID 1925588.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Transaction Payment

After setting up Credit Checking in Production, when attempting to book an order,
the following error occurs in the log file and the order does not book.

ERROR
-----------------------
GL_CURRENCY after = BRL
l_credit_check_rule_id = 1041
OEXPCRGB: In Set_G_CC_Hold_Info
G_cc_hold_item_type =
G_cc_hold_activity_name =
OEXPCRGB: Out Set_G_CC_Hold_Info
OEXUCRCB: IN GET_credit_check_rule
Select for ID 1041
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
x_return_status U
SQLERRM: User-Defined Exception
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
OEXPVPMB: OUT OF OE_CREDIT_ENGINE_GRP
X_RETURN_STATUS = U
OEXPVPMB: RETURN FROM VERIFY_PAYMENT
UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER
Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
ENTERING DELETE_ATTRIBUTE_CHANGES -1
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
RETURN STATUS FROM BOOK_ORDER: U
LEAVING OE_MSG_PUB.ADD
In WF save messages
ENTER Save_API_Messages
L_MSG_DATA=Workflow activity Book has failed due to an unexpected error. Please retry the activity from the Order Form or the Workflow Monitor. If it fails again, then contact your System Administrator.
EXIT Save_API_Messages

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Responsibility
2. Sales Orders > Enter Order header
3. Navigate to line level and enter line details
4. Book the order and see that it does not complete booking in the workflow.

  Error appears:
The Booking Activity has errored out, please contact your System Administrator.

If you take the same steps in test instance, the order works without any error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot book the order after setting up credit checking in production.

However, this works without error in test instance (clone of production).

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