BI Publisher
Discussion List
-
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 86 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 22 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 460 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 11 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 21 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 1 view 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 21 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 289 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 668 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 73 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 81 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 22 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Reporting and Analytics for HCM
-
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …Janardhana Kondaveeti 164 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BI Publisher for word is stuckSummary: BI Publisher for word is stuck Content (please ensure you mask any confidential information): Hi, BIP for MS Word has stopped working and the application is get…
-
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 428 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic…RamkumarKadhiravan 13 views 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM
-
Need to find table to get all Bank account related informationTeam, i need to fletch all the data related to bank account , can you please suggest which table suits ? ThanksNaidu.R-Oracle 23 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)Mustafa Abu Dayeh 1 view 0 comments 0 points Started by Mustafa Abu Dayeh Reporting and Analytics for HCM
-
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 41 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 115 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Custom BI Reports and tables performance issue in fusionSummary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week. Could you please provide d…Venkatesh Emani-Oracle 25 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration