BI Publisher
Discussion List
-
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 13 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM -
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
Where can I find Talent Review Columns of Task Subject, Task Status, Task Owner and Task Due Date?Summary: In what table can I find Talent Review Columns of Task Subject, Task Status, Task Owner, and Task Due Date? Content (required): Here is a brief description of t…Basti 12 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Looking for Department column which contain value of PSSR Requisition DFFSummary: I am looking for Department column which is populated with new value using DFF. Please find attached doc for reference. Content (please ensure you mask any conf…Pooja_123 22 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Query that fetch Grade Rate Value for a certain personSummary: Hello! I need help to get a query that passing the assignment_number of an employee I can get the value field of a Rate Value inside the Grade of a person. Exam…Matheus Roberto 44 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
SQL Query Timeout is greyed outSummary: SQL Query Timeout is greyed out. I have logged into xmlpserver but is still unable to change the SQL Query Timeout. Is this field no longer updatable? Content (…Consultant Ian 90 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 31 views 5 comments 0 points Most recent by Rajesh Jupudi-Oracle Reporting and Analytics for HCM
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
Hide Diagram tab in Data Model for the BIP report for users with particular fusion HCM roleSummary: Hide 'Diagram' tab in the Data model for users with particular fusion HCM role Content (please ensure you mask any confidential information): There is a require…Girish_Kulkarni_123 12 views 2 comments 0 points Most recent by Girish_Kulkarni_123 Reporting and Analytics for HCM
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
Modified payslip Data model bursting is not workingSummary: We are trying to achieve the requirement to send payslip for ex-employees over personal email address, Below is the custom bursting data model that we modified.…Rama123-Oracle 1 view 1 comment 0 points Most recent by Faithe Chu-Oracle Reporting and Analytics for HCM
-
How to add attachment to bursting?Summary: How to add attachment to bursting? Content (please ensure you mask any confidential information): I need to add a zip file to an email sent via bursting. Where …Stefano_Mazzocca 18 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 32 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…DebayanB 18 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD…Aishwarya_15 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 13 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …Farah Alajou 52 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Globally Change User Timezone Preference in OTBISummary Is there a way to globally change users' timezone preference in OTBI?Content Hi! I am wondering if anyone knows if there is a way to globally change the OTBI tim…Lindsay Lamont 63 views 8 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM -
REQUESTED_FOR_PERSON_ID Foreign key for BI ReportSummary: REQUESTED_FOR_PERSON_ID Foreign key for BI Report Content (please ensure you mask any confidential information): Hi, we would like to create a report which prov…Barile Alberto 12 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.1K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Missing a voided check in reportSummary: Missing a void check in pay_ce_transations Content (please ensure you mask any confidential information): Hi, One of our report to fetch a list of voided checks…
-
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. CRitika.ray-Oracle 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…Amrita_Pritam_Nayak 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 43 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
User login details reportContent Hi Team, We have a requirement to see the list of users logged into the Fusion application on a specific day, in a format like the below sample: User Name | Logi…Arun Kumar Krishnan [AK] 617 views 3 comments 2 points Most recent by Naveen.yadav Reporting and Analytics for HCM -
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…