Workflow 'ARCMGTAP' Fails With Error ORA-01403 After R12.2.8 Upgrade
(Doc ID 2633318.1)
Last updated on SEPTEMBER 25, 2021
Oracle Credit Management - Version 12.2.8 and later Information in this document applies to any platform.
Workflow 'ARCMGTAP' (AR Credit Management Application Process) fails after upgade to R12.2.8 due to the following issue:
Activity 'Post Implement Processes' fails with error 'ORA-01403: No data found'
Issue: Issue is that Workflow ARCMGTAP is a 'Deferred' process, and after the recommendation is entered by the end-user then the program 'Workflow Background Process' will pick up the recommendation and create it, but if 'Workflow Backgound Process' is being run by Username 'SYSADMIN' then the standard code 'AR_CMGT_WF_ENGINE.post_implement_process' will fail as Username 'SYSADMIN' is NOT associated with an Employee record, and will then fail with error 'ORA-01403'.
Issue was introduced as per R12.2.8 upgrade within the following standard code: /* $Header: ARCMGWFB.pls 120.67.12020000.45 2019/07/31 16:25:51 mpathuri ship $ */
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!