Sample Reports
Discussion List
-
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…Ravindr-Oracle 399 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 40 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Questionnaire text column how to set the questions inproper to order ?Summary: Hi Team, We were developed new report by using Check list real time subject area to get onbaording Questionnaire text of employees but issue questions are inpro…AjayKumar Maddipati 32 views 12 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 53 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 2 views 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
there is a way to check access for the report who have ?Summary: Hi Team, we have placed the BI reports in shared folder and some of have given the access the reports based on request but now we need to track the report who h…AjayKumar Maddipati 32 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 22 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 45 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…Tisha Negrete 1 view 2 comments 0 points Most recent by Tisha Negrete Reporting and Analytics for HCM
-
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 14 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM
-
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 31 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Managing Bounce Back EmailsHi everyone, We are looking for ways to manage email bounce backs when assigning Surveys to a large group of employees. The purpose of this requirement will support the …
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 412 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area …
-
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 41 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …
-
Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 42 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 2 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 32 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 173 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Different infolets for employee and managerHi, Can we enable different infolets for Employee and Line manager ? Regards, NivyaNivya Mathire 23 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM