BI Publisher
Discussion List
-
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. 13 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 12 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 98 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 220 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 22 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 25 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 69 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
-
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…Sharron L 179 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle 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 65 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Trouble converting Double to Decimal/NumericSummary: Attempting to create a BI report which creates a file for sending via SFTP to a 3rd party. When creating the Data Model, I'm able to use OBIEE in the SQL query … -
Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 33 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following …
-
Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 99 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
Payroll Flow PatternSummary: Does anyone have a sql they have used to get a dump of all payroll flow patterns and the corresponding tasks and following task in a pod? Including Created By, …Jen Barthel 11 views 2 comments 0 points Most recent by Venkat Balasubramanian-Oracle Payroll and Global Payroll Interface (GPI)
-
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 2 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Query to get the list of roles in applicationSummary Query to get the list of roles in applicationContent Hi Experts, Is there any seeded query or custom query available to pull the list of all seeded and custom ro…Charan Kollipara 1.6K views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Payslip Template ChangesHi all, I'm hoping someone can help me here. Our payslip is a customised version of the seeded one provided by Oracle that currently has every page in landscape. We'd li…MikeW 12 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Time Zone in OTBI is not in sync with timezone set in user preferencesSummary: Time zone in OTBI/BI Publisher is not in sync with the time zone set in user preferences 1) How to find out all the users who have this mismatch? 2) How to sync…Keval_Shah 254 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Query For External Record Learning Experience(Non Catalog Learning)Summary: I am unable to find below two fields to fetch a data from 'Record External Learning Experience' screen. Field1: URL Field2: Start Date (Under Completion Detail)…
-
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…Sushant95-Oracle 8 views 2 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 25 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 118 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
BIP - Completed Learnings ReportSummary: Hello, Has anyone tried creating a BIP report that contains all of a learner's completed learnings at a course level? (Completed, Bypass Completed) Below are th…Hazel De Castro 62 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM