BI Publisher
Discussion List
-
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec… -
how to change the hyperlink text in the workflow checklist tasks notificationSummary: I am trying to change the "More details" hyperlink to "Click Here". attached is the data model, xml output and rtf template screenshots any idea ? Content (plea…Shlomo Elnekave 12 views 1 comment 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
hi all, by any chance can you point me to the join between per_person_names_f and CMP_PLANS_BSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 29 views 2 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 80 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f…
-
How to fetch Level 1 department for a person via SQL codeWhats the sql code behind level 1 department in Worker assignment real time subject area?
-
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 140 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
Report for Changes OnlySummary: We are currently not able to pull out a report with the last change done for a person in the system. Content (required): We have multiple reports in Oracle base…
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Reporting Capability Maturity Matrix : Reporting Road MapSummary: I'm trying to develop a notion or framework for "Reporting Capability Maturity", as something organisations could use to assess how good they are at Oracle repo… -
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 135 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 112 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 32 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 23 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 575 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 35 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 41 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 132 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 13 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 …