Category 81
Discussion List
-
Query that link Legal Employer to Reporting EstablishmentSummary: Hello! Good morning/afternoon/evening Customer Connect! I am in a need of a query that can list all the Reporting Establishment for a Legal Employer. Does anyon…Matheus Roberto 25 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - … -
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 13 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Direct and indirect reports in dashboard promptHi There, We have designed a custom dashboard with is using the subject area Workforce Management - Checklist Real Time. We have a requirement to display direct and indi…MadanMohan 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Token for Rejection NotificationSummary: Does anyone know where/how to find out the definition of a token? For example, we are trying to figure out what “${CEConfigurationSiteName}” means. Also I see t…Antonio Washington 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 70 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to add Analytics section to homepageWe've been trying to embed some infolets on our Oracle Cloud homepage, however it appears that most users (at least it seems that way based on Cloud Connect posts, YouTu… -
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Looking for Entity Relationship Diagrams (ERD) for SCM modules (Inventory, Order Management, PIM)Summary: Looking for Entity Relationship Diagrams (ERD) for SCM modules (Inventory, Order Management, PIM) Content (please ensure you mask any confidential information):… -
R23 HCM OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 HCM OTBI subject areas to database tables mapping spreadsheets. I am looking for the educational major and name fields in the Skills an…Sharron L 179 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 65 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Trouble converting Double to Decimal/NumericSummary: Attempting to create a BI report which creates a file for sending via SFTP to a 3rd party. When creating the Data Model, I'm able to use OBIEE in the SQL query … -
Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 33 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following … -
How should I define all parameters as multiple selection in sql report?Parameters are defined in this way in the SQL report I prepared.In this way, I can make more than one selection in the location with the parameters.But for example, when…Cansel Karasoy 45 views 12 comments 0 points Most recent by Stephan Steup Reporting and Analytics for HCM -
Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 16 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Specialization Title and Number in OTBI Learning ModuleHi Can you please tell me where can i can able to get the Specialization Title and Specialization Number in the Learning Module of OTBI (Workforce Learning - Learning Re…Shivam_123 83 views 7 comments 0 points Most recent by David Bean - BW Reporting and Analytics for HCM
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c…Hi.itsa.me 87 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 102 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 42 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Duplicate element entry report with entry detailsSummary: I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on …Vibha Pandey - Oracle 32 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
OTBI Hourly Rate calculation for employees on monthly pay cycleSummary: I am modifying an existing report on employee's salary. The organization has bi-weekly and monthly pay cycles. When calculating the hourly rate some monthly emp…
-
Payroll Flow PatternSummary: Does anyone have a sql they have used to get a dump of all payroll flow patterns and the corresponding tasks and following task in a pod? Including Created By, …Jen Barthel 11 views 2 comments 0 points Most recent by Venkat Balasubramanian-Oracle Payroll and Global Payroll Interface (GPI)
-
Dhajani Perera 2 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Rating data is displayed in different rowsSummary: For the Perfomance Document Section I want to have two cases illustrated in two different columns: I wrote a Case-statement that if Perfomance Document Section …
-
Need a Sample SQL to fetch Benefits Enrollment Data using a Batch Name from HSDLSummary: I have loaded the Benefits Enrollment using HSDL where we provide Batch Name. My requirement is that using the Batch Name as a parameter, I need to fetch the lo…Sujeeth Chinta 770 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM -
How To Add A New Column With Custom Date FieldSummary: I have an OTBI report where I need to add a column (see expected date column below) that when there is a Termination Date it shows the Termination Date BUT when…
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM