BI Publisher
Discussion List
-
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…Siva Sankari N 43 views 3 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
query to pull Reporting information calculation cardSummary: query to pull Reporting information calculation card Content (required): Hi All, Greetings! We are looking for a query to pull Reporting information calculation…Parag Hiremath 3.3K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…Valeriy Gorbunov 142 views 3 comments 0 points Most recent by Deepa Venkatesan Reporting and Analytics for HCM -
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 104 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BIP Report - Dynamic Password Protection For Excel OutputSummary: Is it possible to protect the BIP Report excel output file with Dynamic password? Content (required): Hi Team, I am looking for dynamic password protection for …Sudarshan Uppara 133 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
BIP Data Model with an Excel Data sourceSummary: I have a BIP data model with an HCM SQL data set/source and an Excel data set/source, which pulls the required data successfully. However, when I refresh the ex…Paul Morrissey 64 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
SQL query need to be debugSummary: Hi all, The Query which I run is showing the field names and the data is not populating. please help me to debug the error. Content (required): Outer joins need…RamkumarKadhiravan 11 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 184 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM
-
Is there any report that can be produced indicating when a user logs in using a password or SSO?Summary: Is there any report that can be produced indicating when a user logs in using a password or SSO in fusion? Content (required): Report/SQL Version (include the v…Fazal Subhan 22 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
UNable to query fusion_mds.mds_pathsSummary: UNable to query fusion_mds.mds_paths Content (required): Hi Team, There is insufficient privilege error received when we try to run query against table fusion_m…Parag Hiremath 36 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Publisher version controlSummary: Version control repository for BI Publisher Code Content (required): We would like to know how we can achieve version control for BI Publisher reports and metad…Ram Shankar 103 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 125 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
How to prevent those writing BI Publisher Data Models from who have ERP access to use HCM tablesSummary: We are trying to prevent those writing BI Publisher Data Models from who have ERP access from being able to use HCM tables and vice versa. Need to implement the…
-
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Database Item for Payroll Element Name in Fast FormulaSummary: Content (required): Hello experts, do you know the database item for Payroll Element Name in Fast Formula? We need to create eligibility based on people having …Valerio Curzi 21 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Current HTML Markup values are not working after 23B updateSummary: I've added BIP report to the UI using the HTML Markup. However, when I entered its HTML Markup values, the dashboard is not working as expected. Upon checking, … -
oracle.xdo12c.xpath.XPathException error on Payslip templateSummary: oracle.xdo12c.xpath.XPathException error on Payslip template Content (required): Hi Team, Greetings! We are getting below error for few records from Payslip tem…Parag Hiremath 15 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What table to use to get data for checking the Stage Table Capacity Used for HDLSummary: I would need to build a custom alert to check if the Stage Table Capacity Used for HDL has reached over 75% . Content (required): Version (include the version y…
-
Extract Specialisation, Spec Section, Course, Offering, Offering Section, Activity in 1 row?Summary: Is there a way to extract the Specialisation, Specialisation Section, Course, Offering, Offering Section and Activity in one row? Content (required): Is there a… -
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff…Janardhan ACS-Oracle 738 views 2 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to show parameter in exacel template in fusion bi reportSummary How to show parameter in exacel template in fusion bi reportContent In BI report datamodel, I have taken parameters and build report also. Now in bi excel templa…Soumya Goswami-Oracle 66 views 6 comments 0 points Most recent by ShitalRamteke Reporting and Analytics for HCM -
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Mallikarjuna 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need table and field names in ORC Requisition Page->Progress SectionSummary: Need table and field names in ORC Requisition Page->Progress Section. Kindly help, below is the screen shot of the page and highlighted the fields. Progress Sec…GajavalliKoteswararao 52 views 2 comments 0 points Most recent by Ronal Khara-Oracle Reporting and Analytics for HCM
-
Fast Formula making difference between date fieldsSummary: Content (required): Hello experts, do you have an example of fast formula making the difference between dates? For example we need to create a fast formula maki…
-
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…Awadhendra Tripathi 3K views 4 comments 0 points Most recent by Gamidi Venkat Rambabu Reporting and Analytics for HCM
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 6 comments 0 points Most recent by User_CTDSJ Reporting and Analytics for HCM
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke… -
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 128 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…