OTBI
Discussion List
-
Reporting Field for Acknowledgement Comments on Performance ReviewSummary We would like to know the field name (if reportable) for the comments entered by an employee when acknowledging their performance review.Content We have a busine…User_2025-01-30-23-46-38-098 76 views 6 comments 1 point Most recent by Aprajita Gokhale Reporting and Analytics for HCM -
What table/field is Customers->Tax profile->Controls and Defaults ->Tax Classification CodeI'm trying to find a table that contains the tax xlassification code field which is in the customer site → tax profile → controls and defaults -
Query to retrieve Trade Operation and corresponding PO detailsSummary: Content (required): Hi, There is a requirement to create a report that displays the following columns; Trade Operation number Trade Operation Name Created By Us… -
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…
-
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l…User_XWNJM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …Sheetal VBCS 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there a function accepted in OTBI to print FIRST ROW of values?Summary: Summary: I would like to Print all Invited Suppliers and selected Sites with site adress and site email but if Contact is blank in Negociation, only print first…VDM_IM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Requisition Unprocessed daysSummary: Difference between OTBI Requisition- Unprocessed days in Line detail and Unprocessed days in the Line folder Content (please ensure you mask any confidential in…Rajesh7d 11 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Table to get "Reference Type" in depletion layer?Summary: I am looking for a table that contains the "Reference Type" field in the depletion layer as in the screenshot below. thanks in advance! Content (please ensure y…Edgar11 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Issues while displaying Calnedar View in OTBISummary: Unable to call https://www.gstatic.com/charts/loader.js using Narrative view in OTBI Content (please ensure you mask any confidential information): We have a re…Sahil_Makhiza 11 views 0 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM
-
Extract "Manage Default Access" (Learner Self-Service Settings - Active Mode) via OTBI?We’re trying to build an OTBI report to identify courses and offerings where Learner Self-Service Settings are marked as Active—both at the Course level and Offering lev…
-
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar…User_F89L9 254 views 5 comments 2 points Most recent by Sasank Reddyy Reporting and Analytics for HCM
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…Brian Burns 88 views 5 comments 5 points Most recent by daniel.valdovinos Reporting and Analytics for ERP -
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1.4K views 17 comments 4 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
The learning course completion certificate should be automatically placed in the employee's DOR?Summary: I have an requirement like after completing the learning course by employee, employee will get a course completion certificate. That course completion certifica… -
Can I change the date format in the BI Publisher data model to 'DD/MON/YYYY'?Summary: In the Fusion, publisher reporting → data model→ SQL Query "select to_char(to_date('12/09/2024','DD/MM/YYYY'),'DD/MON/YYYY') from dual;". It always returns 12/0…
-
Need inputs to fetch the Absence "Plan Use" informationSummary: Need inputs to fetch the Absence "Plan Use" information Content (please ensure you mask any confidential information): In the absence records, we need to fetch …
-
Supplier real time contact developed through OTBIWe have developed a report using OTBI to extract supplier details using Supplier - Supplier Real Time. Use case: Each supplier have two sites (US and CA) and one contact…Vignesh_Gunasekaran 24 views 0 comments 0 points Most recent by Vignesh_Gunasekaran Supplier Management -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.8K views 21 comments 3 points Most recent by Raymund J Reporting and Analytics for HCM
-
How to Add PO Charge Account on OTBI Report using Payables Invoices - Transactions Real Time when POSummary: How to Add PO Charge Account on OTBI Report using Payables Invoices - Transactions Real Time when PO is set to Accrue on Receipt. Invoice Distribution Concatena…
-
Redwood Issuing Comments field in Document Record Displays html Text in OTBISummary: We just implemented Redwood for Document Records. The Redwood field for Issuing Comments (seeded Oracle field) displays as a rich text editor field where bold, …Linda Chirash 36 views 5 comments 0 points Most recent by Linda Chirash Reporting and Analytics for HCM
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 1 view 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM -
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 281 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
how to add Cash Advance liquidation 'Due date' in OTBI report?In Auditing stage, the expense auditor need to manual input the Due Date of Cash Advance. We want this Due Date field to be added in OTBI report for monitoring purposes
-
OTBI - Legal Employers that use this jobSummary: OTBI - Legal Employers that use this job Content (please ensure you mask any confidential information): Subject Area: Workforce Management - Worker Assignment R…Julie S. 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM