BI Publisher
Discussion List
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 64 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …Scott Paulin 42 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…Rohankumar Patel 54 views 2 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Can we hide a specific sheet in the excel output for some users?Content (required): We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st she…Sujeeth Chinta 44 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 71 views 2 comments 1 point Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP reports emailed securely from HCM (by default)?Summary: BIP reports emailed securely from HCM (by default)? Content (required): We are scheduling a new BIP report to go to internal users and external (outside the com…Rich R 62 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
What permissions do I need to run BI Publisher Web ServicesSummary: Getting this error when trying to run the runReport request for the BI Publisher ReportService: PublicReportService::generateReport failed: user: [XXXXX] does n…SeanWesche 1K views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Need table name for Additional Person InfoSummary: Need table name for Additional Person Info.Please refer the attachment for the screenshot.minati_behera-Oracle 470 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Restrict schedule access to users when scheduling BI jobs and OTBI agents.HI Team, We would like to know how to limit scheduling capabilities to users when scheduling BI jobs and OTBI agents. This access should be limited to certain users. Cou…MadhanMH 88 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Data security on BIP reportHi friends, We have developed a BIP data model/report using the below tables which touches across payables, supplier and hcm. Some of payroll users having the Payroll Ma…Vijay Ramani VJ 333 views 5 comments 0 points Most recent by manish sharma Reporting and Analytics for HCM -
We have Multipul records in UI for each employee but we need only latest one that is top one?Summary: HI Team, We have Multipul records in UI for each employee but we need only latest one that is top one in below screen short? Could you please help me on . Thank…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
attachment in bursting not addingSummary: requirement is to add attachment using data model for custom report, in bursting section we have added email bursting and adding attachment but we are receiving…Rehber Hussain 98 views 5 comments 0 points Most recent by Rehber Hussain Reporting and Analytics for HCM
-
How to Embed BIP report with parameter onto person search screen in Oracle HCM cloudSummary: Embeded BIP report with person number parameter using page composer onto Employment Info screen into oracle HCM cloud. How do I pass searched person number to r…Eknath 651 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Field for Action Keyed Date?Summary: What is the field in Oracle BIP Reporting for the date an Action is keyed? Content (required): Hello, What is the field that shows when an action is keyed in th…
-
Secure Reporting on Person Special Category DataSummary: In 23B we see there is a new feature to secure reporting on Ethnicity, below is the detail. We also require this capability for other sensitive categories such … -
Reporting on element entry Correction - getting new and former values?Summary: There is a need to report on changes made to an element entry record of a person, where the 'Correct' editing option was used (not Update). We are seeking to ge…Shant Sarkissian_NES 47 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Element Entry Changes ReportSummary Copying an existing BI Publisher versionContent Hi, I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the re…User_2025-02-05-22-44-35-842 96 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Insufficient Privileges fa_fusion_soainfra.wftaskmetadataSummary Insufficient Privileges for running fa_fusion_soainfra.wftaskmetadataContent Hi All, Trying to run a query given on Fusion Global HR: Approvals Delegated To Othe…Meet Bhavsar. 180 views 4 comments 2 points Most recent by Ashok Sriniva-Oracle Reporting and Analytics for HCM -
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 817 views 3 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM
-
Need a sample SQL Data model using DFF and EFF Flex FieldsSummary Need a sample SQL Data model using DFF and EFF Flex FieldsContent We have several EFF and DFF fields were created in Oracle HCM. Can someone share a sample data …Prabhu Krishnamoorthy 701 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Connect to HCM Database through MiddlewareSummary: Just curious if I can connect to the HCM database through anything other than the cloud url Content (required): Hello, I am creating an integration using middle…
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 121 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is there a way to join these 2 subject areas?Summary: Is there a way to join these 2 subject areas: Human Capital Management – Approval Notification and Archive Real Time & Workforce Management – Person Real Time. …
-
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc…MilanMohanty 82 views 9 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…Ketan Prajapati 415 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y…Valerio Curzi 128 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…Bhargava Varma G 53 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…