CREDIT APPROVAL NOT WORKING CORRECTLY AME ATTRIBUTE AR_CMGT_OVERALL_CREDIT
Last updated on DECEMBER 04, 2017
Applies to:Oracle Credit Management - Version 12.2.4 and later
Information in this document applies to any platform.
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
ORA-06502: PL/SQ; ERROR: character to number conversion error
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
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