My Oracle Support Banner

Intragover Deferred Performance Integration Program Gets Exception in FETCH_PERF_FAILED User-Defined Exception (Doc ID 2892823.1)

Last updated on OCTOBER 17, 2022

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms


Intragovernmental Deferred Performance Integration Program, after application of patch 34280239, is failing with error that can be seen in the log file:

Error

An error occured while fetching the records User-Defined Exception
FETCH_DEFERRED_PERF_INFO return statusE
Exception in FETCH_PERF_FAILED User-Defined Exception 

Steps to Reproduce

1. Run Intragovernmental Deferred Performance Integration Program without order number

The log shows:


IGT_DEFERRED_PERF_PROGRAM: Intragovernmental Deferred Performance Integration Program

Starting the Intragovernmental Performance Integration to Deferred Program
Input Parameters are as below
P_ORG_ID => 81
P_PO_HEADER_ID =>
P_PREV_PERIOD_FLAG =>
P_PROCESS_ERROR_DOCUMENTS => N
Called PROCESS_DEFERRED_PERF with below parameters
P_ORG_ID => 81
P_PO_HEADER_ID =>
An error occured while fetching the records User-Defined Exception
FETCH_DEFERRED_PERF_INFO return statusE
Exception in FETCH_PERF_FAILED User-Defined Exception
Count of Error messages0
In SEND_NOTIFICATION procedure



Changes

 

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
Changes
Cause
Solution
References


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