BI Publisher
Discussion List
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 613 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
can we have different Font style for e-sign on offer letter templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…YOGESH SAMPANGI 3 views 0 comments 0 points Started by YOGESH SAMPANGI Reporting and Analytics for HCM -
BIP or OBTI Auditing Users making changes to their own HCM/Payroll DataSummary: Does anyone have or know of any current reports that will give details on Oracle HCM users who have made data changes to their own Global HR/Global payroll info…
-
How to fetch Resignation details, which include Resignation reason,,Summary: This is the resignation page in Me tab. How to fetch all These details using SQL?Aryan Yadav 13 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur… -
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Need Oracle SQL query to get the Office number for Location details from Assignment pageSummary: Need Oracle SQL query to get the Office number for Location details from Assignment page Content (required): Need SQL Version (include the version you are using… -
OTBI Report data issueSummary: OTBI Report data issue Content (please ensure you mask any confidential information): Hi All, We developed OTBI report with Workforce Management - Worker Assign…
-
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h…Valerio Curzi 116 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI - add a graph to show the number of candidates by locationSummary: I've created an analysis using Recruiting - Recruiting Real Time Subject area and have been trying to add a graph to show the number of candidates by location, … -
When the employee open a report we need to send one email to same employeeSummary: When the employee open a report we need to send one email to same employee Content (please ensure you mask any confidential information): Hi Team, We have a req…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.5K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
Generate an OTBI or BI report that notes mileage or kilometer distance from home zip to work locatioSummary OTBI or BI Publisher SQLContent Does any one know of a way to get, for each Employee, the distance in miles or kilometers from the worker's home zip to work loca…User_2025-01-28-21-53-32-678 49 views 2 comments 2 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
Columns Missing from the Subject Areas in OTBIwe have 3 OTBI reports showing error in the output, when i checked, some of the column headings are in the report like 1.Deduction Developer DF_QUALIFYING_PEN_SCHEME 2.D…Global Support Desk 29 views 3 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
table record to use for non benefits employees to new benefitsSummary: Hi, Writing a report to check the list of employees who are newly enrolled in the benefits. please share the table name which give the field name to separate th…
-
HIDE THE FACTORY CATALOG FOLDERSContent Hi We are in 19D and we have removed one of the role which is(Extension Folder Reporting Duty) from Custom BI Webcat Reporting Duty to hide the Extension folder …
-
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P…Shrikant Gupta 674 views 8 comments 0 points Most recent by inoappsms Reporting and Analytics for HCM -
How to link absence details and payroll detailsSummary: Hi all We need a report that provides absence details along with the payroll elements processed based on those absences. Specifically, for the OFFICIAL TRIP abs…Shameer Muhammed P M 48 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for HCM
-
We need to get Timecard reason on like WFH or Client Site and so onWe need to get Timecard reason on like WFH or Client Site and so on please help with relevant tables
-
BIP error oracle.xdo11g.xqxp.XQException: FORG0001Summary: BIP error oracle.xdo11g.xqxp.XQException: FORG0001 Content (please ensure you mask any confidential information): Hi Team, Greetings! We have run into error for…Parag Hiremath 265 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Is Oracle BI Publisher Desktop Plug-In freeSummary: The Oracle BI Publisher Desktop Add-In, which can be downloaded to work with MS Word and Excel, requires a separate license for installation on machines. We are…User_OPF0Z 170 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition…
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 13 views 1 comment 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 23 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…Abhishek Jois 249 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i…Nagendra Chitra-Oracle 24 views 0 comments 0 points Started by Nagendra Chitra-Oracle Reporting and Analytics for HCM
-
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 26 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management