Inventory and Cost Management Analytics Cloud
Discussion List
-
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 74 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…
-
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… -
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…
-
What input source should be used in the Mapping set in SLA for the account alias inventory MiscSummary: What input source should be used in the Mapping set in SLA for the account alias inventory Miscellaneous Transaction We create a miscellaneous transaction with …
-
How to create a Perpetual Average Cost without using PO Receipt or Miscellaneous TransactionHi Oracle, Please help me out with this question: How to create a Perpetual Average Cost without using PO Receipt or Miscellaneous Transaction? Thank you, Javier Zakzuk -
NullPointer Exception on the Shipment Lines pageSummary: I receive this error message once every couple of days when trying to split a line. When these error happens, I have to cancel out, go back to the inventory man…
-
Profit center Business Unit to party relationship throws a NullPointer errorWe've setup a new Business unit "PBSC" for which SCFO has to be configured but somehow the setup Manage Profit center Business Unit to Party Relationship throws an error…
-
seeded report for Standard costHi, Is there any seeded report Standard cost rollup with each element wise cost. Standard cost price variance report for items.