Category 81
Discussion List
-
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen…Cansel Karasoy 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
descriptive flexfield in job to be retrieved in query and joined with personSummary: descriptive flexfield in job to be retrieved in query and joined with person. Not able to join with person. Please share some references ffvs.flex_value_set_nam…Ganesh Purnima 22 views 4 comments 0 points Most recent by Ganesh Purnima Reporting and Analytics for HCM -
BIP Job History Retention PeriodSummary: BIP Job History Retention Period Content (required): I'm trying to give clear guidance to our customer, and I'm unable to find a consistent answer on this topic…CodySisson 136 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…William_Johnson 12 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
In Approval Notification Assignment number needs to be hidden as Part of workflowSummary: Hi Folks, In Approval Notification Assignment number needs to be hidden/removed as Part of workflow notification. Kindly help me with action plan to sort out th…Sowmiya Velusamy 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 23 views 8 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM
-
SQL to derive the Department names for all the personSummary: Hello we have a requirement where we need to bring the data of the department on the custom attributes created via application composer, however could not be ab…Krupesh Joshi 107 views 7 comments 0 points Most recent by Krupesh Joshi Reporting and Analytics for HCM
-
SQL query to extract UDT tableHello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a …Ioannis Adamou 5.8K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
United States Job Information Extensible Flexible Attribute not BI EnabledSummary: 2 of the attributes in United States Job Information Extensible Flexible are not BI Enabled. The flexfield is protected hence no changes can be made. Please see…
-
DOR Workflow Notification CustomizationSummary: DOR Workflow Notification Customization Content (required): Hi All, We get a requirement like, whenever employee added their bank details in DOR, one approval n…
-
How to fetch list of reports linked to a security role?Summary: Required list of all reports linked to a security role or list of all the reports with their permissions. Content (required): Subject areas or query through whi…Geet 32 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
A better way to convert HTML entities to special characters in a BI report.Summary: A better way to convert HTML entities to special characters in a BI report. Content (required): I'm looking for a way to convert HTML entities to special charac…S.Watanabe0110-Oracle 46 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Tables to get bursting output and delivery detailsSummary: Tables to get bursting output and delivery details Content (required): Hi All, Is it possible to get bursting delivery details? For example, which user the burs…Venkatesan 734 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
IS it possible to extract report on total number of self downloadable the report in employees folderSummary: HI Team, in this path Shared>Custom>employee -folder we placed the self downloadable letters so we need to extract report on total number of self downloadable. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor… -
PGPSummary: Hello, all the times we need to configure PGP the system need to receive the file send us the PGP. Now we are facing a new situation where we need to send to th…Nicola Petri 12 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
We were trying to create a separate Role to Update Folder And Report Permission in BI.Summary: We are trying to provide update folder permission and manage privilege access to a separate role. Even after creating the role and updated it in Manage privileg…Arjun Asoklal 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to find Organization goals Check Box in HCM tables.Summary: Dear , I want to know in oracle fusion which table I can find "Share this goal with your organization" .I was searched all goals tables but not found in table T…challa praveen 31 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
which table can store the bip report permissions detailsHi All, Could you please let me know ,which table can store the bip report permissions details. Thanks For Your Help!! RavindraRavindr-Oracle 44 views 3 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM
-
Payroll Element Entries - Context Sensitive Displayed Input Values - how to get on one rowSummary: Hello, I am using the SA Payroll Element Entries to try to get an employee allowance report. The issue I have is one of the fields 'Displayed Input Values' is c…Ian.Gooderham 19 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need SQL query to get absence leave requests which are in denied status.Summary: Hi Team, Can we have a SQL query to get absence leave requests which are in denied status. Thanks, Madhuri.Madhuri Brammadevara 359 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get the list of users who has downloaded a specific report in HCM Shared folderSummary: To get the list of users along with time, who has downloaded a report from HCM Folder Navigation : Shared folder --> Pick any report --> Open the report --> Exp…Siva Sankari N 43 views 3 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
query to pull Reporting information calculation cardSummary: query to pull Reporting information calculation card Content (required): Hi All, Greetings! We are looking for a query to pull Reporting information calculation…Parag Hiremath 3.3K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Sort breaking RCOUNT in logical SQL analysisHello, I have a fairly complex logical SQL report combining 5 subject areas. Overall, the information is displaying correctly with no issues. However, I have a need to R…Nick Dorfner 48 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…Valeriy Gorbunov 141 views 3 comments 0 points Most recent by Deepa Venkatesan Reporting and Analytics for HCM
-
How can we view an employees current department in performance document reporting?Summary: We have a requirement to include the Department Name and Organizational Hierarchy levels in analyses of Performance Document completions. However if an employee…Joshua Kidd 21 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 104 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Absence Accrual report in OTBISummary: Hi All, We have a requirement to develop OTBI Report for Absence Accruals. I couldn't able to get the accrual details. Does any one have catalog file or know ab…Sai Krishna Chelikani 31 views 8 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
BIP Report - Dynamic Password Protection For Excel OutputSummary: Is it possible to protect the BIP Report excel output file with Dynamic password? Content (required): Hi Team, I am looking for dynamic password protection for …Sudarshan Uppara 133 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Person Contact Relationship Marital StatusHello Oracle Community, I am trying to develop a demographic of dependent report by using OTBI subject area: Person Real Time. I am having a challenge to find marital st…Mohamed Affan 54 views 8 comments 0 points Most recent by Mohamed Affan Reporting and Analytics for HCM