Category 81
Discussion List
-
candidate email address in OTBISummary: How do we fetch the candidate email ID in OTBI from recruitment real time subject area as per the email ID present in the candidate personal information page. I…Debkanya 44 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
IN BI Report two parameters From Date to TO Date but need to change TO Date as sysdateSummary: Hi Team, I have changed parameter Todate as SysDate but it correct or not I'm not sure, any one could you please check this is correct data or not on below quer…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Mail Bursting Didnt WorkedHi Everyone, I Just Checked the Bursting SQL, My Data Model but couldnt find the reason. In transaction screen I can see delivered with success . But at my mail I can't …Kaan Can Calkan 12 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
time to fill OTBI report in ORCSummary: Does anybody have time to fill OTBI report or dashboard build in ORC? Content (please ensure you mask any confidential information): Version (include the versio…Avinash.Potti 12 views 2 comments 0 points Most recent by Avinash.Potti Reporting and Analytics for HCM -
Fetching the answer from multiple choice questions in OTBISummary: Hi, I have an OTBI report for Learning Assessments, the field "Answer Text" only appears in the report if the question is an open-ended question. Is it possible…Vasco 63 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Add Custom Text to Workflow NotificationSummary: I would like to be able to add custom text to the workflow notifications that would show up conditionally - only when the approve/reject links are shown on the …Kyle Norris 44 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 44 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Error Message - The ContactRelationship SDO, ContactType attribute value is required.Summary: I get this error message when I try to load Contact data using HDL - The ContactRelationship SDO, ContactType attribute value is required. You must enter a valu…
-
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…Priyabrata Prusty 75 views 3 comments 0 points Most recent by Priyabrata Prusty Reporting and Analytics for HCM
-
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…Ramy Atia 33 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …SauluriR 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How does a matrix manager see the indirect reports for the person set up as matrixed to themSummary: I have set an employee up as having a matrix manager. I would expect the matrix manager to see this employee along with his/her direct/indirect reports in a hie…JoeNalbach 32 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…MadhuLekkala 57 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report - Direct and Indirect ReportsSummary: Does anyone know how to fetch direct and indirect reports of manager using OTBI? Content (required): Hello, Does anyone know how to fetch direct and indirect re…Hazel De Castro 93 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Could someone please inform me about the table where I can find information on deleted user roles?Summary: Could someone please inform me about the table where I can find information on deleted user roles? In the per_user_roles table, records are permanently removed …
-
Line Manager Dashboard Direct/Indirect ReportingSummary: Is there a way to filter the line manager dashboard analysis by direct/indirect reports? Let's say a Manager has 10 direct reports and 30 indirect reports, is t…Vasco 246 views 3 comments 6 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i…Vis Perera 57 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Ability to report on auto provisioning rules?Summary: Is there a way to report on all the auto provision rules we have set up within the Manage HCM Role Provisioning Rules task? Or some way to report on all securit…Karlie Backman 104 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Report Path for Audit Reports PageSummary: Could someone please share the report path for the page below? I intend to generate a BIP report to monitor user role deletions and additions. Content (please e…TestUser35 12 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance…Valerio Curzi 649 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to Organize the BI Publisher reports and create Library and definitions inside HCM?We implemented Oracle HCM back in 2019, and since then we created a lot of BI Publisher reports across the modules. Those reports are very useful, however, the report na…Raed Ibrahim 12 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Automating HDL Worker loading via BIP ReportWhat is the process to Automating HDL Worker loading via BIP ReportVinay Prasad 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 137 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
AbcdAbcdShyam Rajbhar 32 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 402 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…ShawShankk 115 views 11 comments 1 point Most recent by Ankam Vasantha Reporting and Analytics for HCM
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl…Hiba Ghoualmia 206 views 7 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
Condtional formating not working for standard fieldsSummary: Adding a conditional formating criteria does not work on standard fields but works fine for flex fields Content (please ensure you mask any confidential informa… -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject areaSummary: Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area Content (required): We have payroll balance data for an employ…