nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

SQL query or Table for Cost Accounting Distributions

Opkey PA

Hi Team,

Need a table which stores the information of Cost Accounting Distributions.

Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organization, Cost Book.

Attached screenshot below for reference.

Thanks.

Find more posts tagged with

Reporting

SQL

BI Publisher Report Templates

Fusion SCM Analytics

Accepted answers

Sinduja Sekar-Oracle

Hi @OpKey-SURGE ,

Thanks for posting your question in Oracle Communities. While we transfer this post to the correct forum, please check the below KM note if it helps:
Fusion CST: SQL That Can Fetch All The Records From Review Cost Accounting Distributions UI (Doc ID 2688621.1)

All comments

Sinduja Sekar-Oracle

@Emily Cikovsky-Oracle Could you please help to transfer this post to Fusion forum.

Sinduja Sekar-Oracle

Hi @OpKey-SURGE ,

Jayant Ajayrao Deshmukh

Hi @Opkey PA

In Oracle Cloud, the relevant table for storing information about Cost Accounting Distributions is CC_COST_DISTRIBUTIONS. This table includes various columns that capture the details of cost accounting distributions, including:

RUN_CONTROL_ID: Identifier for the run control.
PREPROCESSOR_STATUS: Status of the preprocessing step.
COST_PROCESSOR_STATUS: Status of the cost processing.
COST_ORGANIZATION_ID: Identifier for the cost organization.
COST_BOOK_ID: Identifier for the cost book.

You can query this table to retrieve the required information. Here’s a sample SQL query to get you started:

sqlCopy codeSELECT RUN_CONTROL_ID,        PREPROCESSOR_STATUS,        COST_PROCESSOR_STATUS,        COST_ORGANIZATION_ID,        COST_BOOK_IDFROM CC_COST_DISTRIBUTIONS;

This query will return the necessary columns you are looking for in the cost accounting distributions. Make sure to check your specific Oracle Cloud implementation, as table names and structures can vary slightly.

For further details, you may want to refer to Oracle's documentation or forums related to Cost Accounting in Oracle Cloud.

Thanks and regards,

Jayant Deshmukh

Bhaskar Konar

Very helpful & useful information.

Thank you very much @Sinduja Sekar-Oracle & @Jayant Ajayrao Deshmukh!

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders

GTA 50