BI Publisher
Discussion List
-
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.1K 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 52 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 22 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 32 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 TU 73 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 23 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 51 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 144 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 938 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 56 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 12 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 32 views 0 comments 3 points Started by Claudio Marini-Oracle Reporting and Analytics for HCM
-
Future Dated HiresSummary I need a report from the OBI that will give me a list of employees that have been boarded in Fusion, but haven't started yet.Content I've attempted to load the t…User_2025-01-23-22-36-14-742 156 views 11 comments 0 points Most recent by Matty S Reporting and Analytics for HCM -
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 519 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
Can we include a pivot table in a OTBI report.Summary: I have a report and wondering if a Pivot table can be added so if we run this report or schedule it, it would include that pivot table? Content (required): Vers…Rajib_Samanta 59 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
Reset the sequence in etext template when I have only one level where data residesExperts, I have to generate a sequence that resets after printing details for every person. The Cost_ID tag makes sure every record that is needed is fetched on the repo…Aloka Bhattacharya 53 views 2 comments 0 points Most recent by R Ravichandran Reporting and Analytics for HCM
-
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 78 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 168 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi…Christian Suarez 31 views 3 comments 0 points Most recent by Christian Suarez Reporting and Analytics for HCM -
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be… -
EEO Reporting for Federal, State and LocalHi all, Is there any document which tells us more about "Submit EEO-4 State and Local Government Report for US". Thanks, Sathish -
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated…
-
How to restrict performance data access in BIP report when having Frontend accessSummary: How can we exclude employees from a BIP report for performance, where the HR User has access to the employee information over the frontend but not to the perfor…Franziska Reichel 11 views 0 comments 0 points Started by Franziska Reichel Reporting and Analytics for HCM
-
Create a BI Publisher report to spool users whose password is expiring in next 14 daysHi Experts, I want to create a BI Publisher report to spool users whose password is expiring in next 14 days. Has anyone created something in these lines. Any inputs wou…Aloka Bhattacharya 21 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM
-
Find list of reports using a particular subject areaWe have 100s of custom reports. We are making some security changes at the moment and performing impact analysis at the moment. We want to find the list of reports that …