BI Publisher
Discussion List
-
per_person_secured_list_v view problemSummary: per_person_secured_list_v view is ignoring past events Content (please ensure you mask any confidential information): Hi, we have an admin user and she should h…Stefano_Mazzocca 57 views 2 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How to add custom Parameter to PayslipSummary: Need to be able to print Payslip by Departments for specific Departments following a Pay Run Content (required): We have over 60 departments and some department… -
SQL Query to get Value Set ListSummary SQL Query to get Value Set ListContent Hi Team, Could you share me any BI/SQL query to fetch the all list of Value sets using in HCM Instance like Dependent, Ind…User_2025-01-29-00-33-34-534 3.5K views 4 comments 0 points Most recent by Swarna Mahadevan Reporting and Analytics for HCM -
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Overtime period field on payroll relationshipSummary: What table(s) can I find the Overtime Period field on the payroll relationship. I am being pointed to HWM_RP_TM_PERIODS_TL but this table does not seem to have …
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Employee / Employer Pension Contribution Report for a specific durationSummary Employee / Employer Pension Contribution Report for a specific durationContent Hi, May I check if anyone has any OTBI / BIP report for Employee / Employer Pensio… -
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…Farah Alajou 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Table name/Report for Structure (Navigation Configuration)Summary : We require a report or table name that contains the configuration for the 'Navigation Structure.' This information will be necessary to ensure consistency in t…Bhupesh 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 57 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
BI table name to fetch Module from Manage common lookup screenContent Hi Experts, I have a requirement to fetch module from manage common lookup screen. Please help with relevant BI query. Thanks SandipSandip Karmakar 205 views 8 comments 0 points Most recent by User_2FZC5 Reporting and Analytics for HCM -
Tables used in "User Password Changes Audit Report"Hi team, would like to know the tables used in the User Password Changes Audit Report program and do we have any standard report for user account name changes in oracle …chandrakanth makam-Oracle 25 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for HCM
-
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…Hitha Harikumar 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 145 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to deliver xml within body of email via BI Publisher?Content (please ensure you mask any confidential information): I understand this is possible by setting the delivery method as HTML via bursting, however is there a way …Luke.Findex 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 105 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
Payroll element BI table where retrieving employee Assignment IDSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve for an employee the assignment id where a payroll element is loa…Valerio Curzi 13 views 3 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Excel Template error 'Maximum active cells allowed in a template is 100000'Summary: Hi Team, We are trying to create a report using the Excel template since there are a lot of tabs expected in the Excel output. We are getting the error 'oracle.…Tanu Shri Patel 214 views 6 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 21 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Query that link Legal Employer to Reporting EstablishmentSummary: Hello! Good morning/afternoon/evening Customer Connect! I am in a need of a query that can list all the Reporting Establishment for a Legal Employer. Does anyon…Matheus Roberto 27 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 92 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Benefit:Certifications and Action Items tables informationContent Hi All, We have a requirement to fetch "Certifications" and "Action Items" tab related data in the BIP report. May I know in which tables holds this information …
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 61 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management