My Oracle Support Banner

EBI 9.2: PROJ_RESOURCE.RESOURCE_AMOUNT Is 0 For Bills Created Through Excel Upload With Analysis Type as REV Or BAJ (Doc ID 2358370.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

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


On : 9.2 version, Billing Interface

Billing Transactions imported through the Billing Spreadsheet, does not integrate correctly to Project Costing for RESOURCE_AMOUNT field. The Foreign Amount and Resource
Amount are 0 in PROJ_RESOURCE table. Bills copied from the interfaced billing transactions or bills created online when processed, it correctly populates the RESOURCE_AMOUNT in PROJ_RESOURCE table.

PROJ_RESOURCE.RESOURCE_AMOUNT should not be 0 for bills created through Spreadsheet Invoice Import.

The issue can be reproduced at will with the following steps:
1: Billing Spreadsheet is populated and loaded into INTFC_BI using excel upload.
2: Ran the Billing Interface process.Bill got created.
3: Make sure Invoice has the required Project ChartField values needed for PC integration. Run the Single Action Invoice job.
4: Run the Update Contracts and Projects process from the navigation Billing > Generate Invoice > Utilities > Update Contract/Projects Data
5: Run the Retrieve Billing Items process from the navigation Project Costing > Revenue Collection > Retrieve Billing Items
6: Reviewed the Billing transaction on Project Resource by navigating to Project Costing >Transaction Definitions > Transaction List. Note Resource Amount is 0

The issue has the following business impact:
Amount in project costing is not correct.


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.