OTBI
Discussion List
-
OTBI Filter Criteriaanalysis result in error when no prompts are selected Errore Errore di visualizzazione della vista Errore durante l'elaborazione della query (SQLExecDirectW). Dettagli e…Rosita Santosuosso 14 views 0 comments 0 points Started by Rosita Santosuosso Reporting and Analytics for HCM -
Learning related subject areaI need to create report based on these inputs but I am unable to find relevant columns from the learning related subject areas. I am not aware of the proper columns.
-
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 232 views 7 comments 0 points Most recent by Gillian Kilbride Reporting and Analytics for HCM -
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
How to show custom dashboards under Dashboard Header Menu in Oracle Fusion Report & AnalyticsI have created custom dashboard and I want show that dashboard under Dashboard Header Menu as attached Help me how to achieve it. How to add custom dashboard to Existing…
-
V3 Seniority date pulling old assignment detailsSummary: We are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Per…Sreeraj Kavallore Sujith 19 views 2 comments 0 points Most recent by Sreeraj Kavallore Sujith Reporting and Analytics for HCM
-
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 141 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM
-
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl…Gail Langendorf-Oracle 321 views 15 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 33 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not …Rajib_Samanta 296 views 20 comments 0 points Most recent by Jacqueline Mellonas Reporting and Analytics for HCM -
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Labelling issue for Percentage Bar graphSummary: My client has created Graphs for OTBI report data as part of requirement and what we see in one of our Percentage bar graphs is we are not getting the expected …Mamatha P-Oracle 11 views 8 comments 0 points Most recent by Mamatha P-Oracle Reporting and Analytics for HCM
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 295 views 10 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 65 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
OTBI Agent Returns 25,001 RecordsSummary OTBI Agent Returns 25,001 RecordsContent I created an OTBI analysis. Then, I created an agent that runs the analysis. I schedule the agent and request the format…Daniel McMillian 97 views 7 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in…Katharina_Seidenfuß 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 28 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Unable to get requisition number value when combining with assignment subject areaSummary: Please find the report catalog , unable to see the value for Requisition number. I'm combining below three subject areas and for Recruiting I'm using Number of …
-
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p…Nicolas-Vahman 41 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User unable to view Employee's address details in OTBI ReportsHi Experts, We have created a report using the subject area 'Workforce Management - Worker Assignment Real Time'. We got the other cloumn values except city, county, sta…
-
Is there a way to filter this way in OTBI?Summary: Content (please ensure you mask any confidential information): I'm extracting columnA from a table. It has both null and not null values. »»»Filter should only …Stefano_Mazzocca 11 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Outage for Import Oracle Fusion Data Extensions for Transactional Business Intelligence?On the documentation page discussing importing DFF fields using Import Oracle Fusion Data Extensions for Transactional Business Intelligence it mentions "Running the pro…Angela Montenaro 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)…
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
Is there a way line managers can view element entries?Summary: Is there any way line managers can view reports with element entries? I'd like to create an overtime report so they can monitor their reportees claims but it do…
-
How to retrieve AS$_ATTRIBUTE7 in OTBI?Summary: I'm looking for assignment descriptive flexfields and I'm using "Workforce Management - Person Real Time" subject area Content (please ensure you mask any confi…Stefano_Mazzocca 22 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 77 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 41.8K views 183 comments 126 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM