Inventory and Cost Management Analytics Cloud
Discussion List
-
What are the initial key points in data collection for creating movement requests?Hello, I know some key points: Subinventory Name and Description Approvals and notifications (Approvers and FYI Participants) What are the key points left in cost accoun… -
How is opening balance account cleared after the onhand balances are uploaded?Hi Folks, Can somebody help me understand how the opening balance account is cleared after the onhand balances (for onhand inventory conversion) are uploaded? -
Intercompany Margin EliminationSummary How do we eliminate the profit in Inventory /gross margin arises out of Intercompany sales/ transfers at transfer price across Inventory organization underneath … -
Is there a way to add the Item Description in the Review Inventory Valuation under Cost AccountingSummary: Finance users are having a challenge to review the Review Inventory Valuation report for the item details since it has only the Item Number. Can the item descri… -
All accounting entries for Transfer OrderSummary: Report or dashboard to view all accounting entries related to a Transfer Order Content (please ensure you mask any confidential information): We are looking for… -
how WIP balance calculatedHi, How Wip balance is calculated for Work order. While complete work order partially some amount get parked in WIP Balance. thes amount get adjusted when we close Work …
-
Rule Update issue using REST APISummary: Hi We are trying update Rate, From date and To date for Rule Id . Can you please help for this issue? /fscmRestApi/resources/11.13.18.05/costAccountingOverheadR…
-
how to get Subinventory CodeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Work Order " WIP Job close" costing event errorContent Hello Experts, I am getting Cost distributions - Accounting status error for the "Work in Process Job close" event. Please give your suggestions to overcome this… -
Sources for Exchange variance adjustment Rule in Event Type Invoice Price for Receipt AccountingSummary: Sources for Exchange variance adjustment Rule in Event Type Invoice Price for Receipt Accounting In Receipt Accounting Accounting class Exchange variance adjust…
-
Creating custom report through OTBI.Summary: Need replacement view for CST_COSTED_VU_COSTS_MV. Used CST_VU_ONHAND_VALUATIONS but this is when we have on hand only. We are looking for actual cost of all ite…
-
Receipt number is not displayed in cmr_rcv_transactions table in Accrual Reconciliation report.We are developing a custom report which is a xerox of standard Accrual Reconciliation Report. Our client requirement is in below transaction types they want receipt numb…
-
how to update resource cost in Average costingSummary: 1.We are using Costing method as Perpetual costing and using Maintenance module. 2. We have defined a cost scenario and updated the resource rates defined as 50…
-
Provisional completion with Value at last actual cost in Actual Cost Method?Summary: In the above mentioned scenario (Provisional completion with Value at last actual cost in Actual Cost Method), Our understanding is that the FG cost remains sam… -
SCM Event types descriptionSummary: Is there Oracle documentation on what each SCM Event Type is (description, accounting impact, etc.)? Content (please ensure you mask any confidential informatio… -
Is there a report to get the lines ready for picking before we run pick release?Summary: We want to check the list of items prior to running pick release (that performs reservation) to know which lines would be pick released. Basically we need to ru…
-
Adjust Accruals if multiple accrual entries are found in "Audit Receipt Accrual Clearing Balances"Summary: We are seeing multiple entries in "Audit Receipt Accrual Clearing Balances" for single PO. This is happening because Accrual account on PO/Receipt is different …
-
Where can we define the Unit CostHello, where can I define this cost? Please if you can share the navigation. Thank you
-
Need SQL query to fetch the details of Item Number detailsSummary: We need a SQL query to fetch the Item Number, Inventory item id, Unit cost, Total cost, Sub inventory code, organization name & Quantity of Items. Kindly let us…
-
How the"Recoginized cost of goods sold percentage"calculated on the Analyze Product Gross Margins UISummary: How the "Recoginized cost of goods sold percentage" got calculated on the Analyze Product Gross Margins UI Content (please ensure you mask any confidential info… -
The latest issue transaction is not getting costed by cost distributionsSummary: As per the below note, we performed all the transactions. Everything worked fine for the old stuck transaction. But the newly created Misc Issue transaction to …
-
Need a Script to find out which items are causing cost rollup errorSummary: Need a Script to find out which items are causing cost rollup error Content (please ensure you mask any confidential information): There are over 800 components…
-
START_DATE column value is always 1st day of the month on Costing tablesSummary: We noticed that the START_DATE column value in the CST_VU_ONHAND_VALUATIONS and CST_ATTR_ONHAND_VALUATIONS tables is always the 1st of the month. May we confirm…
-
Project DFF sources are not working in deriving SLA for Miscellaneous transactionSummary: Miscellaneous receipt for the project, attempting to derive SLA from project DFF but sources are not working. Below are the attributes used. Project attribute 2…
-
Unable to get Resource Cost distribution from Work Order that has project detailsSummary: When i execute a work order with project details, i do not get resource cost distribution of that particular work order. But when i execute the work order with … -
Do we need to take any actions on transaction with scrap type？Summary: We found a transaction with scrap type, we have no idea how to deal with it, is there anyone could advise what should we do with it? Thanks a lot. Content (plea…
-
Assessable Value on the Completed TransactionsHello all As per Oracle functionality, Assessable Value is based on the total transfer price for the item on the Transfer Order transaction line. Checking further, total…
-
Accrual clearing Account RulesWe created an Accrual clearing account rule to clear amounts in the "Manage Accrual Clearing Rules" when “AccrualLine.Accrual Clear Amount” is 0. Despite running “Clear …
-
What is the condition mentioned in Invoice Price Variance accounting ruleSummary: Hi All, Could you please confirm what is meaning of highlighted condition for "Invoice Price Variance" accounting rule? We have not setup any mapping set (as pe…Santhosh kumar Munagapati 71 views 4 comments 0 points Most recent by Venkat Jagan Pakala-Support-Oracle Costing
-
How is the Accounted date calculated in the case of back dated Inventory TransactionsSummary: Hello Oracle Experts! In the case of back dated Inventory Transactions we can able to understand how the costed date is calculated (sequentially after the the l…