CREDIT APPROVAL NOT WORKING CORRECTLY AME ATTRIBUTE AR_CMGT_OVERALL_CREDIT
(Doc ID 2026517.1)
Last updated on JULY 20, 2020
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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!