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?

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.

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.

Why don't I see externally accounted Project Cost distributions in Configurable Account Analysis?

Externally Accounted Project Cost distributions are available in Project Costs Fusion tables as well as in Fusion Data Intelligence facts. However, these externally accounted costs aren't accounted for and show in the Fusion General ledger using the Subledger Accounting engine. These costs are available so you can view all the Project costs. Accounting related to these costs may be available in General Ledger by either manually uploading the journal or accessing the journal externally, but there isn't a direct link between these externally accounted transactions and the journals. Therefore, Configurable Account Analysis won't include these transactions as part of the Projects journal source. In the PPM - Project Costs subject area, you can identify externally accounted distributions using the Distribution Account Source attribute value 'EXTERNAL'.

Why are few accounting lines with certain accounting class codes missing in DW_PROJECT_SLA_COST_CF though its available in Fusion View Accounting for the Cost Distribution Lines (CDL)?

Only Accounting Lines with these account class codes are currently extracted in Fusion Data Intelligence:

  • ACCRUAL
  • AWT
  • BURDEN_COST
  • BURDEN_COST_CLEARING
  • BURDENED_COST_CLEARING
  • CASH
  • CASH_CLEARING
  • CHARGE
  • CLEARING
  • COST
  • COST_CLEARING
  • COST_VARIANCE
  • DEFERRED_COST_OF_GOODS_SOLD
  • DEFERRED_RMA_GAIN_LOSS
  • DISCOUNT
  • EVENT_WO_REV_ADJ
  • EVENT_WO_REVENUE
  • EXCHANGE_RATE_VARIANCE
  • EXPENSE
  • FREIGHT
  • FUTURE_DATED_PMT
  • INTERORG_PAYABLES
  • INTERORG_RECEIVABLES
  • INVENTORY_VALUATION
  • INVENTORY_WRITEOFF
  • IPV
  • ITEM EXPENSE
  • LIABILITY
  • MATERIAL_OVERHEAD_ABSORPTION
  • MISCELLANEOUS_ISSUE_VARIANCE
  • MISCELLANEOUS_RECEIPT_VARIANCE
  • MISCELLANEOUS EXPENSE
  • NRTAX
  • OFFSET
  • ORA_AP_DEFER_ITEM_EXP
  • ORA_AP_DEFER_NON_REC_TAX
  • ORA_AP_DEFER_SELF_ASSESSED_TAX
  • ORA_MAINTENANCE_EXPENSE
  • OVERHEAD_ABSORPTION
  • PROVIDER_COST
  • PROVIDER_REVENUE
  • PURCHASE_PRICE_VARIANCE
  • RAW_COST
  • RAW_COST_CLEARING
  • REALIZED_GAINS
  • REALIZED_GAINS_ADJ
  • REALIZED_LOSS
  • REALIZED_LOSS_ADJ
  • RECEIVER_COST
  • RECEIVER_REVENUE
  • RECEIVING_INSPECTION
  • RECLASS_DESTINATION
  • RECLASS_SOURCE RESOURCE_ABSORPTION
  • REVENUE
  • REVENUE_ADJ
  • SELF_ASSESSED_TAX
  • SELF_ASSESSED_TAX_LIAB
  • STANDARD_COST_ADJUSTMENT
  • TAX_DIFF
  • TAX_LIABILITY
  • TERV
  • TIPV
  • TRADE_INTRANSIT_VALUATION
  • TRV
  • UNBILL
  • UNBILL_ADJ
  • UNEARN_ADJ
  • UNEARNED_REVENUE
  • VAL_UNIT_TRANSFER_VARIANCE
  • WIP_VALUATION BURDENED_COST