BI Publisher
Discussion List
-
ORA-00933 : While generating explain plan in BISummary: When we are generating the explain plan we are getting this error message from BI Data set. oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00933… -
Workforce Compensation Page Parameters for EL ExpressionsContent Hello experts, is there an Oracle official documentation which can allow me to have all compensation module parameters (i.e. ManagerId; PlanId; etc.) in order to…Valerio Curzi 33 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dynamic Dates for Parameters or SchedulesSummary Is there a list of dynamic dates for use in parameters or in schedules?Content Hi all - I did review this post (https://cloudcustomerconnect.oracle.com/posts/862… -
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes …Janardhana Kondaveeti 129 views 5 comments 15 points Most recent by Visu Reporting and Analytics for HCM -
Need Help to fix Date parameter while integrating BI report into DashboardSummary: I have created a SQL with a date parameter that calculates effective date minus 5 days. Below is the code which is working well while running normally with BI r…Mohan Murali 63 views 1 comment 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
How to exclude logged in user from BIP report?Summary: Logged in user needs to get excluded from their own BIP performance report Content (required): Hi, we have built a custom BIP report for performance data for ma…Franziska Reichel 32 views 4 comments 0 points Most recent by Franziska Reichel Reporting and Analytics for HCM
-
Prevent files with only header row from getting generated from etext bursting in BI PublisherSummary: Prevent files with only header row from getting generated from etext bursting in BI Publisher Content (required): Hi Experts, I' bursting an etext template with…Aloka Bhattacharya 11 views 8 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 679 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 31 views 1 comment 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 31 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
To develop a BI report with calendar functionality.Summary: Need to develop a BIP report which uses bursting functionality and when ever mail triggers, it gets automatically saved in the the calendar of the mail just lik… -
How to see multiple values in new line in Oracle SQLSummary: Content (required): I need to develop a BIP report for talent profiles. As per the business requirement, I need to display multiple values (Ex. Skills, Language…Prajna Hegde 21 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 177 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Succession Planning BIP ReportSummary: Content (required): Hi All, As per the client requirement, I am trying to create a BIP report for listing the incumbent (person) specific and position specific …Prajna Hegde 23 views 8 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
How to embed Logo/Images in BI Publisher RTF Template in HTML Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in HTML Output format Need to Embed Logo in HTML output format for BI reports Template. Options Content (r…Kaustubh Deshmukh 13 views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is …
-
How to join 2 tables without common column in SQLSummary: Content (required): How to join 2 tables without common column in SQL and get the columns from both the tables side by side? I tried using the CROSS JOIN and UN…Prajna Hegde 32 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 21 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 464 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Reporting on Area of ExpertiseSummary Reporting on Area of ExpertiseContent The Talent Profile - Me > Career Performance > Skills and Qualifications Includes an Area of Expertise section and we would…User_2025-01-23-21-24-21-434 87 views 2 comments 0 points Most recent by dwi Lestari-Oracle Reporting and Analytics for HCM -
How to Burst a BIP report (Excel format)Summary: Hi All, I have a business requirement to send an attachment to each of our vp's with their employees I have created a SQL with my information that has a paramet…User_2025-02-04-08-51-08-912 1K views 6 comments 1 point Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl…
-
Payroll Data Validation ReportSummary No results in Payroll Data Validation ReportContent I am trying to validate the data in test environment by executing the delivered Payroll Data Validation Repor…Sowdha Murugan 111 views 6 comments 1 point Most recent by Phia Belgica Reporting and Analytics for HCM
-
Excel formula in BI reportSummary: Need to include excel formula like DATE and DATEIF based on hire date pulled in one column Content (required): Hi Our requirement is to calculate a date using e…Poornima Paliwal 31 views 4 comments 0 points Most recent by Poornima Paliwal Reporting and Analytics for HCM
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
EEO-4 Report - any ETA from Oracle?Summary EEO-4 Report - any ETA from Oracle?Content As every customer need a standard EEO-4 report as part of requirement, I understand it is in scope of future release. …
-
Can you create custom subject areas for a SAAS implementation?Summary: It appears that custom subject areas can be created - but I am not able to find if this is available for standard SAAS HCM Cloud implementations or if any addit…Karen Costakes 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Gross Pay Balance for full Fiscal Year for all EmployeesSummary: I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year. Format of data needed Person Number Display …Andrew_Schmitz 155 views 1 comment 1 point Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 2.5K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM