My Oracle Support Banner

PAICGEN: Intercompany Invoice Generation Does Not Reset The Transfer Price Base Amount After Recalculating Revenue (Doc ID 2847709.1)

Last updated on FEBRUARY 14, 2023

Applies to:

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


After Intercompany billing has occurred, users often have bill rates that are updated and revenue is recalculated.

In most cases the TP_BASE_AMOUNT column in the pa_expenditure_items_all table gets updated and results in an adjustment created when Intercompany Invoice Generation is run for the project.

Occasionally, (usually for specific projects) the TP_BASE_AMOUNT is not getting updated.

After recalculation of revenue the cc_ic_processed_code gets reset correctly from Y to N but if the TP_BASE_AMOUNT column does not change then the intercompany billing identifies a net zero change so updates the processed flag to Y and does not generate any intercompany billing draft invoice adjustment.

This results in the revenue being recalculated and adjusted, but no intercompany invoice adjustment.

Steps to Reproduce

  1. Log into a Project responsibility
  2. Run PRC: Generate Intercompany Invoices for a Single Project
  3. Approve and release the intercompany invoice
  4. Run the PRC: Interface Intercompany Invoices to Receivables
  5. Change responsibility to the Receivers Projects responsibility
  6. Navigate to Setup > Expenditures > Rate Schedules
  7. Query up the Project's Rate Schedule and adjust the defined rate
  8. Navigate to Expenditures > Expenditure Inquiry > Project
  9. Query transactions for the Receiver project
  10. Find the transactions that need to have the rate adjusted
  11. On the toolbar select > Tools > Recalculate Revenue
  12. Click Yes to confirm 'Do you want to continue the adjust action'
  13. Run the PRC: Generate Draft Revenue for a Single Project
  14. Confirm that Revenue was adjusted and a new draft revenue was created
  15. Change responsibility to the Provider project responsibility
  16. Run PRC: Generate Intercompany Invoices for a Single Project
  17. Reviewing the program output will show that no Intercompany Invoice adjustment was created.




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.