BI Publisher
Discussion List
-
Layout name in the report output file nameSummary: When report is exported to Excel, the report name is concatenated with the layout name, to arrive at the report file name. Content (required): What are my optio… -
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha… -
Need BIP query for Sensitive Information in Job Application ORCSummary: Which is the source table for National Identifier and Date of Birth under Sensitive Information? Navigation: My CLient Group >> Hirings >> Search Req Number>> C…
-
Change Dashboard Icon ColourSummary: Content (required): Recently, our client decided to change the background color of the application, and overall it looks fine but on the dashboard, the icon col…
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 51 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Please help share SQL to extract all oracle fusion hcm setup configuration with dataHello All, We want to have a download of Config Workbook from the POD,but Configuration Package and Implementation Project setup isnt working as expected. Please help sh…C.R.Balaji 101 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can contents of a UCM file be used to fill a BI-Publisher prompt parameterSummary: Can contents of a UCM file be used to fill a BI-Publisher prompt parameter Content (required): Is it possible to use a UCM file (i.e. a comma separated person n…
-
BI Publisher RTF Template - Repeating GroupSummary: Team, we have a requirement to print the timecard details For each employee the header should be same and the Last Row Should Be Repeated. It would be really he…
-
Error in Copy of Seeded NotificationSummary: BIP Notification issue Content (required): Hi Oracle Experts, I need your help regarding BIP notifications, I have a requirement to add/hide the fields in the n…
-
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 256 views 8 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Changing time zone for BI reportsSummary: I need to keep the time zone as GMT-05:00 Eastern Time ( US & Canada) for all BI reports when I'm scheduling jobs. I followed the instructions of this document …Ayesha Iroshani 466 views 2 comments 0 points Most recent by Ayesha Iroshani Reporting and Analytics for HCM
-
Need help to fetch the roles with stream names and service detailsSummary: Need help to fetch the roles with stream names and service details Content (required): We have a requirement to develop a report to fetch all the roles along wi…
-
Benefits Report Etext template question?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Extract Comment after Hiring Transaction or other transactionSummary: Extract comments after hiring transaction Content (required): Extract comments after hiring transaction as show in the image Version (include the version you ar…teresa.marciano 3 views 0 comments 0 points Started by teresa.marciano Reporting and Analytics for HCM
-
OTBI - Need Specific Assignment History along with complete salary historySummary: Hi , Client wants specific assignment history like Job Change, Dept. Change, Status change along with complete salary history. Able to get it but the salary his…
-
Performance Management Eligibility ProfilesContent Hi All, I am unable to find the table names for "Manage Eligibility Profiles" and "Profile Criteria". Please finds the attached screen shots for your reference a…
-
How to display multiple values in seperate columnsWe're creating a report with employee data and part of the report are e.g. e-mailaddresses. When e-mail type is part of the report, the result is multiple lines, but we …Wouter.Schaap 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 850 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM
-
BI Publisher Date parameterSummary: How can I format a date parameter to a TZ string? Content (required): Which variable should I use to populate a date parameter with 2023-03-10T00:00:00.000+05:0…
-
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…Shea Hartsell 248 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to pull in correct payroll number of employees in BI Publisher reporting?Summary: I have put together a query where my joins for payroll number are bringing some duplicate lines into my record. On investigation, the joins are not bringing the…
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 301 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Error after adding another subject area to an analysisSummary: I built an analysis based on Workforce Management - Worker Assignment Real Time. Now I need to add a column from Worker Management - Person Real time. When I di…
-
Getting an error while running a report.Summary: Hi Team, I am getting an error while running a report, please see the attached screenshot. Could you please let me know the rout causes. Thank you Content (requ…
-
how to report on job offers that are pending for approvals using workflow tablesSummary: we need to cover and track all job offers that are pending for approvals and who is the next approvers! I need to create a report covering this topic.. for the …Ayoub AFRASS 94 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 208 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 402 views 8 comments 0 points Most recent by Arun Menon Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 303 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 71 views 6 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…