Reports
Discussion List
-
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…Sourabh Patial 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN…Nirmal Ignatius 13 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):Aishwarya Somvanshi 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
FTE and Headcount no longer in per_all_assignments_m tableSummary: Is there a reason why FTE and Headcount no longer in per_all_assignments_m table? Content (please ensure you mask any confidential information): Version (includ…Consultant Ian 21 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)Summary: Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requi…
-
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…Jacqueline GRANDIN 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'…Karen Florig 104 views 4 comments 0 points Most recent by Durga Prasad Tavva Reporting and Analytics for HCM -
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊Michael Angelo Lucena 21 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …
-
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi…
-
OTL - Workforce Management - Reported Time Cards Real Time subject area missing entriesSummary: The subject area Workforce Management - Reported Time Cards Real Time does not return accurate time entries when we try to query the custom attributes from the …
-
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo… -
Multiple Proficiency Level records per Competency HCMSummary: We have multiple Proficiency Level rows per Competency. It is not clear which proficiency level in the report is the correct one. We expect the report to show o…
-
How can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…Shanmukhi 84 views 2 comments 0 points Most recent by Vaishnavi Katiyar Reporting and Analytics for HCM
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 34 views 4 comments 0 points Most recent by Nimisha Nirmal QC Reporting and Analytics for HCM
-
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…
-
A HR rep user should access all active emp of USA, except Partner and Managing Partner jobs in OTBIPrevious access rights: all employees in USA New access rights to be given: all employees in USA, except Partner and Managing Partner jobs The active employees report is…Shouvika 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info… -
Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?Gowri Perumal 22 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 110 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our…Clare Murtagh - new 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…Monique Dias 123 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…Helen Thomas 19 views 4 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM