BI Publisher
Discussion List
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 3.9K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM -
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 11 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it…Stefano_Mazzocca 11 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 105 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Export to XLSX and avoid limitation for 65k rowsSummary: Content (please ensure you mask any confidential information): Hi there, I use Learning reports in Fusion. When I export a BI report that has more than 65K rows…Bobby Jourdan 96 views 12 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sivaram Injeti 21 views 3 comments 0 points Most recent by Sivaram Injeti Reporting and Analytics for HCM
-
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …Ruzwan Akram 450 views 10 comments 0 points Most recent by John Guner Reporting and Analytics for HCM
-
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid…Matheus Roberto 21 views 0 comments 1 point Started by Matheus Roberto Reporting and Analytics for HCM -
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…
-
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…
-
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…Anton Rzhanov 14 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf…MilanMohanty 102 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
I embedded a BIP report in front end. But refresh button is causing problem.I embedded a BIP report in front end. But refresh button is causing problem. First I have to click apply and then refresh button (green higlighted) then only report is a…
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 16 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.5K views 6 comments 1 point Most recent by User_6I7ZA Reporting and Analytics for HCM -
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…
-
How to fetch current incumbent name for a Position_code/position idSummary: Please Help! Please share your insights ASAP! I need help in fetching current incumbent name tagged to a position code. I wrote the query like this : SELECT DIS…
-
Reporting employee access to dataHello Experts, It was rise as a demand the possibility to have a report on what employee has access of country data, i was trying to use per_person_secured_list_v and pe…Lucas B Maciel 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
how can i fetch in bip report parent position name and parent position code for a position codePlease Help Me! Need to write a sql query for all the position details, in which i need to fetch parent position name and parent position code, how can i fetch that in b…ANNU10 13 views 4 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Need SQL query to get Set General PreferencesSummary: We need a query for the setup Set General Preferences as shown in the UI. We are unable to get Date format, Time format and Time zone as shown in UI page. For e…Opkey PA 21 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits…
-
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…User_2025-03-07-05-34-02-150 1.4K views 9 comments 0 points Most recent by User_YG5HR Reporting and Analytics for HCM
-
Trace the processing details of scheduled BIP ReportSummary: Trace the processing details of scheduled BIP Report Content (please ensure you mask any confidential information): Hi Team, Greetings! What are the best option…Parag Hiremath 24 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Segregating the success and error report to different email id through SOAP UI Request PayloadSummary: I did a POC , using the SOAP UI Payload request i'm able to get the email notification to multiple emails. but the expectation was like for success report we wi…Ankita Mohanty 21 views 0 comments 0 points Started by Ankita Mohanty Reporting and Analytics for HCM
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
Employee time card punch in, punch out details SQL query in OTL fusion HCMSummary: Hi Team, We have a requirement to send notification to employees who has missed their time card punch in, punch out. Can anyone please help me with the sql quer…Prasad Singamaneni-Oracle 97 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 123 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM