BI Publisher
Discussion List
-
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi
-
Receivables Billing History Extract - Unable to add custom parameter in BIP Data modelHello Experts, We have a requirement to add an extra parameter (Customer class) to the seeded report - Billing History Report. Data Model Path - /Shared Folders/Financia…Yugesh Keluskar 41 views 2 comments 0 points Most recent by Yugesh Keluskar Receivables & Collections
-
Issue creating RTF Template using Non-standard SQL Data ModelSummary: Issue creating RTF Template using Non-standard SQL Data Model Content (please ensure you mask any confidential information): I have created a new Data Model in …
-
I need a sql query to fetch number of performance document types usedSummary: I need a sql query to fetch number of performance document types used in the organization in talent management Content (please ensure you mask any confidential …
-
RTF Pivot Table Repeating GroupSummary: I'm developing a report where I would need duplicate pivot table based on country and put the data into different spreadsheets in excel. My problem is that Im n…Martin Smid-Oracle 12 views 0 comments 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, https://us.v-cdn.net/6034893/uploads/DY6GVHKZ7OXI/ess-job-parameter-issue.docx I’m facing an issue when scheduling the ESS job — as soon as I select the paramet…Ashish1Soni 71 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
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 42 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 71 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 21 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
-
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…KiranChittoor 1 view 0 comments 0 points Most recent by KiranChittoor Reporting and Analytics for ERP
-
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 19 views 0 comments 0 points Most recent 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 51 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 34 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 Most recent 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…