Oracle Communities

Oracle Analytics and AI

Child Item

SQL query for Review Cost Accounting Distributions information tab details in detail

Hi Support,

SQL query for Cost information tab details in detail

Review Cost Accounting Distributions - Could anyone help me to get the SQL query to get cost component wise amount.

SQL query for Cost information tab details in detail

CST_LAYER_COSTS - Table hold amount in summary level not in detail.
Please provide the sql qery/joins to get component wise cost details in Inventory module.

Navigation —> Supply Chain Execution —> Cost Accounting —> Task —> Review Cost Accounting Distributions —> Query item —> Click on View Details

Find more posts tagged with

Inventory

Oracle Application Development

Oracle Fusion Analytics

Supply Chain

Fusion SCM Analytics

Accepted answers

Sumanth V -Oracle

@Gorla Shiva - Please post this query in the OTBI community for better suggestions.

https://community.oracle.com/products/oracleanalytics/categories/otbi

This forum is specific to FAW/FDI.

All comments

Sumanth V -Oracle

@Gorla Shiva - Please post this query in the OTBI community for better suggestions.

https://community.oracle.com/products/oracleanalytics/categories/otbi

This forum is specific to FAW/FDI.

Gorla Shiva

What I know the table names and their joins to get in details(all lines details)

Sumanth V -Oracle

@Gorla Shiva - Please let us know if you need these details to be fetched from Fusion application side or at the warehouse side.

Gorla Shiva

Hi Sumanth,

Fusion application - Supply Chain Execution —> Cost Accounting.

Sumanth V -Oracle

@Gorla Shiva - Yes, as said in my initial update OTBI forum will have more number of users who will be able to assist with the request. Kindly reach out here.

https://community.oracle.com/products/oracleanalytics/categories/otbi

@John Hung-Oracle - Please assist by moving the same thread to OTBI if possible.

Gorla Shiva

@Sumanth V -Oracle , Thanks.

I have posted same question in Oracle Transactional Business Intelligence.

Experts can I get answer on this as early as possible?

It is stopping to release CRP.