BI Publisher
Discussion List
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 92 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 44 views 12 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas…Dae 93 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there …Parag Hiremath 39 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 25 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 49 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 545 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 447 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 27 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 316 views 1 comment 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…Manish_Chauhan 18 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da… -
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
How to include a pdf attachment in a custom NotificationSummary: How to include a pdf attachment in a custom Notification Content (please ensure you mask any confidential information): Hi, we created a BI custom notification.…Barile Alberto 75 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 301 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
XMLP Server - Security & User AccessSummary Testing security and user access of XMLP ServerContent Hi All, We are looking to restructure our Reporting Catalogue for our HR users where they will use a dashb…User_2025-02-05-05-51-12-049 36 views 10 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter? -
Report on User Actions in Oracle HCMSummary: Good evening, I need to extract a report with all the actions performed in the system by users (e.g., hiring an employee, entering Performance Goals, etc.). Is …Guido Masciello 21 views 2 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM -
Can anyone explain scecurity being used on seeded DM?Summary: The business looking to add security to a custom version of EmploymentCreateProcesses, like the security being used on seeded /shared/Human Capital Management/W… -
how to use get_variable in IF condition in RTF templateHi Team, We have a requirement to display the data in report based on net sal, to get this done we are using below tag in RTF template and its not working, we tried diff…Suresh Gandla-Oracle 501 views 4 comments 0 points Most recent by Arun Raj Reporting and Analytics for HCM
-
Business Unit Name ER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 781 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM table to fetch eligibility status of compensation plan.Looking for HCM table to fetch eligibility status of compensation plan as "Eligible" or "Limited".Tamseel Aijaz 19 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >…
-
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress…Valerio Curzi 43 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM