Category 81
Discussion List
-
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 41 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to create a single report for the following fields in OTBI Or OBIEE.Summary: can we able to create a single report with this fields in OTBI Or OBIEE. Education details ( highest one ), Previous Experience ( last worked ), probation statu…Jebarsan Thangam John Durai Raj 21 views 4 comments 0 points Most recent by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM
-
Leavers within last three monthsHi, Can someone help me with query to get the list of leavers within the last three months ThanksMohammed Rafi 31 views 3 comments 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
DOR approval report gives cartesian product/wrong dataSummary: I am trying to fetch approver details of pending/approved document of records entries made by employee using attached query but it is always giving me the carte…
-
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 146 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit…
-
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Updating RTF for Element Register ReportSummary: There is an error on the Element Result Report that produces split lines for Person Number. I need to update the rtf to correct this. Content (required): When s… -
How to Display DFF Attribute Date value to the Alert TemplateSummary: We have document of record DFF where the value is stored in table HR_DOCUMENTS_OF_RECORD column DEI_ATTRIBUTE_DATE2 , and we dont know how to display this value…
-
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 53 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Work Schedule Report - Getting Hours On DateSummary: As per the screenshot attached. We have a requirement to fetch the Hours On Date. Example. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-7 (Ne…
-
Is there any way to fetch real updated absence records via BIP Report?Summary: - Content (required): Background: Absence Management Module We currently need to capture the real updated absence records, distinguish which records are newly c…
-
HowThere is aCansel Karasoy 41 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
we have OTBI Report skills and certfications but it showing unparallely ?Summary: HI Team, We have report facing this is how can sorted Content (required): Version (include the version you are using, if applicable): How it looks in the report…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Do we get any performance issues by enabling BIP Audit reportsSummary: Do we get any performance issues while running any BIP reports after enabling BIP Audit reports access. Any suggestions please? Content (required): Version (inc…GajavalliKoteswararao 31 views 2 comments 1 point Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Tree Name Criteria Dropping out International & Non-EmployeesSummary: Hi - I am creating a report with a number of different fields pulling from the following subject areas: When I have all of my criteria EXCEPT for the tree name,…Kyle Norris 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Prepare Review Content example reportsSummary: Prepare Review Content Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to better engage our e…William_Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way in OTBI not BIP to combine a "Security" with a "Workforce Management" Subject AreaSummary: Trying to combine Security Subject Area to a WFM Subject Area so we can see role on a user and which department they are in Content (required): There is an inte…
-
Termination Date for ManagersSummary: We are looking to create a report with employees with a manager who has a future termination date. How would I include the managers termination date? Content (r…Jo Black 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…Saher 431 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How should I write multiple data returned from a column separated by commas next to each other?Hi, I actually have a pretty simple little query. More than one data is returning from this column and I want to write it on the same line separated by commas. SELECT YY…Cansel Karasoy 41 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Performance Document Ratings - Dashboard - Prompt QuestionSummary: OTBI - can a prompt be used to define which column to be used in a filter Content (required): I'm trying to generate a dashboard prompt which will define which …David McLellan 41 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Release Update Issue 23b: Error in custom reportsSummary: 'ORA-32036: the unsupported case for inlining of query name in WITH clause' Content (required): Hi Everyone, I'm facing an error on reporting level after the Re…
-
Report Delivery - Agent Completed with WarningsSummary: We currently have a report that is scheduled to run daily at around 7am. There are times when the report doesn't send, and it shows the following message below …Alejandro Macias 72 views 1 comment 6 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BI Publisher security on expatriatesSummary: BI Publisher using secured view shows records outside scope of user's AOR who is running the report Content (required): Hello, We have a BI Publisher report on …
-
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…ShawShankk 52 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Date of Birth less than 16 yearsSummary: Employees with Date of Birth less than 16 years. Content (required): I need to create a list of employees with a Date of Birth recorded that would make their ag…
-
Remove additional links from the Certificate of completionSummary: When viewing a certificate of completion, does OTBI provide flexibility to Remove the following links: · Edit · Refresh · Export · Add to Briefing Book · Email …
-
Job detail HistoryHi Team, I am looking for table or Subject area to pull the Job detail history. The Navigation to view history details is given below: My Client groups->Workforce struct…Praveen_Chouhan 41 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM