BI Publisher
Discussion List
-
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.5K 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 52 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 68 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 161 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 145 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 225 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
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 38 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…Deepak Bhatt 21 views 1 comment 0 points Most recent by Asmita Barman Reporting and Analytics for HCM -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 563 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM