PAAPIMP: PRC: Interface Supplier Costs Performance Issue When Integrating Oracle Projects With Oracle Inventory and Oracle Project Manufacturing (Doc ID 3046060.1)

Last updated on SEPTEMBER 10, 2024

Applies to:

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

PRC: Interface Supplier Costs performance issue. The program will run for hours when run for a single project, and for days if run for all projects.

The expensive query found for this is

The following scenario will cause this issue,

Work Order and PO are receipted
Cost manager is run
Interface costs to Projects using transaction import with transaction source 'PJM_CSTBP_WIP_NO_ACCOUNTS'
Run the Pay On Receipt AutoInvoice concurrent request to create the self-billing AP invoice records
Run PRC: Interface Supplier Costs

	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

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