BI Publisher
Discussion List
-
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 212 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.7K 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 53 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 49 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…Rishita 7 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
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 867 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 75 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 363 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 181 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 18 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 43 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 374 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 28 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 35 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…Venkatesh Babu Somalinga 183 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…Vishnupriya 18 views 1 comment 0 points Most recent by Ionela - Oracle Reporting and Analytics for HCM
-
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…Neha_C-Oracle 109 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 7 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 92 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM