OTBI
Discussion List
-
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem…
-
Tables for a 5-Bucket Inventory Aging ReportSummary: We are developing the Inventory Aging Report which contains 5 buckets. We require the information for tables that are required to develop the report. Content (p…
-
PO which got interfaced to LCMSummary: There is one requirement from client, Do we have report in which we can get list of PO which has not interfaced to LCM or list of PO for which Trade operation i…
-
Standard Costing reportsSummary: Hi Team, Do we have a place where we can get the list of all standard reports that exists in costing today . say it as a repository where I can have the excel t…
-
No Results for Supply Chain Rollup Costed BOM ReportSummary: We are not seeing any results for the new subject area, Costing - Supply Chain Cost Rollup Real Time, that supplies results to the Supply Chain Rollup Costed BO…
-
Inventory Accrual ReportSummary: The Finance Department has no data on inventory accruals to as certain as to whether accrued inventory are being offset and balanced. Is there any seeded report…
-
SQL query or Table for Cost Accounting DistributionsHi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organizat…
-
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…
-
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 …
-
How to check what all Oracle Applications modules are implemented in oracle fusionSummary: Hi Team, Is there anyway to get the details of all the modules being used in an oracle fusion instance? Either any table that stores the data related to impleme…
-
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…
-
OTBI - Which Subject Area/field provides "Total Unit Cost" value from "Review Item Costs" UI?Hi folks, I'm struggling to find the correct subject area/field within OTBI that calculates the "Total Unit Cost" shown in the "Review Item Costs" UI (Supply Chain Execu…
-
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.
-
Report for item cost with trade operationsSummary: We need to have like a precosting and final costing report. Precosting is that before receiving we need to know what is the price that the item will cost us wit…
-
How to get similar columns in CST_COSTED_VU_COSTS_V since it is deprecated from 23C?Summary: Hi All, I have developed a query using CST_COSTED_VU_COSTS_V view but since it is deprecated from 23C I need a new table to get the columns. The replacement tab…
-
During which process the Unit cost will get updated in the Costing back end tableSummary: Hello Oracle Experts! Recently we faced an issue in fetching the Unit cost from the back end costing table. When we do an Intransit receipt for a particular ite…
-
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 …
-
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 31 views 3 comments 0 points Most recent by Ananthakrishnan Swamikulathu-280587 Costing
-
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 …
-
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…