My Oracle Support Banner

Is There A Query That Will Generate Problem Records With Incorrect CCID On Capital Expenditures? (Doc ID 2807066.1)

Last updated on SEPTEMBER 15, 2021

Applies to:

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


If a transaction is imported to Projects as AP INVOICE, then the system will query SLA tables to get the account with which the corresponding invoice distribution is accounted. (Invoice id and invoice distribution are stamped as document header and document distribution id on pa_expenditure_items_all.)

To review the individual expenditure, user can use the tools-> View Accounting screen

This does the job to get the source table and then to SLA tables where the account is displayed.

Currently it is a manual process of inquiring each expenditure to determine the account which is cumbersome if there are large amount of expenditures.

Can Development provide a script or report to assist in this issue?


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

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