OTBI
Discussion List
-
How to change the layout of Approval Notification e-mails for Purchase Requisitions?Summary We want to change the layout of the e-mail that is sent to the approver after the Purchase Requisition is createdContent Hello guys, We want to change the layout…Fernando Oka 68 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…User_2025-02-06-07-21-22-662 55 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Defaulting user currency preference in OTBISummary Can the currency preference in OTBI be set at system level?Content Currently users need to update the currency preference to see the data from Projects related s… -
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.User_2025-02-06-07-21-22-662 205 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
RetirementSummary Eligible to RetireContent To be eligible for the pension plan an employee has be to be aged 65 or meet the “magic 80” rule which is the employees’ start date + a…User_F1ZIP 38 views 8 comments 0 points Most recent by User_2025-02-05-05-51-12-049 Reporting and Analytics for HCM
-
Navigate to supplier profile from OTBI reports, including sample reportSummary Creating ad hoc OTBI reports with links to navigate to supplier profiles.Content The 19C feature: Navigate to Supplier Profile from Reports allows you to include…Aishwarya Pawar-Oracle 241 views 9 comments 9 points Most recent by Aishwarya Pawar-Oracle Supplier Management
-
NEW Analytics for ERP - 20ASummary NEW Analytics for ERP - 20AContent Hi, We have now 20A, but Oracle new buit in Analytics for ERP is not available, any idea on ERP analytics. Regards,Farooq Syed, CPA, PMP, CISA, TOGAF 87 views 3 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF Reporting and Analytics for ERP -
Issue with Annualized Salary in OTBISummary Anunaluzed Salary not showing up in OTBI analysisContent Hi - We are in the process of building/moving our BIP reports to analysis but have been encountering iss…Roy Paolo Paunlagui 49 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I can't see any secured reportsContent Hello Guys,The technical department has secured the reports in BI. My users cannot view the reports anymore, it seems as if they no longer exist. Is there any ro…Giuseppe Iacono 38 views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Export FRS reports as *.DES extension fileSummary Export FRS reports in 19D as *.DES extension fileContent Hi, Does anyone know how to export FRS reports as *.DES extension file ? Thnx Version R13 - 19D updatesAli Morsy-Oracle 168 views 1 comment 0 points Most recent by Hamish Vickers Reporting and Analytics for ERP
-
Net Available Item QuantitySummary Subject area for Reserved Quantity and Net Available QuantityContent Hello Team, We have to update our analysis report, please suggest which subject area in Inve…Saurabh Sharma_HCL 59 views 4 comments 0 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 91 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Improvement Ideas for BI Catalog UI / NavigationSummary BI Catalog UI ImprovementsContent Hi All, We at DHL are using HCM for few years already and we are looking to further exploit our data to provide intelligence an… -
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…User_2025-02-04-18-47-46-124 106 views 3 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Create a report for Areas of ResponsabilitiesContent Hi Guys, I need to realize a Report in order to extract: Person ID, Employee Name, Area Of Responsibility Name , Responsibility Type and Scope Of Responsibility.…Giuseppe Iacono 65 views 3 comments 1 point Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
Custom PO Balance report IssuesSummary BI Report is timing out with only one userContent Hello Guru's, There is a custom BI report which is getting time out error after running for certain time from i… -
OTBI Action Link not passing parameter when complex logical query is usedSummary OTBI Action Link not passing parameter to another BI Content when complex logical query is usedContent In general, if we create OTBI analysis from a single subje…
-
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
Error on Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationSummary Getting data model error while running Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationContent Hi All, Does anyone know what…