My Oracle Support Banner

Performance Issue With the "PRC: Interface Expense Reports From Payables" Program (Doc ID 2883665.1)

Last updated on JULY 21, 2022

Applies to:

Oracle Project Costing - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Getting performance issue when running the "PRC: Interface Expense Reports from Payables".  It is taking around 30 minutes to process 3 records.

The most 3 expensive queries are:

Query #1
--------


Steps to Reproduce:

1. Log into a Projects responsibility

2. Navigate: Submit > Request

3. Run the "PRC: Interface Expense Reports from Payables" program

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.