OTBI
Discussion List
-
Can someone help me how to apply Pivot in my OTBI Analysis?Summary: There are multiple values per employee. I want it to display in a single row, but one per column. Is it possible? Your help is so much appreciated. Content (req…Hazel De Castro 36 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please … -
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.…Evelina Hobson 6 views 0 comments 0 points Started by Evelina Hobson Reporting and Analytics for HCM -
OTBI - Static PDF attachment in email notificationSummary Is there any option to attach PDF in email notificationsContent Hello, We have a requirement to send email notification to new joiners along with user guides att…User_2025-02-05-07-43-29-505 74 views 8 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for HCM -
OTBI Report for Gross EarningSummary: Hi Can you please suggest if it is possible to create a report in OTBI that will provide gross earnings per element for a specific period? If it is possible, ca… -
Periodic Accrual in OTBI giving wrong valueSummary: Requirement is to create a OTBI report that has accrual plan balance and accrual value from last period. Plan is incremental so every period, employees accrue a… -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 519 views 5 comments 0 points Most recent by Madhavi Achyuta-Oracle Reporting and Analytics for HCM -
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all …Oriana L. 15 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th… -
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our … -
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom… -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! -
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a… -
Dashboard for PerformanceSummary: Can someone please share any performance dashboard they have built? The standard dashboard available in system is very basic and not at a level suitable for pre… -
Pending worker conversion date in OTBISummary: Pending worker conversion date in OTBI Content (required): Hi, we would like to know where (Subject Area - Folder - Field) we can have the possibility to extrac… -
OTBI Report not showing all the data thats in HCMSummary: Customised report not showing data for all employees but its in HCM Content (required): Hi We have a customised configuration for our DBS details. Up until last… -
OTBI report for Average allocation by Rating is giving 'No Result; however working for managerSummary: We have created custom OTBI report to display the Rating v/s Average Allocation %. The OTBI dashboard is created and the report is added to the dashboard sectio…Shruthi T 36 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 8 views 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM -
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 1K views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
Seeded Line Manager Role cannot view Future-Dated Hire Events in OTBIContent Hi, We have a report on a Line Manager Dashboard that looks at future-dated hires. For this, we are using the "Workforce Management - Worker Assignment Event Rea… -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i… -
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su… -
Display month name's with sorting in OTBI Analysis outputsSummary Display month name's in OTBI Analysis outputsContent Hello Team, I have created OTBI report in that month column value should be displayed like Jan, Feb, Mar, et…User_2025-07-18-14-08-42-473 167 views 7 comments 0 points Most recent by Hari S Reporting and Analytics for HCM -
How can i get Performance current task name in OTBI?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Juhi Kumari 18 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
OTBI report Fetching both Active and Inactive Records when select only Assignment status as ActiveOTBI report Fetching both Active and Inactive Records when select only Assignment status type as Active from Subject Areas : "Workforce Management - Worker Assignment Re…ROHIT NAYAK_120 5 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 29 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Can customers report on Signer's IP Address for electronically signed documents within Oracle HCM?Summary: We have a need to report on all of the various components of electronically signed documents/forms within Oracle HCM Onboarding Journeys. These data items shoul…Marnetta Griffin 17 views 1 comment 1 point Most recent by Claudiu Postolache-Support-Oracle Journeys -
Can I make an Academic Year 'Time' dimension in OTBI?Asking for a colleague Hi all, I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024. I have successfully made time s…Mark Stoker 14 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Person Legislative Information Field Teacher Reference Number no longer showing dataSummary: After 24c was implemented on our Production environment we noticed that one of the fields in the subject area was no longer producing any data. The field in que…Mark Stoker 78 views 18 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for HCM