PA_EXPENDITURE_ITEMS_ALL.REVENUE_DISTRIBUTED_FLAG Showing as N Instead of Y for Capitalized Projects (Doc ID 2896982.1)

Last updated on SEPTEMBER 30, 2022

Applies to:

Symptoms

The PA_EXPENDITURE_ITEMS_ALL.REVENUE_DISTRIBUTED_FLAG is showing as N instead of Y.    The asset lines have been transferred to Fixed Assets as shown with PA_PROJECT_ASSET_LINES_ALL.TRANSFER_STATUS_CODE = A (Accepted).  This would mean that the PA_EXPENDITURE_ITEMS_ALL.REVENUE_DISTRIBUTED_FLAG should be 'Y'.

Replication Steps:

1. For a sample problem project, run the following query.

select revenue_distributed_flag from pa_expenditure_items_all where project_id in (select project_id from pa_project_asset_lines_all where project_id = &project_id and transfer_status_code = 'A');

2. If the PA_PROJECT_ASSET_LINES_ALL.TRANSFER_STATUS_CODE = A and PA_EXPENDITURE_ITEMS_ALL.REVENUE_DISTRIBUTED_FLAG = N, then this is not correct as the PA_EXPENDITURE_ITEMS_ALL.REVENUE_DISTRIBUTED_FLAG should be Y.

Cause

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