REV_IND_COMPILED_SET_ID and INV_IND_COMPILED_SET_ID in PA_CUST_REV_DIST_LINES_ALL Incorrectly Populated From Procedure PA_CLIENT_EXTN_BILLLING.CALC_BILL_AMOUNT (Doc ID 2946795.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

INV_IND_COMPILED_SET_ID and REV_IND_COMPILED_SET_ID are incorrectly populated in the PA_CUST_REV_DIST_LINES_ALL table. Many expenditures (but not all) are populated with a value that is related to burdens ind_compiled_set_id though bill rates are setup for the project/task. Bill rates are used for the expenditures per the pa_cust_rev_dist_lines_all table.

Replication Steps:

1. > Projects responsibility > Projects. Under the Project and Task options, navigate to > Bill Rates and Discount Overrides > Standard Billing Schedules. In the Billing Schedules screen, the Bill Rate Schedule is checked for Labor and Non-Labor.
2. Create new expenditure(s). For example, Expenditures > Pre-Approved Batches. Approve and release batch.
3. > Other > Requests > Run. Run the distribution process. For example, PRC: Distribute Labor Costs.
4. > Other > Requests > Run. Run the PRC: Generate Draft Revenue for a Single Project or a Range of Projects.
5. > Billing > Revenue Review. Open the project. Approve and Release the revenue.
6. > Other > Requests > Run. Run the PRC: Generate Revenue Accounting Events. Run the PRC: Create Accounting for the Process Category = Revenue.
7. > Other > Requests > Run. Run the PRC: Generate Draft Invoices.
8. > Billing > Invoice Review. Open the project. Approve and Release the invoice.
9. > Other > Requests > Run. Run the PRC: Interface Invoices to Receivables.
10. > Receivables responsibility > Control > Requests > Run. Run the Autoinvoice Master Program.
11. > Projects responsibility > Other > Requests > Run. Run the PRC: Tieback Invoices from Receivables.
12. Run the query,

select * from pa_cust_rev_dist_lines_all where project_id = &project_id;

Check the pa_cust_rev_dist_lines_all table to see if the REV_IND_COMPILED_SET_ID and INV_IND_COMPILED_SET_ID columns are populated with values.

Cause

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