BI Publisher
Discussion List
-
Which table stores the data from plans and plan types tab?Hi Team, I am trying to fetch the data from plans and plan types tab which is under below navigation: Benefits Administration > Plan Configuration > Program Name > Basic…Saurabh_Mharolkar 32 views 2 comments 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? PFA. Thanks,…AjayKumar Maddipati 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Reports are not displaying to tag them in Link or Image section in DashboardSummary: Hi Team, We are creating the Dashboard. Unfortunately, we were encountering that BI reports are not showing to add them in the Link or Image sections in the das…Dasari Dileep 11 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary sql statement to get the performance document current taskContent Can anyone help me on how to fetch the current task for the employee performance document , the…MahmoudAllam 3.1K views 9 comments 0 points Most recent by User022-Oracle Reporting and Analytics for HCM
-
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 238 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
SQL to get Cost center mapped to countrySummary: Hello Everyone, I just want to ask for SQL on how to get the cost center who are mapped to country. Thanks,Michael_B 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to get required currency format in Excel outputSummary: this is the tag we are using to get amount column in US format. we are able to get it in PDF output but not in excel. Content (please ensure you mask any confi…Nalsoft Pvt Ltd 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
OTBI report should drill to show the courses that are part of the specialisation.Hi, We need assistance with an OTBI analysis where clicking on a specific specialization should redirect to another analysis that displays the courses included in that s…Saurav R-Oracle 23 views 0 comments 0 points Started by Saurav R-Oracle Reporting and Analytics for HCM
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE DatabaseSummary: How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE Database. The Below part is having an issue. Please help me how to write regular expression in Oracle BI EE ON…Niranjan_DTCC 76 views 3 comments 0 points Most recent by Niranjan_DTCC Reporting and Analytics for HCM -
find value in one loop and traverse back to another loop in xml etext templateSummary: I have an XML of ACH file where in there is a value in this path PAYMENT_RECORD/PAYMENT_DETAILS/PAYER_METHOD/EFT_USER_REF. When Make EFT Process is ran the outp…
-
How to enable report job historySummary: I need to enable the "Report Job History" option in the Home tab of OTBI, without leveraging BIAuthor or BIAministrator, as we have a requirement to view and no…
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…Rajesh Suvala85 21 views 8 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 438 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
SSN not removed from headingContent I want to modify alert notification template, where when employee update their contact relation, their SSN number should not be visible to approver. However when…Aanila Nanda-Oracle 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
HR Audit reportSummary: Hi All, I have a question regarding the HR Audit report feasibility. If HR were to identify sensitive data, is it possible to enable auditing on a handful of sp…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?Ronel M 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Troubleshoot Incorrect Work Pattern SQL QuerySummary: Hello, I am a beginner with SQL and am trying to resolve an issue with an incorrect Work Pattern Report built for us by an Oracle Consultant. I am trying to get… -
Best Approach to Restrict Seeded Folders AccessSummary: We have users from 3 areas such as HCM, Finance and SCM. We have dedicated Custom reports folders for each set of users such as HRs can access 'Custom HCM Repor… -
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…Evelina Hobson 25 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…Rama123-Oracle 237 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Need query to get the list of all roles for a given roleSummary: Navigation: Tools > SecurityConsole > Roles If I query a role name, I want display all the roles associated with it. I want to build a query for the same. Pleas…Niranjan_DTCC 42 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…User_7A1QO 563 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th…Pinky Mukherjee 49 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…Sagar Perala 59 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 51 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…sultank 21 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Reporting and Analytics for HCM