My Oracle Support Banner

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

Last updated on JANUARY 28, 2020

Applies to:

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

Symptoms

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 $ */ 

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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