BI Publisher
Discussion List
-
Convert SYSDATE from UTC to the local timezoneSummary: Hi, I s there any way to convert the returned sysdate value from UTC Timezone to local TimeZone in Oracle Fusion BIP reports? We tried many recipes for that, bu…Taha.Elsisi 43 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
I need a query which will fetch Percentage of completed performance reviews with highest ratingsSummary: I need a query which will fetch Percentage of completed performance reviews with highest ratings Content (please ensure you mask any confidential information): …
-
How can we see the Reports which are there in My folder of Other UsersSummary: We want to see the reports which are there in My Folder of all other Users. Is there any other way we can do this without logging into each individual user and …Shrikrushna 72 views 15 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Need table references for Managed Object Groups / Element SetI have created an Object Group of the type Element Group and added a few elements to it. Now, I am trying to retrieve the list of elements from a BIP (BI Publisher) Repo…Sai Krishna Adabala 11 views 1 comment 1 point Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
MSC_HVGOP_WEEKLY_ALLOC_REPORTSummary: How can i join this table with Item related Tables Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
How to add a data group as child of a record in a parent data group in HCM Extracts in 25BHi Experts, I need to add Emp_1_DG as a child of the Emp_DG. So I want to declare a record in Emp_DG and in that record, under "Next data Group", I want to refer the Emp… -
What is equivalent table to xla_trial_balances in Oracle Fusion?Summary: Hi All, I am working on migartion a RDF report from EBS to fusion. Existing EBS report is using table xla_trial_balances which or equivalent table i am not able…hiteshsaroha 23 views 2 comments 0 points Most recent by hiteshsaroha Reporting and Analytics for ERP
-
I need a query which will fetch Percentage of employees with high risk of lossSummary: I need a query which will fetch Percentage of employees with high risk of loss in oracle fusion talent management Content (please ensure you mask any confidenti…Pritha 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I need a query which will fetch Percentage of turnover of top performing employeesSummary: I need a query which will fetch Percentage of turnover of top performing employees Content (please ensure you mask any confidential information): Version (inclu…
-
convert person from text to number in BIThe person number is presented as text when we export a report with the number to excel. Is there a way to get this person number as number value in reports? WouterWouter Schaap 11 views 4 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Custom Fonts Not Reflected in PDF Output – BI Publisher RTF Template (OLC Certification)Hi All, In the OLC module, our client provides certifications with text styled in custom fonts. I have uploaded an RTF template in BI Publisher and exported it to PDF fo…
-
Issue with RTF Template – Pivot Table MergingSummary: we are using a Pivot Table to display invoice data for suppliers across different legal entities over a six-month period (from the given reference period). Issu…
-
Customizing Email notifications for timecard transactionsWe have a requirement where we need to send customized email notifications for the below timecard transactions: If a timecard is submitted by employee, a custom email no…Rini_Varghese-Oracle 11 views 0 comments 0 points Started by Rini_Varghese-Oracle Reporting and Analytics for HCM -
Budget Override Request NotificationSummary: How to customize Budget Override Request Notification Data Model to enhance the Notification? Content (please ensure you mask any confidential information): Cur…Kalyani-Oracle 135 views 2 comments 0 points Most recent by Mohamed Bahgat AbdelFattah Budgetary Control
-
In which table do I find the name of school in Skills and Qualification > EducationSummary: In this query hpi.item_number_9 returns the ID of the school field. But I do not know with which table the ID must be linked to display the description of the s…Consultant Ian 32 views 11 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Query to extract open AP and AR invoices with all FBDI template fields to upload in another accountSummary: We are splitting our Legal entities and hence we need to extract all open Invoices and upload into a different account. Can you please help me with a query to e…
-
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
-
How to check list of scheduled or standard notification jobs scheduled in oracle fusion for each modSummary: Hi , We need to see the list of all schefuled ess jobs mainly of those standard notifications getting triggered in Quality management module. How do we check th…
-
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
-
Configuring Descriptive Flexfield Segments With Expense Report ParametersContent What attributes are enabled as flexfield parameters, and the syntax to be used in the value set logic for the Expense Report? I'm creating a new flexfied, in the… -
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
-
Are there any roles to provide read-only access to a data model in oracle fusion?Summary: Hi, I want to provide read-only access to one data model to one of our users. Is there any roles or configurations that will help in providing read-only access …NagarajuKunchala 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
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.7K 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
-
Payslip is not sending to FTP through Payslip ExtractHello Team, Greetings of the day!! In seeded Payslip Extract, we have an additional delivery option which will send the Payslip XML data to FTP and it is working fine ea…