OTBI
Discussion List
-
Need to have Response Answer and Response text in same columnSummary: Dear Experts, Please advise that my questionnaire consists of both response text and response answers. Some response answers will be blank when the question is …Rajeshkumar_Sekar06 11 views 2 comments 0 points Most recent by Athish shantharaman Reporting and Analytics for HCM -
Reporting on Uptake of Course across OrganisationSummary: Requirement to work out the uptake of a course and show in graph form Content (required): Hello We have a course that has been created that we expect managers t…Helen Thomas 11 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM -
Can we change fetch First 250001 Rows Only to any other values?Summary: Can we change fetch First 250001 Rows Only to any other values? Content (required): Can we change fetch First 250001 Rows Only to any other values? It seems thi… -
Performance Issue in Workforce Management - Workforce Trend Real Time subject areaSummary Performance Issue in Workforce Management - Workforce Trend Real Time subject areaContent Hi Team, We have a line manager dashboard where for one tab we are usin…Sohan Dey 59 views 11 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…William_Johnson 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is it possible to change time zone on CURRENT_DATE SQL filter?Summary We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?Content Hi …
-
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 21 views 8 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM
-
SQL query to extract UDT tableHello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a …Ioannis Adamou 6.1K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
United States Job Information Extensible Flexible Attribute not BI EnabledSummary: 2 of the attributes in United States Job Information Extensible Flexible are not BI Enabled. The flexfield is protected hence no changes can be made. Please see…
-
IS it possible to extract report on total number of self downloadable the report in employees folderSummary: HI Team, in this path Shared>Custom>employee -folder we placed the self downloadable letters so we need to extract report on total number of self downloadable. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor… -
Payroll Element Entries - Context Sensitive Displayed Input Values - how to get on one rowSummary: Hello, I am using the SA Payroll Element Entries to try to get an employee allowance report. The issue I have is one of the fields 'Displayed Input Values' is c…Ian.Gooderham 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…Siva Sankari N 61 views 3 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Sort breaking RCOUNT in logical SQL analysisHello, I have a fairly complex logical SQL report combining 5 subject areas. Overall, the information is displaying correctly with no issues. However, I have a need to R…Nick Dorfner 52 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…Valeriy Gorbunov 141 views 3 comments 0 points Most recent by Deepa Venkatesan Reporting and Analytics for HCM
-
How can we view an employees current department in performance document reporting?Summary: We have a requirement to include the Department Name and Organizational Hierarchy levels in analyses of Performance Document completions. However if an employee…Joshua Kidd 21 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 111 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Absence Accrual report in OTBISummary: Hi All, We have a requirement to develop OTBI Report for Absence Accruals. I couldn't able to get the accrual details. Does any one have catalog file or know ab…Sai Krishna Chelikani 31 views 8 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
Person Contact Relationship Marital StatusHello Oracle Community, I am trying to develop a demographic of dependent report by using OTBI subject area: Person Real Time. I am having a challenge to find marital st…Mohamed Affan 51 views 8 comments 0 points Most recent by Mohamed Affan Reporting and Analytics for HCM
-
Current report structure in OTBISummary: Please could we have a download of current report structure in OTBI for custom folder area? Ideally, we would like a list which contains all the folder/sub fold…Madhuri Brammadevara 41 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
How to send a scheduled report to a Sharepoint location using an OTBI Agent?Summary: How to send a scheduled report to a Sharepoint location using an OTBI Agent Content (required): How to send a scheduled report to a Sharepoint location using an…
-
can we customize the labels of 9 box in the talent tab of line manager dashboard reportSummary: Wee need to customize the labels of 9 box in graphical view in the talent review tab of line manager dashboard report Content (required): Version (include the v…Arpita Maitra 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI formulas to combine 2 criteriasSummary: Help on OTBI formula Content (required): I would like to create a formula that would allow me to get the AVERAGE individual bonus achievement BY workers and BY …Jacqueline GRANDIN 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 202 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM
-
ZIP output file of an OTBIHi All, We have a requirement to zip the output file of an OTBI analysis before emailing. Is this possible? Regards,Vibha Pandey - Oracle 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 131 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
How do I find correct security type to add to a role to run report?I have created a dashboard and a new role which I had inherited to another role. The issue though is when I go to run the report I get the following error which I know i…Aaron Reynolds 21 views 5 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Export vs. "Open" Report Data OutputSummary: Hello there! I have a question regarding a discrepancy I noticed in the data output of a report that I'm using. The report pulls all active team members as of t…
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
User person Type is not capturedContent Hi all I have created an ORBI report with Subject Area > Workforce Management - Worker Assignment Event Real Time to capture user Person type detail of the user.…Dhajani Perera 52 views 5 comments 0 points Most recent by Erica Williams Reporting and Analytics for HCM