My Oracle Support Banner

PAXTRAPE: Billed Expenditures Show as Unbilled in the Expenditure Inquiry Form yet they have the Bill Amount Field Populated. (Doc ID 2713110.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

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

Symptoms

There are 2 expenditure items that appear in the Expenditure Inquiry as Unbilled but when users view the items, they have the bill amount field populated.  The items have the bill_amount populated in pa_expenditure_items_all but it is NOT populated in pa_cust_rev_dist_lines_all nor is there a draft invoice number populated.  These 2 expenditure items net to zero but are NOT net zero adjustments.  The Implementation Option 'Invoice net zero lines' is NOT checked.  If these items are not billed, then why is the bill amount field populated?  Per When Is The BILL_AMOUNT Column Populated In The Tables? (Doc ID 278547.1):

Goal:
In previous versions of Oracle Projects, the pa_cust_rev_dist_lines_all .bill_amount and PA_EXPENDITURE_ITEMS_ALL.bill_amount were populated during PARGDR - PRC: Generate Draft Revenue process.  In 11.5.9, it seems that this field is populated during PAIGEN - PRC: Generate Draft Invoice process. Is this correct?

Solution:
This is correct. With 11i.PJ_PF.J and higher (11.5.9 comes with 11i.PJ_PF.K) code modifications were made to the Bill Amount and how/when it is populated.  The bill_trans_amount column, not the bill_amount is populated after revenue is generated (PARGDR). Bill Amount is now calculated during invoice generation (PAIGEN).


Based on the above, the bill_amount field should agree between the two tables based on the above note.  

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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