BI Publisher
Discussion List
-
What payroll field and table track if a deduction (element) was actually deducted from gross?Summary: If an employee's gross pay is not large enough to accommodate all of his/her payroll deductions (i.e. taxes, benefit deductions, 401K), it looks like Oracle ded…BeachDreamer 121 views 1 comment 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
23D Table ImpactedHello Team, Can anyone tell me the List of Table that is getting depreciated or new table being introduced in 23D release of Oracle Cloud ERP. Thanks, Sandeep Shaw -
Unable to get excel outputSummary: Hi, When I run the report to get the output in CSV, HTML etc. its fetching all the column values but when I run it to get the output in Excel format few columns…Satish123 11 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Report to get the list of employees with change in payroll groupSummary: Report to get the list of employees with change in payroll group Content (required): Hi Team, Greetings! The change in payroll group, especially from weekly to …Parag Hiremath 31 views 5 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
HCM extract pulling changes several days after change was madeSummary: Content (please ensure you mask any confidential information): Hi, we have a series of HCM extracts that pull various data pieces in order to be fed to a 3rd pa… -
Standard report to track dashboard and reports accessesHi, is there a standard report that is useful to track users accesses in Dashboard HR and also the detail on which reports in this dashboard they access? We configured t…Mara Tammaro 12 views 2 comments 0 points Most recent by Mara Tammaro Reporting and Analytics for HCM
-
Adding two person types into one OTBI analysisSummary: According to our current practice when employees are retiring we change their person type into "retiree" in the system. I need to create an analysis to capture …Ayesha Iroshani 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
ESS Job Report with link between parent and child requestsSummary: ESS Job Report with link between parent and child requests Content (please ensure you mask any confidential information): Hi Team, We use the different reports …Parag Hiremath 636 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to extract data from an xmltype columnSummary: How to extract data from an xmltype column that is in the table ZX_CONDITIONS Content (please ensure you mask any confidential information): I am trying to put …
-
Security feature for AR invoice print options available in view image button of transactionsSummary: Is any security feature for AR invoice print options available in the view image button of transactions Content (required): Users are saving(save as pdf method)…Siva Gollapalle 116 views 5 comments 0 points Most recent by Nikki Reich Reporting and Analytics for ERP
-
How to bulk download HCM Extract/Payslip data xml files from past 1 year runSummary: For a third party integration, we need to download payslip data xml files for past 1 -2 years. Data XML is not defined as extract delivery option. The only way …
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
How to get the Path of Sub Templates of Total Compensation Statement Seeded ReportSummary: We have a requirement to Customize the Total Compensation Statement Seeded Report Template We are not able to get the path of the sub Templates used in it. Cont…MilanMohanty 41 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
RTF - Display hypen instead of 0 for currency amount in excelSummary: Hello, I was wondering if it is possible to display the Excel Accounting 0 value as " - $" (as below) using RTF template. I currently use this format 999G999G99…Guillaume SAVALL 42 views 2 comments 0 points Most recent by Guillaume SAVALL Reporting and Analytics for HCM
-
Link a report to a button near to the All-in-One evaluationSummary: Content (please ensure you mask any confidential information): Hi experts, I need to add a link that redirect me to a dashboard. Is it possible to achieve it th…Elena_Panniello98 11 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
When is status change type ORA_DELETE_AUTO used?Summary: Cannot find ORA_DELETE_AUTO in the HCM lookup tables despite being visible in status_change_type for WLF_ASSIGNMENT_RECORDS_F. When is this used? Content (requi…
-
23D HIDE RECOMMENDATIONS FOR COMPLETED LEARNING "No Alert Trigger"Once learners start learning items, that recommendation will get withdrawn, and there is no alert trigger for withdrawn items as well as for the recommendation. On the l… -
Which action for a DEEP LINK can I use to manage a REQUSITION in DRAFT status?I need to create a custom notification with a link that leads to the detail of a requisition that is in draft status. I've tried with this deep link: //fndSetup/faces/de…Gian Luca Triglia 31 views 5 comments 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 130 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report - Hourly/Salaried vs Rate Value for the GradeSummary Looking to crate a report to get Hourly/Salaried vs Rate Value for the GradeContent From Person Management - Get If person is Hourly or Salaried. Then navigate t…SD Acush 71 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to restrict based on previous Backout statusSummary: Hello All, I'm currently working on restricting the custom BIP notification based on below scenario. If an employee benefits is backed out and reprocessed again…
-
Newly Created Supporting References not showing up in OTBI ReportSummary: I created two non-balance carrying supporting references - see steps I followed below. After creating these, I ran the following query within Reports & Analytic…Akbar Ahmed 161 views 1 comment 0 points Most recent by Akbar Ahmed Subledger Accounting & Accounting Hub
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output fileI have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the last update…Deepa Kumari 51 views 3 comments 0 points Most recent by Deepa Kumari Reporting and Analytics for ERP
-
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app…Sowdha Murugan 12 views 1 comment 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic…
-
Link/tab or any option on create Journal pageSummary: Hi Our requirement is to looking to take the print out the Journal page, Is there any feature or url/link/tab to add enable at Journal level so that user can cl…MGS tech 32 views 6 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Standard template Compensation Change statements notificationContent Hello experts, I need to change the notification template the employee receive when Compensation Change Statements is available in Person Information> My Compens… -
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 84 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales
-
How to join cmp_stock_details & hrc_integration_key_mapSummary: We are trying to create a report for fetch source system ID used for loading stock but No joins are available to join cmp_stock_details & hrc_integration_key_ma…Niharika 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM