Cannot View Invoice Approval History That Includes An End-Dated User After Workflow Notification Is Sent

(Doc ID 1352537.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.

Goal

On application version 12.1.2 after end-dating a persons record in HRMS, who happens to be a future approver against an AP invoice, trying to check the invoice approval history for that invoice results in the following error:

Error message
APP-SQLAP-10000: ORA-20001: The approver identified by the
following parameters is invalid:
originating system PER originating-system ID NNNNN.
Please delete or replace this approver wherever they occur
in AME data,
including approval groups, list-modification conditions, and
substitution actions. This approver does not have an entry
in wf_roles. occurred in
AP_WORKFLOW_PKG.Get_All_Approvers <-APXIAWHS
with parameters (&PARAMETERS)
while performing the following operation:
set variables from workflow

Clicking Ok does not display the approval history window

Steps to reproduce
1 - Prior to end-dating the person in HRMS, invoice approval history is viewable.
2 - End-date the person in HRMS
3 - Retry to view the invoice approval history, get the error

Solution

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