My Oracle Support Banner

EBI 9.2: Invoice with Incomplete Chartfields in Accounting Entries- PC Business Unit, Activity ID, Source Type and Category ChartFields are Left as Blank, although They were Populated in the Excel Spreadsheet File (Doc ID 2780705.1)

Last updated on MAY 30, 2021

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 and later
Information in this document applies to any platform.


The Billing Accounting Entries generated for an invoice interfaced from Excel Upload are missing the values of all Project Costing related ChartFields, except for Project ID. Meaning PC Business Unit, Activity ID, Source Type, and Category ChartFields are left as blank, even though in the Excel spreadsheet all those values were populated manually.
As the Billing Invoice Accounting Entries are incomplete, with missing crucial Project Costing related ChartFields, the transactions cannot be further interfaced into the Project Costing module to recognize the revenue, and to Accounts Receivable to generate the needed Items.


  1.- Use the delivered Excel Upload spreadsheet to manually enter a new Invoice, with multiple lines, and in all of them, make sure to populate the Fields of PC Business Unit, Project ID, Activity ID, Source Type, and Category
  2.- Interface the Excel Upload transaction data into the PeopleSoft tables, by generating a new Interface ID (Record PS_BI_INTFC gets populated)
  3.- Launch the Billing Interface process (BIIF0001 AE Program) for the Interface ID value generated
  4.- Confirm that the Project Costing related ChartField values are present on the multiple Lines of the newly created Invoice in Billing
  5.- Set the new Invoice into RDY status (Ready)
  6.- Confirm that at the Invoice 'Line - Proj Info' page the Project ChartFields are populated (PC Business Unit, Project ID, Activity ID, Source Type, and Category)
  7.- Check the 'Revenue Distribution' page, and confirm that there, only Project ID ChartField is populated, while all the remaining Fields are editable, but empty (PC Business Unit, Activity ID, Source Type, and Category)
  8.- Finalize the Invoice at hand
  9.- Generate the Accounting Entries of the Invoice
  10.- Review the Invoice's Accounting Entries, and confirm that only Project ID Field is populated, while the remaining ChartFields are blank (PC Business Unit, Activity ID, Source Type, and Category).

For the replication steps, please review Replication_File.

In the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.




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.