Costing
Discussion List
-
Is there a way to exclude the LOTs on hold from Inventory ValuationSummary: Is there a way to exclude the LOT on hold from the Inventory Valuation? example quality hold ? Content (please ensure you mask any confidential information): Ve…Amrish_Amradkar 2 views 0 comments 0 points Started by Amrish_Amradkar Reporting and Analytics for SCM -
Web serivce API/SOAP to retreive item current cost and transaction cost by cost elementsSummary: Is there any API/SOAP to retrieve the item current cost and transaction cost by cost elements and not only total unit cost? Also, is the below API generated by …Abdul Karim OAMR 11 views 5 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
How can we create a custom events to trigger the integration flowSummary: How can we create a custom events to trigger the integration flow. if we click a release button for a project the integration need to trigger but i am unable to…Veera venkata satya Ranga Prasad 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI ERP Integrations
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
Review work order cost View Detailed balance UI: Need table for Cost Allocation FactorSummary: Hello Community, I'm developing one report related to manufacturing costing for which I need table name for Cost Allocation Factor. Any leads will be helpful. P…Ramya Dev 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
OTBI REPORT data retrieval for certain fields is not functioning as expected.Summary: I have developed an OTBI report for movement requests. I didn't get any data for the column "LEDGER AMOUNT". how to resolve this Subject Areas Utilized for OTBI…
-
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 51 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 21 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 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 1 view 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 102 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 73 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 12 views 1 comment 0 points Most recent by Arun Yadav - Support-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 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 205 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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): …User_HAMBL 162 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
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 142 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
-
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…
-
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Data not showing albeit correct rolesSummary: Data is not showing whilst creating an OTBI analysis Content (required): Data is not showing whilst creating an OTBI analysis for the Unit Cost Dimension althou…
-
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 746 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM -
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 917 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Cost Accounting Distribution TablesContent Hi Team, Can anyone help me with table name for all the transaction types and the cost distribution details present on attached screen. Regards Nidhi...Nidhi Chhajed 34 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 34 views 3 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM