BI Publisher
Discussion List
-
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 54 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] 663 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 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report to monitor SCORMs answersHello everyone If the contents are SCORM, it is possible to produce reports (e.g. a report that highlights, for each individual question, the answer provided by the user… -
DFF information in our learning request approval flowSummary: We would like to include DFF information in our learning request approval flow . Is it possible to achieve it ? If yes, please suggest the steps for the same. C…
-
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…
-
In oracle fusion which table locations nameDear , Can anybody guide me in oracle fusion which table have location name. i tried to find but i cant. Kindly check the attached pic i need these column in table where…Mirza_Adeel 5.6K views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review MeetingsHi team I hope you are doing well. I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review Meetings (Box label, Rating, and manager name) Kind regard,Mohamed_Shafay 63 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How do I create a preprint for a withholding certification for my suppliers when payment is made?Summary: In Nicaragua, you need to print a pre-printed document to give to the supplier as proof of the withholdings that were made on your payments. It is a fiscal docu… -
Birthday Notification to be sent with Custom text on ImageWe have requirement to send birthday notification to employee by keeping RM , HRRM , Employee direct reportee and RM direct reportee in CC The content of email is :- Dea…Surbhi Jat-Oracle 91 views 0 comments 0 points Most recent by Surbhi Jat-Oracle Reporting and Analytics for HCM
-
Looking for query to fatch the specific security profileSummary: Content (required): Hi Expert, We are looking for a SQL query to get the list of roles that are attached with a specific security profile like a document securi…
-
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 81 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3.3K views 6 comments 0 points Most recent by Stefan v. Glabbeek HCM Extract
-
BIP Report to get Employees with Bank Accounts not assigned in a Payment MethodSummary: Hello everyone, I am trying to create a report where I want to get a list of employees who have bank accounts that are not tied to any Personal Payment Method. …Tom John Bontoyan 61 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Is there a known limitation for HCM Extract Output generated in .txt format?Currently, we have an extract that makes use of the user entity, PER_EXT_SEC_ASSIGNMENT_BASIC_UE, and runs on system date; and the data model, globalReportsDataModel, to…
-
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…Praveen D 162 views 5 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…User_6I33I 28 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Need to add column in FAH application line level with 250+ characters and get to GL line level dffSummary: Need to have a character lengeth 250+ column in FAH application line level and flow to GL line level Content (please ensure you mask any confidential informatio…Dian Minshan 1 view 1 comment 0 points Most recent by Daniel Martin Subledger Accounting & Accounting Hub -
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc.
-
Is it possible to report on what learning content is attached to learning courses?Summary: My organization needs to audit the learning content (videos, PDFs, etc.) associated with our courses and offerings. I am exploring the Workforce Learning Conten…
-
New/Pending approval/requires approval goals in the tableContent Hi Team, We were able to get the details of the new/pending approval/requires approval from the table HRG_GOALS . In 20B we are not able to find the same. Is the…Nivya Mathire 143 views 8 comments 0 points Most recent by HasnatHRT Reporting and Analytics for HCM -
REST API learningContentItems ContentIdSummary REST API learningContentItems ContentIdContent Hi, I want to get a report for the learning item contentid with item title. Because of contentid to use in REST ap…
-
Line Manager Hierarchy with Active/Inactive employeesContent I am looking for a BIP report which shows all the active/inactive employees to a Line Manager Hierarchy. When Manager run the report then they can see all the ac…User_2025-02-10-21-21-05-328 237 views 19 comments 0 points Most recent by Revathi Thangaraj Reporting and Analytics for HCM -
Aor QuerySummary: Hi Expert, I have to add an AoR query in my almost five different BI reports. As of now, it shows all data, however, we need to reduce the results based on the …
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…Henry Imgrund 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Multiple School Districts and Multiple Cities per GeocodeSummary: When trying to build an OTBI Data Model for Tax Withholding, we are finding multiple cities in a Geocode (HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS), and multipl…ChicagoConsultant 21 views 2 comments 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM