BI Publisher
Discussion List
-
Issue-Line Manager getting employee's all assignments performance documents details in OTBI reportSummary: I am working on one OTBI report to fetch the details of performance document for line manager. Employee who are having two Active assignments and both assignmen…Kamini Kaushik-Oracle 22 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
How to fetch details of bypassed task for performance document in OTBI reportSummary: I have requirement to fetch the details of bypassed task in performance document in column Content (required): In our instance for performance document the work…Kamini Kaushik-Oracle 13 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
BIP Report- Need to Create Report based on User Access or Security Access.Summary: Need to Create BIP Report for performance , Which shows data based on User Access. Content (required): I need to create report for performance Module which show…Alok Ranjan 11 views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 33 views 1 comment 0 points Most recent by Preston Schultz Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Person number of employee/contingent worker of a successful referred candidateSummary: Customer is looking for a report with the person number of the employee/contingent worker who has been successfully hired after being referred by an internal em…
-
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
BIP report: Users with HR and line manager role should only see their direct/indirect reportsSummary: BIP report: How can we make sure that when an HR User, who is also a Line manager, is only seeing their own reports (direct and indirect) when pulling the repor…Franziska Reichel 191 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Reportminati_behera-Oracle 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need an Oracle documentation which list changes done to database or TablesOracle agreed to share a documentation which will help customer identify changes done to Tables which might affect BI Publisher reporting. But, Oracle said there is no d…Vamsi Kuchipudi 12 views 2 comments 0 points Most recent by Vamsi Kuchipudi Reporting and Analytics for HCM
-
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 21 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
What HR roles can see Performance analyticsSummary: We have a Dashboard containing a tab with information on Performance Documents (status, ratings, etc.) and a tab containing information on Goals. Line Managers …Wouter.Schaap 2 views 5 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
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 35 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 132 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 68 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 16 views 8 comments 0 points Most recent by Aloka Bhattacharya 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 32 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 36 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 24 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 185 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 24 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 11 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 31 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM