OTBI
Discussion List
-
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 12 views 0 comments 0 points Started by Kundan Kumar17 Reporting and Analytics for HCM -
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he…Janine Brown 394 views 10 comments 4 points Most recent by Murali Togaru Reporting and Analytics for HCM -
How to use ASCII Values in OTBISummary: We are using this statement REPLACE(REPLACE("Document and Rating Details"."Rating Comments", CHAR(13), ''), CHAR(10), '') in BIP Report.How can i use the same s…Narendar-Oracle 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Grade Legislative Information not available in OTBISummary: Grade Legislative Information not available in OTBI Content (please ensure you mask any confidential information): Hi All, We want to pull out the Grade Legisla…Arther Bu 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to schedule an agent to run only if new / upcoming terminations are enteredSummary: Hello, I'm working on a push report for our security operations team who wants to be notified of upcoming terminations entered into the system. Unsure how to pr…CGardner01 13 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 218 views 3 comments 11 points Most recent by Shyam Patel Reporting and Analytics for HCM -
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a… -
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear…
-
How to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: First, I apologize, as I am not a reporting guru like you all so this question may seem rudimentary! I am the main administrator for our HCM Learning app. I oft…Angie Elliott 31 views 4 comments 0 points Most recent by Thulasi Ram Reporting and Analytics for HCM -
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI…
-
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 45 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Assigning HR AOR Roles Changed ReportingSummary: We are moving our HR Specialists to AOR Roles, based on Location. And in testing this in our lower instances, everything on the screens is working as expected. …
-
Employee job levelsSummary: Adding job level to employee report Content (please ensure you mask any confidential information): We have a requirement to show the employee job levels. When I…Ridma Karunanathan 60 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 252 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
OTBI Report Perfomance issue when I apply the 7 countries in promptSummary: Hi All, We have OTBI report but in report Perfomance issue when I apply the 7 countries only but if i apply one country working fine in prompt . needs all the d…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Absence reportSummary: I have created a OTBI report to pull absence details and it has parameter of two dates start date between. Client is passing the dates of 1st of Aug to 30th Aug…Reddykrishna 42 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 32 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 2 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 70 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 420 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. 4 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!