Require navigation path and calculation in OTBI Subject area 'costing - work Order Costs Real Time'

Question

In OTBI Subject area 'costing - work Order Costs Real Time', we require the application navigation path and calculation logic for the following fields:

1) Work Order Costs -> Resource Cost

2) Work Order Costs -> Component Cost

3) Work Order Costs -> Output Cost

4) Work Order Costs -> WIP Balance

Awaiting a prompt responses as we are into UAT phase. Thank you.

Riyaz Ali-Oracle · Answer

Hi Dhanashree,

Check the below doc:

CST_WORK_ORDER_COSTS

Cost Accounting for Manufacturing Work Orders

Costing - Work Order Costs Real Time

Rajasekhar Bandaru-Oracle · Answer

Hi Dhanashree

Please review the given OTBI help center documentation link and also review database lineage Mapping details

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/faosm/Costing-Work-Order-Costs-Real-Time-SA-452.html#Description

https://community.oracle.com/customerconnect/discussion/479636/r13-scm-and-procurement-otbi-subject-areas-to-database-lineage-mapping-spreadsheet

To know the underlying calculations details of the Measure columns, please review the NQSQuery.log of the report for the SQL generated by the analysis report.

KB112797 Fusion Applications: How to Get nqquery Using Manage Session