OTBI
Discussion List
-
Unable to see 'Costing - Inventory Valuation Real Time' under OTBI subject areaSummary: I am unable to see 'Costing - Inventory Valuation Real Time' under OTBI subject area. Here is the document I am referring to. I do have Cost Accountant role tha…
-
Costing - Item Cost Real Time" subject area replaced with "Costing -Standard Cost Real TimeSummary: Subject Area name and function appears to have slightly changed. We can no longer find the SA called "Costing - Item Cost Real Time", but instead it appears to …
-
sql query to extract standard cost details in FBDISummary: I need to extract item standard cost details for a particular valuation unit in the same format as FBDI templates for item standard cost and then upload it to a…
-
Stock Value AgingSummary: Stock Value Aging Content (please ensure you mask any confidential information): Hi, Can someone please inform me the query or tables/fields involve in calculat…
-
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…
-
Why doesn't the Costed BOM (Cost Element) report show all the accumulated elements?Summary: The Costed BOM (Cost Element) report does not display all cost elements that were used in rollup. The report shows a total cost of the item of 6123.92119 In the…
-
Costs for goods sold was not available in analyze product gross margin reportSummary Costs for goods sold was not available in analyze product gross margin reportContent Hi Costs for goods sold was not available in analyze product gross margin re…
-
Overhead accounting rule at LOT levelSummary Overhead accounting rule at LOT levelContent Hi, We have overhead accounting rules at LOT level to include additional charges in the work order cost. We didn't h…
-
How to fetch the Opening and Closing balances(quantity and value)Summary: We are trying to develop a report where we can fetch the Opening and Closing Balance(quantity and value) over a period of time. We are not able to find the requ…
-
How to update the Item Cost to the last Receipt CostSummary: How to update the Item Cost to the last Receipt Cost Content (required): As per the business, they maintain the cost on the basis on the basis of last received …
-
want a Query to fetch the elements which don't have costing details.Summary can you share a query to fetch elements list which don't have costing details? Content (required): can you share a query to fetch elements list which don't have …
-
Options for removing receipts and partially invoiced items from the Period End Accrual ReportSummary: What are Options for removing receipts and partially invoiced items from the Period End Accrual Report Content (required): What are Options for removing receipt…
-
Best Way to export Cost Accounting Distribution with Concatenated Accounting SegmentSummary: Costing - Cost Accounting Real Time Content (required): Hello Friends We are trying to use OTBI Subject Area "Costing - Cost Accounting Real Time" to export Cos…
-
Required to create a report to capture Trade Operations and related PO's in OTBISummary: We are required to maintain a report to capture the Trade Operations and the related Purchase Orders. The report should also capture the status of the Trade Ope…
-
What is the date will be used in conversion from transactional currency to functional currencySummary: Hi Team, Could you please help with below one. what is the date(Transaction created or transaction received date) will be used in conversion to convert amount f…
-
OTBI REPORT EXPORTS STOPS AT 25000 ROWS IN EXCEL AND 75000 ROWS IN CSVSummary: Content (required): Hello Friends, We are using "Costing- Cost Accounting Real time " Subject Area to export transaction along with Account # for a month durati…
-
Uninvoiced Receipt Accrual ReportSummary: Uninvoiced Receipt Accrual Report Content (required): Report completed in error when submitted since upgrade to 22A. How do we resolve this error Version (inclu…
-
Inventory transactions accounting summary report to match with GL balanceSummary: Inventory transactions accounting summary report to match with GL balance Content (required): We have a report requirement to see the account distribution summa…
-
Report to show accruals created against each business unitSummary: We have 100+ procurement business units . During the period close (period end accruals) , it is difficult to run the un invoiced receipt accrual report for each…
-
BOM Cost Report for Average costingSummary: Customer is requesting for a BOM Cost report. But the available one in OTBI is applicable for Standard Costing (as Scenario information is required as parameter…
-
Recap of Ideas related to Audit Policies and audit logging abilitiesContent Following is a list of over 40 Ideas related to Audit Policies that we and others have logged. Most of these are essential to have complete audit logs; what we w…
-
OTBI Report On-Hand Inventory Value is Not matching with Inventory Valuation ReportSummary OTBI Report On-Hand Inventory Value is Not matching with Inventory Valuation ReportContent Hi, I have designed the OTBI report, to display the Current on-hand va…
-
How to know total inventory consumption during the period along with quantity, unit cost and amount.Summary How to know the total consumption during the period Item wise or Inventory Org wise along with quantity, unit cost and consumption amount.Content Hi Team We want…
-
Inventory Turns ReportContent Team, In Inventory Turns Report, the 'Days sale of Inventory' formulae is '(start date - end date) / inventory turns' as per below document https://www.oracle.co…
-
Unit Cost of an Item for OTBI reportContent Hi I am create an OTBI report and required the Unit cost of an items. I am using "Costing - Item Cost Real Time" subject area, but its showing multiple rates. I …
-
UOM Convesion from OTBI subject ateaContent Hi Expert I want to Convert UOM code from BAG to EA (UOM Converted to EA) using OTBI Subject area.Can you please let me know do you have any idea on UOM conversi…
-
Costing White PaperSummary Costing White PaperContent Do any one of you can share the white paper which has all details of the flow of Standard and Average costing? appreciate if you can s…
-
Query for Cost for an itemSummary Query for Cost for an item and navigation to check the cost for an item in the pageContent Which table stores the cost for an item and where we can see the cost …
-
How to view the accounting entries for AP invoice in Receipt AccountingSummary How to view the accounting entries for AP invoice in Receipt AccountingContent How to view the accounting entries for AP invoice in Receipt Accounting module. Th…
-
Help needed to extract the Item Cost of items in an Inventory org, inorder to identify whether the iSummary Help needed to extract the Item Cost of items in an Inventory org, inorder to identify whether the item as a cost for an Average cost Org.Content Help needed to …