OTBI
Discussion List
-
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… -
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…
-
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…
-
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 …
-
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 …
-
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… -
Looking for the ESS JO History Report Or Avilable ESS Job tablesSummary Looking for the ESS JO History Report Or Avilable ESS Job tablesContent Looking for the ESS JO History Report Or Avilable ESS Job tables Version 19 B -
Inventory Costing reportSummary is there any Inventory Costing report ?Content We want to print Inventory Costing report, where we have the total costing of the items in our inventory is there … -
How to exclude one PO item cost in work order costsSummary How to exclude one PO item cost in work order costsContent We have an OSP PO with multiple items, we need to exclude one item of the PO in the work order. The re…
-
PO Accrual Report - Requester Name Issue.Summary PO Accrual Report - Requester Name Issue.Content Hi All, When I inactivate terminated users in Oracle, this report is removing their name on requisitions even th…