OTBI
Discussion List
-
AP Invoice Validation Status DescriptionSummary: we have developed a OTBI report for Invoice details. While reviewing the report we noticed that there are a variety of validation status for Invoices. In order …Sathish Ravi 1.3K views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Payables, Payments & Cash Management -
OTBI - can we apply case condition on columns from different subject areas ?Summary: CASE WHEN SA1.COl1 = 'Y' THEN SA1.COL2. ELSE SA2.COL1 END ; The above is not working as expected. Does OTBI supports CASE condition on multiple subject areas or…Sridhar Gupta Yerram-Oracle 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Summary: How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Sridhar Gupta Yerram-Oracle 1 view 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
How to remove the privileges that are caught up in the ERP license count from the job roleHello, We tested and found the follows when trying to assign roles for OTBI report access. For the OTBI reports that spans business areas, there are some that cannot be …
-
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…
-
Is there any OTBI report that I can include the Employee bank account informationSummary: Is there any OTBI report (subject area) that I can include the Employee bank account information? Content (please ensure you mask any confidential information):…
-
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…Sean-B-01 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How can we identify the columns for Employee comments and manager comments in the OTBI Report?The issue we're facing is that we are unable to locate the columns for employee comments and manager comments in the OTBI subject areas in order to retrieve the accurate…Vikas V. Kamat 101 views 3 comments 0 points Most recent by Thulasi Ram Reporting and Analytics for HCM
-
Why Fusion and OTBI report gives different Validation StatusIn OTBI I use the MATCH_STATUS_FLAG from AP_INVOICE_DISTRIBUTIONS_ALL to get the validation status. A - Validated Null - Never / Not Validated T - Needs Revalidation Is …Alvin 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
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…
-
project descriptive flexfield not available in otbiWe have a project descriptive flexfield (project foundation) which is context based. We have marked the context and segments as BI enabled and also provided labels for t…
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 2K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
icp sortingHi, I am trying to sort the icp column so that the recurring records comes first and with in recurring records the latest records comes first and after recurring the non…
-
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj…Curtis Allen 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
How can I get the image of products in report OTBI Query?I want to get the images uploaded in the Product Information Management module for a report using a query, I have the following query, but I have not been able to get th…
-
How to create report on employee project manager ?Summary: Hello, For our Blue Collar Population we are using the role of Project manager in addition to the Line Manager. Our issue is that we don't find the subject area…LucieWS 21 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI report does not display data for a day because TC timezoneSummary: As per the Oracle white paper on Transaction Console, you can get up to 500 transactions in the downloaded csv file. It is a technical limitation that download …AmitSM 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no…User_2025-02-11-20-55-10-551 51 views 8 comments 0 points Most recent by Sanskriti Gupta Reporting and Analytics for HCM -
Payroll - Calculation Cards Real Time FieldsSummary Trying to find two specific fields withing Calculation Cards Subject Area: Issuing Authority and Order Amount Payee.Content I am working on building a report for…
-
How to enable line of business users to search and view purchase agreements informationSummary: Content (please ensure you mask any confidential information): Customer is asking for how non procurement agents can search for POs, Agreements and Suppliers. T… -
I need help on my SQL for With and Without Goals ReportSummary: Hi, I hope someone can help me with my query. Only the employees "With Goals" are showing up. The employees "Without Goals" is not showing up in the report. I n…
-
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
Error Codes: OAMP2OPY:U9KP7Q94 - OTBI AnalysisSummary: We have a weekly Analysis that runs via Agent. After running many times without issue each week, we are getting these errors: OAMP2OPY:U9KP7Q94 - "An Unexpected…User_2025-03-07-06-07-08-189 1.4K views 8 comments 0 points Most recent by User_U5PJ2 Reporting and Analytics for HCM
-
OTBI reporting errors after 25B release - Error generating view. Error getting cursor in GenerateSummary: After the 25B release on May 17th 2025, many of our reports are now failing to run, and presents error below. Reports which are run return a mixture of differen…Ray727 446 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Benefits OTBI Subject Area for Plan ID, Coverage Amount and Age Grade Rate.Summary: Hi Team, I am working on the OTBI reports for benefits module. Kindly suggest me the subject area for below mentioned columns. Benefits Plan ID Coverage Amount …D.Ashok 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Competency proficiency reporting - employee and manager ratingSummary: Hi there, I need help where to find the Employee rating for Competencies. The Manager rating is located in this folder "Workforce Performance - Performance Rati…
-
Looking for PO line quantity column in Purchasing Subject AreasSummary: I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing R…