OTBI
Discussion List
-
Compare Standard Costs User Interface / OTBI ReportSummary: While using the Compare Standard Costs User Interface we have noticed that only partial data is shown and exported (limited to 34 rows). We have seen Oracle Not…Ananthakrishnan Swamikulathu-280587 3 views 2 comments 0 points Most recent by Ananthakrishnan Swamikulathu-280587 Costing -
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 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…
-
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 …
-
Report for Work Order VariancesSummary: Content (required): Client is looking for a report where they can see the split up of total variance cost. At distribution level system sums up variance cost (E…
-
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…
-
Costed Indented BOM report?Summary: We're in need of what in EBS was a Costed Indented BOM report which ties out to the rolled up costs for a given assembly/scenario combination. It should, ideall…
-
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… -
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 …
-
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 …