Category 81
Discussion List
-
OTBI Report - Width column for development goalsSummary: Hello, Does anyone know how to fetch width column for development goals? Content (required): Version (include the version you are using, if applicable): Code Sn…Hazel De Castro 18 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to take Department head and Business Leader information from AOR?Summary: How to take Department head and Business Leader information from AOR? Content (required): Hi All, From which tables we can get Dept head and Business leader inf… -
Oracle FAW usage tracking not showing custom dashboard under custom folderSummary: Oracle FAW usage tracking not showing custom dashboard under custom folder Content (required): Hi All, Oracle FAW usage tracking not showing custom dashboard da…RDWIV3 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 53 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM -
Best subject area for pulling "Worker"."Work Email" into OTBI?Summary: Current Subject Area Used: Workforce Management - Worker Assignment Real Time Columns: "Worker"."Work Email" OR "Worker"."Employee Email Address" Content (requi…William_Johnson 48 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM -
Getting an error while running OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sidhartha Wadhwa 28 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific dateSummary: Hi Community! Hope to find you well. Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective em…Luca9797 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 328 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep…HarishVummidi 84 views 5 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
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 46 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 25 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 35 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 171 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 57 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 47 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 25 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 34 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 26 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 26 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 15 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 442 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 47 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM