BI Publisher
Discussion List
-
Table for Job Profile ReportContent Hi, How do I get the Job Profile name attached to the job? Which table contains the same and what is the relation to Job table? Kindle help. Regards, Nivya Versi…Nivya Mathire 139 views 9 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Differance between data table ending with "_" and normal data table?Summary: Differance between same data tables but ending with "_" table? Content (please ensure you mask any confidential information): Hi Team, I have a query. what is t… -
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 107 views 1 comment 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
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 -
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 11 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 549 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 31 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 -
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 32 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… -
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… -
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… -
BIP report job status - difference between 'failed' and 'skipped'Summary: BIP job status - skipped and failed - what do these mean Content (required): We have a number of BIP report jobs running to send out letters / notifications to … -
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 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 103 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Change in the environment from production to test in links to reportsHi, We want to change links to BI PUBLISHER reports within the dashboard. When we do P2T we need to go through all the links and change them from the production environm…Alex_Balanovsky 34 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Customize option is not visible.Summary: Content (please ensure you mask any confidential information): Cannot view customize option on talent fyi notification record. is there something i'm missing? V…Pranjal Mohla 212 views 2 comments 0 points Most recent by Pranjal Mohla Reporting and Analytics for HCM -
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on… -
Oracle BI Tables to retrieve manager hierarchy level and Plan Access LevelSummary: Content (please ensure you mask any confidential information): Hello experts, which Oracle BI tables allow me to retrieve manager hierarchy level and plan acces…Valerio Curzi 32 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 713 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Database items for Minimum and Maximum Input valuesSummary: Content (required): Hello experts, which database items allows me to extract the attached information (minimum and maximum input value). Thanks a lot in advance…Valerio Curzi 21 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need Workforce Learning - Learning Management Real Time BIP tables with Attributes/DFF valuesSummary: Unable to find BIP tables with Attributes/DFF values in Learning module. Content (please ensure you mask any confidential information): Seeking help in finding …VenkataSubbareddy 63 views 6 comments 0 points Most recent by VenkataSubbareddy Reporting and Analytics for HCM -
Can we dynamically change paramters value in each execution run of scheduled BI report.Summary: We want to change the report paramter value in each execution run of scheduled BI report. Content (please ensure you mask any confidential information): Version…Sourabh_Patial 31 views 4 comments 0 points Most recent by Sourabh_Patial Reporting and Analytics for HCM