OTBI
Discussion List
-
Employee Assignments Processed in a 'Calculate Payroll' RunHi, does anyone have an SQL/Data Model to list all employees processed through a 'Calculate Payroll' Run or know which tables i would need to use? -
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…
-
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …Gefen 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 33 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 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Enable Procurement Dashboard under Procurement tab in Oracle Fusion Cloud instanceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…GaneshBhor 41 views 3 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
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…
-
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 257 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 87 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… -
Cloud Bi Bursting report output showing each email [external] in mail inbox, how to correct.Hi all, we have cloud Bi bursting report output, showing each email subject [external] in mailbox. How to remove external description. Kindly guide me.
-
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… -
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 31 views 5 comments 0 points Most recent by Linda Chirash Reporting and Analytics for HCM