BI Publisher
Discussion List
-
How many WorkEmails can we add to a filter while creating a Filter in Alert ComposerSummary: Trying to add work Email Id's to an expression using 'OR' operator. Has anyone used it before and know how many emails can we use in one batch. Content (require… -
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i…Raghavendra M 47 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Error While opening OTBI ReportSummary: Error While opening OTBI Report Content (required): Hi Everyone, While opening the OTBI report, it throws me following error. As per the document Doc ID 2083725…
-
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…User_2025-01-25-00-37-41-739 210 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At…
-
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…Izliana 34 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…Prajwal kumar 82 views 5 comments 0 points Most recent by Prajwal kumar Reporting and Analytics for HCM
-
Job Profile AuditsHi , I have a requirement to pull the changes made to Job profiles/Job details. Is there any way if it can be retrieved from Audit report, If yes, how can i achieve it. …Praveen_Chouhan 6 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…Sinem Kara 60 views 9 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check…
-
Where to find Risk Code Description in DBSummary: Need to find the Risk Code (or Workers Compensation Code) description in the database. Content (required): I am creating a report pulling data out of hcm cloud …
-
BIP - Non-catalog item reportSummary: Hello, Have anyone tried creating a Non-catalog item report in Learning? Do you know where I can get these details below? (Column name, tables in BIP) Your help…Hazel De Castro 105 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 108 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 219 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
How to read primary national identifier?Summary: How to read primary national identifier? Content (required): How to read primary national identifier? I use per_national_identifiers table but no reference to t…Nicola Petri 74 views 2 comments 1 point Most recent by Seema Kalantri Reporting and Analytics for HCM
-
Do Business Unit names in BI report criteria gets changed to BU ID value during archive/ unarchive?Summary: Hi All BI/ reporting experts - The question is regarding migrating BI reports from one pod to the other. Oracle recommends using archive/ unarchive feature. We … -
How can I get double quotes around fields in the output generated by an etext template?Summary: After adding a new field to a current etext RFT template and uploading it, the output no longer contains double quotes around the fields that contain spaces or …BeachDreamer 1.2K views 3 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
How to find the list of scheduled jobs and their individual runs?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):kishore madhavan-Oracle 57 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
What are the available web services for Fusion BIP?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):kishore madhavan-Oracle 23 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan…
-
CONTENT SERVER REQUEST FAILED error messageSummary: Error message when trying to generate dynamic URL embedded in custom Talent BIP report. Content (required): In the process of generating a dynamic URL to be emb…
-
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…SAKTHI SUNDAR 43 views 1 comment 0 points Most recent by Ankur Miglani Reporting and Analytics for HCM
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep T U 81 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 28 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there a document for creating a report for Oracle Digital AssistantSummary: We have received a requirement from one of our clients and they want to create a report for ODA Content (required): Basic requirements from the report - What qu…Avik Roy Chowdhury 58 views 3 comments 2 points Most recent by Dr Surlina Yin-Oracle Digital Assistant -
BIP - List of Employees under the Area Of Responsibility of HRSummary: Hello, Does anyone know how to get the list of employees under the Area of Responsibility of HR via BIP Report? Could you please share a query or do you have do…Hazel De Castro 146 views 13 comments 0 points Most recent by User_2025-02-12-21-24-25-654 Reporting and Analytics for HCM
-
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 977 views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM
-
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…Aloka Bhattacharya 60 views 6 comments 0 points Most recent by Shampi Reporting and Analytics for HCM -
I am needing SQL for SalaryIdSummary: I am looking for an sql that includes SalaryId for trouble shooting an error I have in data flowing into FAW. I have the SalaryId in the error in FAW but can't …Sharon Ferguson 17 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BI Reporting function that creates link to attachmentsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Consulting Description (Requir…Claudio Marini-Oracle 36 views 0 comments 3 points Started by Claudio Marini-Oracle Reporting and Analytics for HCM