BI Publisher
Discussion List
-
SQL query to fetch the Candidate university name from Academic qualification section in ORCHi Team, Need assistance, we are trying to fetch the university name from the candidate education qualification section. But not getting the data from this table IRC_PRO…xbyz-Oracle 31 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
BIP Web Layout Editor (.xpt) Pivot table Header's Vertical alignmentSummary: Is there really no Vertical Alignment in Measure labels header in a pivot table in .xpt report template? it looks in the center in edit but in the output: I tri…Carlo Reyes-59977 1 view 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Getting Person ID of the direct reportee from a comp page for which the Manager is viewing the dataSummary: On the Compensation Info page, we have a requirement to embed a report with additional compensation information details and when a manager tries to click and vi…Rini_Varghese-Oracle 11 views 2 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
How to see who deletes datamodel/report in catalog?Summary: How to see who deletes datamodel/report in catalog? Content (please ensure you mask any confidential information): A datamodel is missing under analytics/catalo…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.6K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 21 views 3 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
employee tax declaration table name in fusionSummary: Content (please ensure you mask any confidential information): Hi team , need help on table name . where we will get all employee chooses which tax regime data …supriya kadam 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI) -
Report on if employee has viewed / downloaded DOR?Summary: Hi team, We have recently been asked if we can report on if an employee has viewed / downloaded a specific DOR and/or its attachment? I am unsure on whether or …Luke.Findex 21 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Workflow Notification addition to DM and BI template not showing up on UI page (ManageCompensation)Summary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not…
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 61 views 4 comments 0 points Most recent by Ashish_Sahoo_Trinet26624 Reporting and Analytics for HCM
-
List of all Agents created in OTBISummary Ability to report on scheduled AGENTS - Listing of Agent, Report Recipient and Frequency (schedule)Content The Payroll/HR department is lookin for a report that …Raz Baboorian 764 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
HRT_PERSON_PERF_RATINGS_V shows all performance ratings not just talent ratingsSummary: When querying the HRT_PERSON_PERF_RATINGS_V table, values from incomplete performance documents will show. How do we otherwise restrict this table to show only …
-
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.3K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
A bip query is running very long timeBelow query is running for a long time in production and eventually timing out when with the filters but without the filter is running and fetching some data. It was wor…
-
Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP CloudSummary: Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud Content (please ensure you mask any confidential information): I wo…
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 249 views 7 comments 0 points Most recent by Bisweswar Goud-Oracle Reporting and Analytics for HCM -
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 162 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM
-
Need table for Provider setting values for the task Configure Candidate Experience CAPTCHA ProviderSummary: Hi Could you please help me out to find the table where the information for Provider setting values in the task Configure Candidate Experience CAPTCHA Provider …
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…Valerio Curzi 507 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I modify existing seeded workflow notification template?Content I have a requirement to modify existing seeded template for Workflow notification(Transfer Report). I have found the template and copied it in custom folder and …User_2025-02-06-14-37-05-233 244 views 6 comments 0 points Most recent by Kotakonda.Balasubramanyam-Oracle Reporting and Analytics for HCM -
XSLT Template Add Day to DateSummary: XSLT Template Add Day to Date, There is a date to which we need to add two business days (excluding weekends) and display in the output. in XLST Template only. …Rajdeep Chavda 11 views 2 comments 0 points Most recent by User_VQTGR Reporting and Analytics for HCM
-
how to fix #VALUE! error in excel templateSummary: i am using DATEVALUE function to convert text to date in excel template.However incase of blank date i an getting #VALUE!. Can anyone please help to reslve the …minati_behera-Oracle 11 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM
-
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d…
-
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err…
-
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM