BI Publisher
Discussion List
-
How to get all Active and Inactive Records Regardless of Assignment Type Except for Inactive PendingSummary: Hi All, I have a report that get all Active and Inactive Records but I want to Exclude Inactive Pending Worker only. Any one have already tried this? Trying to … -
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 40 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Office 2019 Oracle BI Publisher ErrorFor example when I try to load a xml data ı got this message Hello I just downloaded Oracle BI Publisher but at my publisher area there is an error . I tried to install …Kaan Can Calkan 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…Tisha Negrete 1 view 2 comments 0 points Most recent by Tisha Negrete Reporting and Analytics for HCM
-
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environmentsContent Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Con…Prudence K 48 views 6 comments 4 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Does BI Publisher allows dates in dd/mm/yyyy format?Summary: Does BI Publisher allows dates in dd/mm/yyyy format? Content (please ensure you mask any confidential information): I see only these formats: I need dd/mm/yyyy …Stefano_Mazzocca 41 views 5 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
unauthorized access: either you do not have the privilegeSummary: Content (please ensure you mask any confidential information): hi team, I have embedded a bi report, but I'm getting this error- unauthorized access: either you…Alex_Balanovsky 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…Nivya Mathire 33 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 31 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Course CategorySummary: Hi, Do you know where can I find the course category either in BI Publisher or in OTBI? Content (please ensure you mask any confidential information): Hi, Do yo…
-
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 14 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.2K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemIDSummary: Content (required): Hello experts, do you have a query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemID? We need to recover both keys…Valerio Curzi 43 views 4 comments 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I…User_2025-01-30-03-28-08-030 42 views 9 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…Ranjubala Pradhan 74 views 3 comments 0 points Most recent by Ranjubala Pradhan Reporting and Analytics for HCM
-
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In…Naveen Jayaraman-48236 83 views 5 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Is there a table or view that contains goal names before approval?Summary: Is there a table or view that contains goal names before approval? It seems that HRG_GOALS contains the information such as GOAL_NAME, SUCCESS_CRITERIA_TEXT, LO…S.Watanabe0110-Oracle 51 views 5 comments 0 points Most recent by S.Watanabe0110-Oracle Reporting and Analytics for HCM
-
Problem with the sender for a bursting reportHi folks! I'm developing a simple notification with BI Publisher report using the bursting, but if I use for sender any address with domain @customer.com the system indi…Gian Luca Triglia 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 32 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Value set retrieving lookup meaningSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve by value set the CMP_CWB_CUST_COL_46_LIST lookup meaning entered…Valerio Curzi 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
Compensation Components amount, date and plan name BI TablesSummary: Content (please ensure you mask any confidential information): Hello experts, we cannot find Compensation Plan Components amounts, effective dates and plan name…Valerio Curzi 23 views 3 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
How to know from front end which field is available in which back end table in oracle fusion cloudSummary: Creating a Report on Apprenticeship. Content (please ensure you mask any confidential information): Need to find data in the Oracle tables for Apprenticeship. H…Pradnya_Pampatwar 477 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo…
-
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM