OTBI
Discussion List
-
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… -
How to list all changes made against a BPM rule in given time period?Summary: How to list all changes made against a BPM rule in given time period? we are referring to table POR_AMX_RULES but it doesn't have changes made against any condi… -
How to extract a list of transaction details that are pending contingency removal?Summary: Users must be able to extract which transactions (and their details) are pending contingency removal, so that they can easily monitor which transactions they ne…Francine Gemora 31 views 2 comments 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
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 Set Date Format to Dashboard Prompt?Summary: How to Set Date Format to Dashboard Prompt? Content (required): How to Set Date Format to Dashboard Prompt? Does the Date Format shown by default is based on Us…Shivakumar Ayyanagowdar-Oracle 341 views 1 comment 0 points Most recent by Ian Rumble Reporting & Analytics for Sales -
"Receivables Aging by General Ledger Account ReportSummary: We are trying to create a custom report based on "Receivables Aging by General Ledger Account Report" but we are facing issue with transactions falling into wro…
-
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
-
The specified criteria didn't result in any data from Project Subjects AreasSummary: When use Projects – Cross Suject Area Analysis – Real Time subject area, and select only project number column appears data, but when select project number and …Franklin_Cardozo-Oracle 21 views 5 comments 0 points Most recent by Franklin_Cardozo-Oracle Project Management -
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 211 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 132 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…
-
Absence Accrual OTBI ReportSummary: 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…
-
Created initiative for learning but not getting enrollmentsSummary: We would like to assign learning automatically to the new hires. We would like to assign learning automatically to the new hires. We created the initiatives and…
-
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