Costing
Discussion List
-
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 -
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 173 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-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 184 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 62 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 21 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 52 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 373 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 245 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 151 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 1 view 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Change functionality so that the TO Return only have cost when the Organization confirms the ReceiptSummary: In Oracle Cloud we realized that there is a case where Transfer Order Return transactions establish a cost even when the Destination Organization does not confi…José Rojas Hernandez 31 views 7 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3… -
Custom Allocation with IF condition in PCMCSSummary Syntax for Custom allocation using IF conditionContent Hi Everyone, I have a requirement in PCMCS where custom allocation should happen using if condition. can s…Avinash B-140267 264 views 4 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
Can we have a different natural account based on sales order type for COGSSummary: Can we have a different natural account based on sales order type for COGS Content (required): We are having a business scenario where we need COGS accounts to …Sesha Sailini 31 views 1 comment 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
Allocation rules take too much time in EPCM and throw a warning messageSummary: Some Allocation rules take too much time in EPCM and result in an error/warning message Content (required): I have encountered this issue in which allocation ru…Gomaa Abdel Hamid Mansy 192 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management