CREDIT APPROVAL NOT WORKING CORRECTLY AME ATTRIBUTE AR_CMGT_OVERALL_CREDIT (Doc ID 2026517.1)

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

On : 12.2

Multiple Credit Management issues..

Issue 1: A case folder with case_folder_id XXX has been submitted with an overall credit limit recommendation of 1000 EUR. However, when the workflow enters  the AME approval section, it skips approval. Analysis found that the AR_CMGT_OVERALL_CREDIT_LIMIT returns the correct Currency Code and Conversion Type, but the Value is null when run in the AME test workbench.

Issue 2: When attempting to process Case Folder with Recommendation that has amount in format 5.000,00, the following error occurs in workflow.

Issue started after applying latest OCM patches mentioned below:

14461771   - CREDIT CHECKING PACKAGE API ERROR-WHEN ORDER CREATED BY USER WHO IS NOT EMPLOYEE
12958504   - PERFORMANCE ISSUES IN GATHER_DATA_POINTS LOGIC FOR CASE FOLDERS
12670579   -   LAST & NEXT REVIEW DATE NOT GETTING UPDATED AT SITE LEVEL
10046101   - CREDIT SCORE NOT ROUNDING      
16619705    -   OAF PERSONALIZATION REQUIRED PROPERTY DOES NOT WORK
14670949     -   SOME DATA POINTS STILL DECIMAL PLACE ISSUE AFTER 13419245
12900005     -   OCM DOES NOT REFRESH THE LAST CALCULATED CREDIT SCORE DATA POINT

ERROR
-----------------------
ORA-06502: PL/SQ; ERROR: character to number conversion error
AR_CMGT_WF_ENGINE.SET_ROUTING_STATUS,XXXXX, ORA-06502


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Case Folder and enter  Recommendation to process the new Credit limit in format 5.000,00

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