OTBI
Discussion List
-
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 -
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 5 views 2 comments 0 points Most recent by Mamatha P-Oracle Reporting and Analytics for HCM
-
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 4 views 0 comments 0 points Started by Pranav Waichal 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 291 views 13 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 41 views 7 comments 0 points Most recent by Banashri 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 69 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 14 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 35 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 15 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 15 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 28 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 69 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.4K views 183 comments 126 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 202 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult…Denise Izzi 17 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…Rama123-Oracle 15 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …Amanda Hope 28 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 10 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
custom email - how to add a link to access the systemSummary: Hi all, I would like to create a custom email. in the text of this email I would like to insert a link to access the system. in particular, I would like to inse…Alessandro Nesi 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…