OTBI
Discussion List
-
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…Kurva Paramesh 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke… -
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 192 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 126 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…Emily Robinson 183 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
OTBI AgentsWe have OTBI reports with more than 25000 rows (Approx 250000). To transfer data, we need to split them up into 10 to 15 agents by employee's name character or Person nu…Ashok Kumar Sharma 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
catalog managerSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Wayne Smith 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
Count of employees by Business Unit, Location and DepartmentWe need count of employees by Business Unit, Location and Department using OTBI. When we use count function, it shows same count for all business units instead of showin…Ashok Kumar Sharma 261 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Count not coming correctAny idea why below XML is showing Column "Count as 2 " value = 2 for all business units. Column "Count1 using assignment " value = 0 for all business units.Ashok Kumar Sharma 11 views 2 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
How can I get "And" instead of "Or" to work with the same column filter?Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that s…
-
OTBI Analysis for Benefit Dependents over 21Summary: I need an OTBI analysis get information for dependents who are 21 years of age in every year. Content (required): I created an analysis based on Benefit Enrollm…Ayesha Iroshani 51 views 4 comments 0 points Most recent by User_FG152 Reporting and Analytics for HCM
-
Talent Notification QueryHi, Is there are a way to query Talent Notification to check when the Enabled column for Talent Review notification was updated? -
Infolet access - Learning Records Real TimeHello We build a report based upon the subject area Learning Records Real time and created an infolet. When making the infolet available to the employee, it doesn't give…Annelies Van Erom 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Filter schedule name based on week start date of timecardSummary: Report has only the schedule applicable to the timecard at time of commencement. Content (required): I have a timecard report that includes every schedule for t…Dawn Cawston - CPS 11 views 8 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Display Custom Message - Error when adding HTMLSummary: When I try and add HTML to the "Display Custom Message" I keep getting an error message (see below) Content (required): Version (include the version you are usi…Scott_Turner_ 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
Best fit % calculationSummary: Hi Expert, In OTBI do have have a subject area for best fit % calculation? in Talent management module. Thank you! Content (required): Version (include the vers…
-
Which Subject area to use to get report of employee allowancesSummary: Which Subject area to use to get report of employee allowances eg. car Allowance Content (required): Which Subject area to use to get report of employee allowan…PavanBheema-Oracle 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 121 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their terminationSummary: Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their termination Content (required): Using worker assignment real time busin… -
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks ThiruThiru Ch 321 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 31 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 927 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM