My Oracle Support Banner

Workflow 'ARCMGTAP' Fails With Error ORA-01403 After R12.2.8 Upgrade (Doc ID 2633318.1)

Last updated on SEPTEMBER 25, 2021

Applies to:

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!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.