Reports
Discussion List
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 15 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL? -
Need to find Entry Grade against Position in OTBISummary: Position Entry Grade reporting in OTBI Content (please ensure you mask any confidential information): Having issues with posting that I believe may be due to mi…Stephen Prentice 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 19 views 1 comment 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 16 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
EEO-1 report output format in HCM CloudSummary: EEO-1 report output format in HCM Cloud Content (please ensure you mask any confidential information): We are in the process of generating EEO-1 reporting that …Parag Hiremath 6 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Unable to list just one manager for each Matrix Manager TypeSummary: We have a report that provides employee details AND includes each manager type i.e. Line Manager, Comp Planning Manager, and Timeclock Supervisor. When we run t…
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…
-
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 19 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIA
-
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo…
-
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 18 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 836 views 9 comments 1 point Most recent by Srividhya Ramamurthy Reporting and Analytics for HCM
-
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default… -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
System Account OwnerSummary System Account OwnerContent Hello Everyone, We've updated a few reports back in October/2020, however we can see now the owner as System Account, (as per screens…Alvaro Couto 48 views 11 comments 0 points Most recent by User_BXP2P Reporting and Analytics for HCM -
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 39 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Information of the logged in userCan I detect which operating system or device the user logging in to the system is using?
-
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…
-
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 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…Scott_Turner_ 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i… -
Oracle Compatible Tamil FontSummary: I have a Letter development which need to compile with Tamil Font. For that I have using Using NirmalUI font and it works fine with word format and rtf format. …Dhajani Perera 12 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…
-
unpivot dataSummary: Move rows to columns Content (please ensure you mask any confidential information): I am looking to unpivot the data and move Input Value Name and Displayed Inp…Julia Kiszelewska1234 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 3 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM