My Oracle Support Banner

EBI9.2: Journal Date And Ledger Group Are Missing In PS_PROJ_RESOURCE Table For Billing Entries (Doc ID 2418748.1)

Last updated on APRIL 07, 2019

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Upon running PC_BI_TO_PC process, Journal Date and Ledger Group are missing from PS_PROJ_RESOURCE table when the entries are created in Billing, although transactions are successfully created.

The issue can be reproduced at will with the following steps:

  1. Create a contract and add an amount based line;
  2. On Contract Terms, select PC BU, Project and activity;
  3. Assign a milestone billing plan;
  4. For the revenue plan select Billing Manages Revenue;
  5. Allocate the amount and activate the contract;
  6. Run CA_BI_INTFC process;
  7. Run Billing Interface;
  8. Set the invoice to Ready and finalize the invoice;
  9. Create Accounting Entries;
  10. Run FS_JGEN process;
  11. Run Update Contract/Projects Data process;
  12. Run PC_BI_TO_PC process;
  13. FBD transaction has been created but Journal Date and Ledger Group are missing.




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.