BI Publisher
Discussion List
-
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 44 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 22 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…
-
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 8 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI) -
how to merge data from 2 different data sets into Etext template in one line?Hello, I am creating a Etext template using seeded data model globalreportsdatamodel. I am adding fields from 2 different datasets so in the output it is not showing in …
-
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 -
Third party Balances Summary Report Differ when we run period range Group by No/YesSummary: We noticed an issue with "Third party Balances Summary Report" for source as Receivables. The issue is, the output/balances differ when we run the report for a …
-
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
-
How to get FCCS data to BIP?We have a requirement to get data from FCCS, to create a BIP report. Is there a way to add FCCS as a data source in BI?Abhilash Baggam 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Suppliers are not receiving remittance adviceSummary: I've a customer who moved to 24C in August, since then remittance notices are not being received by suppliers - they are all reporting not receiving them, not j…Maria Smith- de Novo Solutions 464 views 7 comments 0 points Most recent by Shashidhar AM Payables, Payments & Cash Management
-
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 810 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
User entity or data base item of learn moduleSummary: Hi all, I have a requirement to fetch course and it's assignee/learner data but unable to find any learn module user entity or database item. Can someone please…
-
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 23 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
SQL query/Table to get Selection Criteria In Learning InitiativeIn Learning Initiative while selecting learners we can choose criteria. the values in it are Organization Chart Criteria, Learning Assignment Criteria, or Person Criteri…