OTBI
Discussion List
-
Failed to get creation date for Landed cost in OTBI ReportSummary: I have developed an OTBI report for Landed Cost. I didn't get any field for creation date, is that anyway to get this field please Content (please ensure you ma… -
Which Subject Area/field provides "entry type" of payroll cost results?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
OTBI report timeout error how to schedule OTBI reportHi All, In the OTBI report, we have a large number of records. It was running for 25 minutes successfully with my user credentials, but when using another user's credent…Karthikeyan s-Oracle 71 views 12 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
SQL Query to identify transactions stuck in Pending interface to costingSummary: Users had done Cycle Count Adjustment and before the transactions could get accounted the items were made 'Inactive' this was done across organization in past p…Rahul_M8SG8 41 views 6 comments 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing
-
How can I export procurement contract rules?Summary: I need a SQL query to export procurement contract rules Content (please ensure you mask any confidential information): Version (include the version you are usin…
-
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… -
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 …User_2025-02-08-00-15-22-284 1.4K views 18 comments 0 points Most recent by Arunkumar S-Oracle Costing -
locator name and lot number in costingunable to find the locator name filed in OTBI subject area "Costing - Cost Accounting Real Time", we are able to see locator id and locator description etc, we need loca…
-
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…
-
Roles and Privileges to run "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time"What Roles and Privileges to run "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time". There are two seeded roles linked to this task: Cost Accountant (O… -
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…
-
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 …
-
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…