Project Costing Frequently Asked Questions
The Oracle Fusion ERP Analytics Frequently Asked Questions (FAQs) provide answers to the most commonly asked questions about your analytics experience.
Project Costing Topics:
- Why do Accounted Raw Cost, Accounted Burden Cost, and Accounted Burdened Cost metrics show a zero value?
- How are item details fetched in the Project Costs and Commitments subject areas?
- Why aren't all labor schedules fetched for the PPM - Project Labor Distributions subject area?
- Why are certain labor schedule versions not showing in the PPM - Project Labor Schedules subject area even though they're in Fusion Applications?
- How do I use the pivot attributes labor schedule name and version name while doing data validation for the PPM - Project Labor Schedule subject area?
- Why do I see labor schedules in the PPM Project Labor Schedule subject are which I'm not able to see in the Fusion Applications Manage Labor Schedules page?
- Why am I seeing different values for Distribution Line Number in Labor Distribution Cost Details and Distribution Rule Line in the presentation folder Labor Schedules Details?
- Why do I see only total values when using GL Account and GL Segment-related attributes in the PPM - Project Costs subject area?
- How are the aggregate fact tables for the PPM - Project Costing subject area refreshed?
Why do Accounted Raw Cost, Accounted Burden Cost, and Accounted Burdened Cost metrics show a zero value?
The Accounted Raw Cost, Accounted Burden Cost, and Accounted Burdened Cost metrics in the PPM - Projects Costs subject area require the GL Account Combination attribute. If the GL Account Combination attribute isn't included, the Debit and Credit entries negate each other and the metric value shows as zero.
How are item details fetched in the Project Costs and Commitments subject areas?
You can assign an Item to multiple inventory organizations. In order to fetch the item details in the Project Costs and Project Commitments subject areas, add either a single master organization or a project inventory organization as a filter to avoid duplicating records with multiple inventory organizations.
Why aren't all labor schedules fetched for the PPM - Project Labor Distributions subject area?
The PPM - Project Labor Distributions subject area only displays schedules and versions which are used to distribute the labor cost. To query all labor schedules with no labor cost associated, include the Labor Schedule attributes and measure from the PPM Labor Schedule subject area along with Labor Cost Distribution measures.
Why are certain labor schedule versions not showing in the PPM - Project Labor Schedules subject area even though they're in Fusion Applications?
The Labor schedule versions which are in New status in the PPM - Project Labor Schedules subject area aren't displayed if there are no distribution lines defined for the schedule version.
How do I use the pivot attributes labor schedule name and version name while doing data validation for the PPM - Project Labor Schedule subject area?
When you perform data validation for the metrics in the PPM Labor schedule subject area,when you select the pivot attributes schedule name and version name, you must select the the respective Schedule ID and Version ID to match the metrics.
Why am I seeing different values for Distribution Line Number in Labor Distribution Cost Details and Distribution Rule Line in the presentation folder Labor Schedules Details?
In the Labor Distribution Costs subject area, Distribution Rule Line in the Labor Schedules Details presentation folder shows a different value compared to the Distribution Line Number in the Labor Distribution Cost Details presentation folder for differentials.
This happens when a differential line is processed in labor distribution costs, and then displayed and stored as -1 for the Distribution Line Number. The Labor schedule doesn't have a differential line, therefore the Distribution Rule Line in Labor Schedule displays as 0.
Why do I see only total values when using GL Account and GL Segment-related attributes in the PPM - Project Costs subject area?
GL Account- and GL Segment-related attributes and hierarchies are only for analyzing accounting related metrics and so these attributes can be used only with metrics under the Project Accounting Costs folder in the PPM-Project Costs subject area. All other metrics can't be analyzed using the GL Account- and GL Segment-related attributes.
Why do I see labor schedules in the PPM Project Labor Schedule subject area which I'm not able to see in the Fusion Applications Manage Labor Schedules page?
The Labor schedules in the Manage Labor Schedules page in Fusion Applications is secured by the assigned Area of Responsibility and PPM Project Labor schedule subject area is secured by Business Unit. There may be differences during data validation if there's a mismatch between the Area of Responsibility security and the Business User security for the user.
How are the aggregate fact tables for the PPM - Project Costing subject area refreshed?
The aggregate facts tables are maintained at the period level grain in the PPM Project Costs subject area. Current Period and Prior period data in these tables gets refreshed during the incremental upload based on the Provider GL Date when expenditure transactions are added to the base facts. If you need to account for expenditure transactions in a period prior to these two periods, you either need to perform a functional reset or you need to update the JMC parameter to process the incremental records.
If you always expect accounting of transactions prior to these two periods, open a Service Request with Oracle support to update the parameter.