BI Publisher
Discussion List
-
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 269 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 359 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 101 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 216 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 454 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 335 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 82 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…
-
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 394 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 15 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 57 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
ORA-01722 Invalid NumberSummary: Content (required): A report that used to work is now giving us an error ORA-01722: invalid number. Version (include the version you are using, if applicable): …Ratha Sun 367 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
BI Tables for compensation planSummary: Content (required): Hello experts, do you know which BI tables allows me to extract workforce compensation plan data? Thanks in advance for your time! Kind Rega…Valerio Curzi 54 views 6 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Is it possible to retrieve compensation component amounts entered in closed compensation campaigns?Summary: Content (required): Hello experts, our customer wants to add in compensation plan some columns retrieving compensation amounts entered in past campaigns. Is it …Valerio Curzi 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…Radha, Rangu 644 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
can we create report on the missing candidates (unconfirmed candidates).There are some candidates who were not able to submit there job applications because of issues with being able to access the assessment. I need to check if we can create…Chetana Pawar 69 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
What is the best way to implement ECC200 data matrix in oracle reports?Summary: Need to add a 2d data matrix to report letters that will store a string of numbers. The ECC200 data matrix does not seem to be currently supported by Oracle so …KevinCochran 45 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
How do you enable My Report tab for employees?Summary: How do you enable My Report tab for employees? Content (required): What is the privilige that you need to use in order to enable My Report tab for employees? Ve… -
Is there a query for fetching LinkedIn profile details in BIP report? Which is the table for that?Summary: To fetch linkedin profile details in BIP SQL report. Which table needs to used to achieve this requirement? Content (required): Version (include the version you…RithwikSivanand111111 40 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to get the termination action/reason for the report with benefit details?Summary: I have an OTBI report built with benefit details. I need to add employee's termination reason/action for that report. Content (required): I cannot find a benefi…Ayesha Iroshani 361 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Banner In BI reportHi Experts, Our client wants to add banner in heading like in homepage have., so is there any feasibility to add the banner asunder in report heading. Sample banner in e…Sujan Kumar Dash 34 views 3 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
How to make a drop down Prompt, in a Report based on an Analysis, work?Content (required): I've created the Analysis. Which is used as the Datasource for a Dataset in a Datamodell. The Datamodell is used in a Report. I want to create a Prom…
-
Not able to find "Show Selection Only" Option in the Configure Events for List Component.Summary: Not able to find "Show Selection Only" Option in the Configure Events for List Component in BIP Report (Interactive Report) Content (required): I was trying the…Sujeeth Chinta 54 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
HR_6882_HRPROC_ASSERT errorSummary: HR_6882_HRPROC_ASSERT error Content (required): Hi Team, Greetings! We have run into error for the direct deposit process with error log summary as- BIP job pro…Parag Hiremath 115 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to link custom button in homepage to BI ReportSummary: Content (required): Hello experts, I've created a custom button in homepage under My Client Groups tab. This button should be linked to a custom BI Report saved…