BI Publisher
Discussion List
-
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?Hi everyone, I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to b…Karthik Adiga-Oracle 2 views 1 comment 1 point Most recent by Sivasekar Narayanan-Oracle Reporting and Analytics for HCM -
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th…
-
Sql query or Table to fetch Compensation Worksheet data in BIP report based on securitySummary: Sql query or Table to fetch Compensation Worksheet data in BIP report based on the roles assigned to the user. Content (please ensure you mask any confidential …
-
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 22 views 3 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security -
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in…Eric Geddes 358 views 2 comments 0 points Most recent by Kratika Sharma Reporting and Analytics for HCM -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 100 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM
-
How to identify who removed a role for a specific userSummary: How to identify who removed a role for a specific user Content (required): Which table holds the details of who and when a specific user role is revoked for a p…Vinothkumar Somasundaram 282 views 2 comments 0 points Most recent by User_FPR9R Reporting and Analytics for HCM
-
Tracking Timely TerminationsHi Does anyone have or is aware of a report or dashboard that tracks the termination submitted for processing? We are having issues with overpayments to employees have s…Jose Guerra 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM BI Table to retrieve employees Eligible for a compensation planSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom BI reporting collecting compensation plan columns at the em…Valerio Curzi 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 52 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher ReportContent Hi Gurus, Can we Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher Report? I Created BI Analysis report and then Agent to call Analysis …Sunnyrajarora-Oracle 81 views 4 comments 0 points Most recent by PranayBhargava13 Reporting and Analytics for HCM
-
Long running BI report send notification message to userSummary: Hi Team, we have couple of reports are running in production environment are very long running its not throwing an error can you please suggest how to set the l…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 15 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat…Stefano_Mazzocca 79 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 4.8K views 10 comments 0 points Most recent by Jose Aguilera Reporting and Analytics for HCM
-
MilanMohanty 97 views 2 comments 0 points Most recent by Ankit Chauhan Reporting and Analytics for HCM -
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…Shikha Singh 22 views 2 comments 0 points Most recent by Shikha Singh Reporting and Analytics for HCM
-
User who executed or modified a report in Publisher ?Summary: Is it possible to know which user executed and/or modified a report in Oracle Analytics (Publisher) ? Content (please ensure you mask any confidential informati…Eduardo Mendoza 3 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 241 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
Help in Query to get Variable Rate for a Benefit of an EmployeeSummary: Hello, Customer Connect! I am in need of developing to get these scenario: If the employee John is enrolled in the Benefit A with the option B, it have a rate v… -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…Maria Cristina L. San Jose 29 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 13 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report on Extract Definitions / Object Name / AttributesHello, I would like to create a report (Bi Publisher or OTBI). About Extract Definitions. I need following information Extract Definition Name Object Name Attributes Exc…Michael Schweizer 12 views 1 comment 0 points Most recent by Stephane Cote-Oracle Reporting and Analytics for HCM -
Run bip reports via payroll flow or ess jobsSummary: We are planning to create BIP reports, which will run in changes only mode. As a best practise should we be running the report leveraging the last run ESS job o…
-
What is the column for enrollment date in the WLF_LEARNING_ITEMS_F table?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…ClaudiaManea 12 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Time to Fill Measure using Requisition Open Date in Recruiting - Recruiting Real Time Subject AreaContent I'm trying to create a Time to Fill measure using data in the Recruiting - Recruiting Real Time Subject Area. My calculation works but the Requisition Open Date …User_2025-02-10-14-03-41-548 103 views 5 comments 0 points Most recent by AshleyM Reporting and Analytics for HCM -
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_…