BI Publisher
Discussion List
-
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 230 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
Candidate Risk of Loss and Candidate Impact of Loss field table namesContent HI All, We have a requirement to fetch the succession plan, Candidate Impact Loss and Candidate Risk of Loss details through BIP . I find the "HRM_PLANS " and "H… -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 327 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you…Valerio Curzi 14 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Unable to see output on scheduled report jobSummary We have users, not all, that are unable to see the output file from a scheduled report job.Content Does anyone know what may be causing some users to be able to …Ellen Manthei 118 views 5 comments 0 points Most recent by Erika Szewczyk_UCSD Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 42 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion … -
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…Simranjeet Singh 109 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
RTF holding on the empty space if the condition is not satisfiedHi, I facing an issue with rtf template where if the condition is not fulfilled it shows blank space and then the next text in the report like below picture Is there som…chpriyanka 246 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
How to Print data in reverse mode through RTF template , Ex: ABCD>>DCBASummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. I found fonts from internet , but those are m…SAKTHI SUNDAR 124 views 4 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for HCM -
Query to list all the tables used by a BI publisher reportSummary: Experts - Is there any base table that stores the various tables used in a datamodel for a BI publisher report? Content (required): Version (include the version…Vijay Rajendran 819 views 4 comments 2 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
How to access deleted data information using BI Publisher?Summary: 22A Record Additional Data When Deleting an Assignment Record Using Employment Info Page indicates accessing the deleted data information in BI Publisher (PER_E…Viviane Beaudoin 29 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
HCM Extract Delivery via emailSummary Attempting to send a extract via BI report in emailContent We have an extract setup that uses Bi to deliver the data in a report. In the extract, we are able to … -
How to know whether a position is vacant or not in Oracle? from which oracle fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Gleamy Mishra 22 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
User's Roles table to track historySummary User's Roles table to track historyContent Hi All, Can any one please help me out with table name which tracks the history of users and roles details. I want to …nitin Sharma 1.1K views 8 comments 0 points Most recent by Dirk Blaurock Reporting and Analytics for HCM -
Oracle Fusion Application - Usage StatisticsSummary Oracle Fusion Application - Usage StatisticsContent Hello, Can anyone please help me to capture usage statistics on Oracle Fusion Applications? I was using one o…SantoshKumarBhairi 141 views 11 comments 1 point Most recent by Shannon_Johnson Reporting and Analytics for HCM
-
FIlter on Excel BI Publisher TemplateSummary: FIlter on Excel BI Publisher Template Content (required): We want to apply a filter on a column in the excel template. We have a report showing all employee of …A.Ferraro 340 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Performance Document Changes Audit ReportHello, We have a need to audit our Performance Documents to understand who all made changes on a performance document. Each time a rating is changed we want to generate …Nick Dorfner 308 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 26 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 41 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Extract text data from "SuccessCriteriaText" in "XML_DATA_CACHE" column "HRC_TXN_HEADER" tableSummary: Does anyone know how to extract text data from "SuccessCriteriaText" column in "HRC_TXN_HEADER" table? Although I could extract some text data such as GoalName,…S.Watanabe0110-Oracle 160 views 1 comment 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM -
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_…Marta Martinho 13 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 289 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 3 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 35 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 250 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM