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.

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)

Sinduja Sekar-Oracle

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

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