The PA_EXPENDITURE_ITEM_ALL Table Is Missing the INV_IND_COMPILED_SET_ID and Should Be Populated (Doc ID 3060506.1)

Last updated on NOVEMBER 24, 2024

Applies to:

Symptoms

When reviewing records in PA_EXPENDITURE_ITEMS_ALL the INV_IND_COMPILED_SET_ID and REV_IND_COMPILED_SET_ID are not populated even though the associated revenue and billing use a rate schedule.

Thee corresponding record in PA_CUST_REV_DIST_LINES_ALL does have the expected id's.

Steps to reproduce this issue

1. Create an expenditure from pre-approved batch, an integrated source or third party
2. Perform cost distribution
3. Generate revenue using a rate schedule or
4. Generate invoices using a rate schedule
5. Complete accounting processes
   1. Note that records in pa_expenditure_items_all and pa_cust_rev_dist_lines_all have the INV_IND_COMPILED_SET_ID and REV_IND_COMPILED_SET_ID's populated
6. Transfer or reverse the original transaction
   1. A new record is created as a Net Zero reversal
7. Complete distribution, revenue and invoice generation
   1. Note pa_expenditure_items_all does not populate INV_IND_COMPILED_SET_ID or REV_IND_COMPILED_SET_ID records create in pa_cust_rev_dist_lines_all have these columns populated.

Changes

Cause

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