OTBI
Discussion List
-
Where are calculated measures housed in the catalog for OTBI ?I've created measures for different reports (not sure which ones), but want to re-use them. Where can I locate them in the catalog? -
Scheduling OTBI report with a conditionSummary: I'd like to be able to schedule an OTBI report but restrict the data that is sent to the recipient using a condition. Content (required): Our OTBI employee stru…
-
Line Managers reporting on terminated workersSummary This post provides customers a work around in OTBI to report on the terminated workers when logged in as a line manager.Content The attached document provides a …Raghavendra Raghunath-Oracle 961 views 10 comments 12 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
Aggregate all notifications from Oracle HCM Cloud into single daily email/ report.Hi all, We have a requirement in which we are looking for a way to a aggregate all notifications from Oracle HCM Cloud into a single daily email or a report, sort of lik…Ioannis Adamou 61 views 2 comments 2 points Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des…Anil Pillaresetty 287 views 21 comments 1 point Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages?Summary: How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages based on logged user. Content (required): We have a Dashboard; i…Ravindr-Oracle 107 views 5 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
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 12 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 50 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 5.7K 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 17 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 47 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 46 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 143 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 101 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 52 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 22 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 188 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM