Inventory and Cost Management Analytics Cloud
Discussion List
-
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 -
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 36 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.
-
How to add material overhead in percentage-Standard CostHow to add material overhead in percentage for standard cost item?
-
Query to get Total Unit Cost from Review Item CostsSummary: Query to get Total Unit Cost from Review Item Costs Content (please ensure you mask any confidential information): I have tried following Oracle documentation i…
-
Make it Mandatory to Upload standard cost for new itemSummary: We have a business requirement to make it mandatory to upload standard cost when any new item is created. Currently what happens is Item is created, and orders …Sukanya Mukherjee 21 views 2 comments 0 points Most recent by Venkat Jagan Pakala-Support-Oracle Costing