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:Oracle Project Costing - Version 12.2.9 and later
Information in this document applies to any platform.
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'.
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.
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