Category 81
Discussion List
-
where to add parameter effective date conditions to OTBIHi All, Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date para… -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 3.6K views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en… -
USOnline Payslip Report CustomisationHi Team, We are looking for detailed steps for customising the USOnline Payslip report, with the output format in XML. Report output should be delivered to FTP. Please s…Swapnil Kashid 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Date between effective start date and effective end dateI am trying to create an otbi report on element entries historical subject area. I have to create a date filter condition in such a way so that it will ask a date from t…Neelotpal01 13 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…Patrick Turcotte 95 views 9 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Can we report on the number of job requisitions raised by "use" type (template, position etc)Summary: We are looking to establish the behaviour of users and which way they raise job requisitions in Oracle Recruiting. Is it possible to report on how many requisit…Craig Hennessy 24 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How can Canadian French characters be displayed correctly when using ANSI encoding?We have a requirement to send a demographic file to a Canadian RRSP vendor using ANSI encoding that supports ASCII characters. However, when we use encodings such as ASC… -
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is… -
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …Emily Wilde 209 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Bip publisher output doesn't clear cache as old message isnt clearedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a …Michael_Burgett 2 views 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM -
How to identify edited DOR in BI reportsHow to identify edited DOR in BI reports?Nivya Mathire 21 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 276 views 9 comments 0 points Most recent by Subbu Santra Reporting and Analytics for HCM -
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID… -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…JMLMIII 25 views 10 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
default time zone when scheduling BI reportsSummary: is it possible to set a default time zone when setting the date on a scheduled BI report? our default time zone is London but when we open the calendar it defau… -
how to assign a specific role to multiple usersSummary: We have a specific role that hold access to new features, however, when we go live this role has to be assigned to the respective users to enable/show this. I w… -
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s… -
SQL tables to fetch Questionnaire data from performance goal feedbackThis the screen from where i want Questionnaire dataTanu.T.Sharma-Oracle 11 views 1 comment 0 points Most recent by InaNotra-Oracle Performance Management -
Which table contains 'P45 Filed date' from oracle hcm payroll moduleProvide exact table name and column name to fetch ''P45 Filed date'' field. Field is from Calculation cards→statutory deductions→PAYE. Need this in data model and report. -
Is there other table store info about qualified entitlement planHi Teams, table anc_per_abs_qual_entl is holding the data when user records an absence, do we have any other table or view stores the entitlement information when user n… -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 64 views 8 comments 0 points Most recent by ganesh_b-Oracle Reporting and Analytics for HCM -
OTBI delimit data from 1 column into multiple columnsSummary: We have a report requirement where we want to delimit output from 1 column into multiple columns based on '/' delimiter Content (please ensure you mask any conf… -
Requesting details on the Fusion Tables used to extract “Tax Rate” from Values Defined by CriteriaDetails: We are creating an outbound custom BI Report to send Payroll Balance and Calculation Card details to Fidelity. One of the requirements is to extract Tax Rate of… -
The filter should show just the Years: 2021 2022 2023 2024Hi, this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Fe…SenthilRaja 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI present last value of a column - ReportHi, we need to control when a employee change a department(from any department to any department) and this need to be done in a OTBI report to control a initiative. ive …Lucas B Maciel 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample Report: Workforce Compensation Market CompositesSummary: Sample report showing how you can report on market composites within Compensation - Workforce Compensation Real Time Content (please ensure you mask any confide…Gail Langendorf-Oracle 6 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM