BI Publisher
Discussion List
-
Getting "Check Reason" from person managementGood day, Is anyone familiar with the "Check Reason" field in person management? Please refer to the screenshot image below… I'm trying to fetch the values via SQL, I'm …notautomni9 15 views 1 comment 0 points Most recent by TudorV-Oracle Payroll and Global Payroll Interface (GPI) -
I am transposing the columns into rows in Excel templateI am transposing the columns into rows in Excel template and also splitting each Employee into separate sheet, but values against rows are not coming up correctly and al…Pavan AlixPartners 6 views 1 comment 0 points Most recent by Pavan AlixPartners Reporting and Analytics for HCM -
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 8 views 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM -
Oracle HCM BIP Report - Employee Hierarchy querySummary: I have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure. Eg: Manager A has 2 report…
-
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su…
-
A HCM BI Report is giving extra duplicate pages but the output is valid (the o/p is 1 page gives 2)Summary: A HCM BI Report is giving extra duplicate pages but the output is valid. If the output is 1 page it gives 2 pages of same data only in production environment. I…Chandan M-Oracle 4 views 0 comments 0 points Started by Chandan M-Oracle Reporting and Analytics for HCM
-
BI SFTP connection no longer working due to Key Exchange Algorithm DeprecationSummary: One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target serve…JEngalan 163 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Payslip with custom attachment nameHi All, We are trying to change the payslip attachment name to a different format (emp_name.effective_date.pdf or emp_name.effective_date.pdf). Please let me know if tha…GopalS 16 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the report history in the front en, but I'm unable to find related rec…
-
How to use nvl function in excel templateSummary: Using NVL function in excel template for Extracts Content (please ensure you mask any confidential information): Hi All - We have a requirement to fetch the req…
-
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…Saurabh_Mharolkar 38 views 2 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 30 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Each sheet of a BIP report extraction is extracted to a different Excel fileSummary: Each sheet of a BIP report extraction is extracted to a different Excel file Content (please ensure you mask any confidential information): Hi Each sheet in the…
-
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract…
-
Can customers report on Signer's IP Address for electronically signed documents within Oracle HCM?Summary: We have a need to report on all of the various components of electronically signed documents/forms within Oracle HCM Onboarding Journeys. These data items shoul…Marnetta Griffin 17 views 1 comment 1 point Most recent by Claudiu Postolache-Support-Oracle Journeys
-
Date Format not convertedSummary: I am trying to get date in the format of 'Monday, 1st of January, 2020' using the query below in data model: select TO_CHAR(SYSDATE, 'Day, DDth "of" Month, YYYY…
-
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 696 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to display the output of a BIP Report in multiple excel sheetsSummary: How to display the output of a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we created a BIP Report, w…Barile Alberto 400 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Output file name along with current dateContent Hi, Can someone help me how to add date in the output file name of BI report while downloading directly from BI catalog? ex: Employee Detailed Report_yyyymmdd.xl…Nivya Mathire 613 views 8 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Oracle cloud HCM sql queries to fetch details of employees who left the organization(ex-employee)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Srujana Reddy 61 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What parameters to pass when scheduling TimecardApprovalNotificationBulkReport to get XML fileSummary: Hi experts, We have a requirement to get the XML file from a seeded report - TimecardApprovalNotificationBulkReport. However, when scheduling the report, there'…
-
I need sql query to get employee timezone like employee working timezoneI need sql query to get employee timezone like employee working timezoneLakshmiVanarasi 18 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 16 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What is the table name of evaluation comment during "Share and Release" phase?Summary: What is the table name of evaluation comment during "Share and Release" phase? Content (please ensure you mask any confidential information): During performance…Stefano_Mazzocca 60 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
How to run Generate Prenote File report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report Generate Prenote File report of payroll module of HCM. But I don't know how to run this report. Thanks Content (…VAIBHAV L 44 views 6 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How to filter the employees basing on their Grade in a BIP ReportSummary: How to filter the employees basing on their Grade in a BIP Report Content (please ensure you mask any confidential information): Hi, we created a BI Report. Amo…Barile Alberto 18 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
BI table to retrieve Approval Status field in Workforce Compensation moduleSummary: Content (please ensure you mask any confidential information): Hello expert, do you know in which Compensation BI table is stored the highlighted value? Thanks …Valerio Curzi 15 views 2 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Connection time out while scheduling BIP reports post 24C upgradeHi All, We are getting Connection timeout issue while scheduling BIP reports. This is something we are experiencing post 24C upgrade. Does this has anything to do with N…Satyabrata Nanda 77 views 2 comments 3 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
PER_POSITION_BUDGETS is showing no data. Need Position Budget FTE for custom report.Summary: We need to add Position Budget FTE in a custom report but PER_POSITION_BUDGETS has no data. Do I need to add any role for this table to do we get this informati…Punnya Vijayan 16 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM