BI Publisher
Discussion List
-
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…Vasco 375 views 10 comments 1 point Most recent by Prasanth Subbaiahh-Oracle Reporting and Analytics for HCM -
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 44 views 6 comments 0 points Most recent by Gopikrishna Nerella Reporting and Analytics for HCM
-
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 21 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, RaviRavi-Palacharla-Oracle 97 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)Summary: We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are …SarthakRohilla 3 views 0 comments 0 points Started by SarthakRohilla Reporting and Analytics for HCM
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En…
-
Is it still available to use the ORA_ASSN_REC_COMPLETE_PENDING - LOOKUP CODE from HR_LOOKUPS table?Summary: Content (please ensure you mask any confidential information): I am working one report and i need to know all sub status for one learner. I used the following q…ClaudiaManea 2 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 684 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
How to enable horizontal scroll while creating/editing a xpt reportSummary: How to enable horizontal scroll while creating/editing a xpt report Content (required): Create a xpt report using data model having many columns, while trying t…Bhavna-Civeo 11 views 2 comments 0 points Most recent by PadmanabhamP Reporting and Analytics for HCM
-
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 349 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 97 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 278 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 15 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 51 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 14 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 72 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.6K views 10 comments 0 points Most recent by Jose Aguilera Reporting and Analytics for HCM
-
MilanMohanty 90 views 2 comments 0 points Most recent by Ankit Chauhan Reporting and Analytics for HCM