Inventory and Cost Management Analytics Cloud
Discussion List
-
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…
-
SLA Source for Interorg Transaction Types/In-Transit Transfer OrdersThe Oracle defined mapping set for Trade clearing and Interorganization receivables transaction types to account trade-in-transit receipt and and trade-in-transit issue …
-
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… -
Processing Shipping Cost in Cost Accounting and COGSSummary How can I see the Shipping Cost in Cost Accounting and where?Content Business Case: I have a sales order, and create a pick wave, perform pick confirm. Before I … -
Inventory Infolet On Hand Value Versus Review Inventory ValuationSummary: Infolet shows 49.7K value today, during Oct-23 period and Review Inventory Valuation shows no value for OCT-23 period. These screens should show the Inventory v… -
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…
-
How to join Cost Accounting Real Time and Inventory Transactions Real Time in OTBI reporting?Summary: We have a requirement to create a report to identify latest inventory transactions for item in a Inventory Organization-Subinventory combination. This report ne…
-
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 -
Cost Accounting Period End Error Out -The transfer of transactions from source systems is pending.Summary Period Closure validation process error - Exceptions shows "The transfer of transactions from source systems is pending."Content When the user tried closing the …
-
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 … -
SCM – Demystify Consigned Inventory Accounting, 3 June 2020, 0 a.m. PT - Submit QuestionsContent Submit your questions for the SCM – Demystify Consigned Inventory Accounting session to have them answered during the live event. Post your questions by posting …
-
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 31 views 4 comments 0 points Most recent by Venkat Jagan Pakala-Suppot-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…
-
Need to change natural account generated in the Journal entry of Cost accountingSummary: The scenario: An Item is created and the category assigned is wrong. The Miscellaneous Receipt transaction was done by the user for that particular item. The Jo…
-
Kindly request excel visual builder template for create trade operation,charge line,charge referenceSummary: How to create trade operation, charge lines, charge references and associate PO using visual builder? Please provide template Content (please ensure you mask an… -
Return Receipt To Supplier API RESTSummary: Using api rest, Is there any api rest to do the same steps that I've listed? If so, Could you provide the apis an examples about how to consume it please? Conte…
-
How to achieve Locator level costing for Average costing in Oracle FusionSummary: Hi All, How to achieve Locator level costing for Average costing in Oracle Fusion. Kindly suggest a way to achieve costing details at Locator level Content (ple…
-
Receipt Accounting for receipt corrections moving to the next periodSummary: Receipt Accounting for receipt corrections moving to the next period Content (required): We are seeing cases where personnel are entering receipts and then corr…