Costing
Discussion List
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 171 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero (rounded down)Summary:Standard Cost Details Report (seeded) UI output shows Unit Cost as Zero but Excel export shows correct value. Analytics > Run Standard Cost Details seeded report…Maria Angelica Mendoza 26 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Reporting and Analytics for SCM -
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there a way to create Counterparty transactions in EPCM?Summay: For EPCM Transfer Pricing based Application, we want to create counterparty entries of Transfer Pricing Results. Content (required): If Transfer Pricing Results …Sivavignesh V 81 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
No Markup in category based Global POWe have the Global Procurement scenario wherein we have created the Requisition BU - UK Procurement BU - US Sold to LE - US This is category-based PO (no item) scenario …Pradeep Kumar Goyal 1 view 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
No Markup in category based Global POWe have the Global Procurement scenario wherein we have created the Requisition BU - UK Procurement BU - US Sold to LE - US This is category-based PO (no item) scenario …Pradeep Kumar Goyal 11 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
IPM insights for EPCMSSummary: Aug 2024 update supports IPM Insights for EPCMS and will this be same as per planning? Content (please ensure you mask any confidential information): IPM Insigh…
-
How to Get the Detail of Pending Cost Processing including 0 Cost By REST APIHow to Get the Pending Cost processing including 0 Cost Items By REST API.Kailash Joshi 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Cost Roll-up for Items transferred across multiple plantsHi Oracle CC, We have a scenario where make-item routings span across various organizations. Components and subassemblies get processed in one org, and the semi-finished…Neha A. 14 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 71 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
SQL query or Table for Cost Accounting DistributionsHi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organizat…
-
PCMCS Out-of-the-Box (OOTB): 4.TraceabilitySummary Traceability and transparency within PCMCS - Out of the box featuresContent Traceability is the buzz word in any regulated industry. Being able to prove the numb… -
Can we get Accrual Account details from "Distribution Detail by Account" seeded OTBI reportSummary: Business needs to view Accrual Account details from "Distribution Detail by Account" seeded OTBI report is that possible. If I query I can not view the details …Naga Varma 11 views 1 comment 0 points Most recent by Mohamedtaha-Oracle Reporting and Analytics for SCM
-
How to sum (group by) more than one column on OTBII need to create a custom column that aggregates WIP balance by both WO and Cost element. I can create sum(wip balance by wo) and sum(wip balance by cost element) but th…G.Engelmann 191 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Create accounting error in Cost ManagementHello, Our Create Accounting processes for Cost Management are resulting in Warning status due to a limited amount of transactions containing a Warning message. So far w…Francisco Carrillo-Robles 73 views 3 comments 0 points Most recent by Richa Arora-Oracle Subledger Accounting & Accounting Hub
-
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…Sukanya Mukherjee 23 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Reporting and Analytics for SCM -
Oracle Cloud Item Transactions Without a CostHello, We are having trouble closing costing periods due to issues relating to item transaction costs being '0' and we are unable to figure out the cause. We have to fix…
-
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 51 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 371 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
UDA in EPCM ruleSummary: Can i use UDA in EPCM to filter on the source dimension? I am only getting Attribute option to filter on rules. Content (please ensure you mask any confidential…Nilotpal Bhaskar 43 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Need Tables for Cost Transactions Depletion Layer DetailsSummary: I'm looking for tables for Cost Transactions Depletion Layer Details as in the screenshot below. Content (please ensure you mask any confidential information): …Kunal Verma 263 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Generate Burden for imported cost (This question raised in Project management).Summary: Hi Team, Can you let me know how to process Burden cost with expenditure line? We ran the Generate Burden cost program but it shows null values in the report. C…Prathishver B 11 views 1 comment 0 points Most recent by Mark Zacchilli-Support-Oracle Profitability and Cost Management -
I have traceability requirement in EPCM. Any design suggestion or recommendation to achieve this.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nilotpal Bhaskar 31 views 2 comments 0 points Most recent by Nilotpal Bhaskar Profitability and Cost Management
-
Is it possible to fetch historic On hand balances with it's costsSummary: We have a requirement that the business user wants to see backdated on-hand balances (Opening balances) with it's associated costs, i couldn't find any document…Mohamed Taher-Oracle 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Oracle fusion INV_MATERIAL_TXNS table's ACCT_PERIOD_ID column not populatedSummary: We are designing a DataWarehouse for fusion SCM and we notice that ACCT_PERIOD_ID column from INV_MATERIAL_TXNS table is not populated Content (please ensure yo…Emel Serpegean-Oracle 161 views 4 comments 0 points Most recent by Emel Serpegean-Oracle Reporting and Analytics for SCM
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report.Assem Khaled 2 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM