Category 81
Discussion List
-
I am looking for a filter to add to a date to show values in the current financial yearSummary: I have an OTBI analysis for terminated workers and I am wanting only those terminated in the current financial year to return in a filter. how to I write and ap…Sharon Ferguson 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Max Effective Date Record on a Combined Subject Area Report Or Null ValueSummary: We are trying to bring back one row for Performance Task Completion Date, either the Null row or the latest completion date. Using "- Performance Task Status De…Kristin Montoya TWU 2 views 2 comments 0 points Most recent by Gretch Atienza Reporting and Analytics for HCM -
Since redwood update in hcm the URL for reports are now not able to be shared as these get 404 errorSummary: Redwood has been updated into our production enviroment. The URL for the BIP reports, now no longer is able to be copied, shared as a link, and opened. Content … -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a…George Chernikov 37 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
In which table has the information Manage Reporting EstablishmentsSummary: Hi Team, Need a table or sql query to get the information Manage Reporting Establishments as in below marked screenshot Content (please ensure you mask any conf…Opkey PA 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.2K views 2 comments 0 points Most recent by Micha---- Reporting and Analytics for HCM -
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload…Martina Iovino-Oracle 23 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do …Parag Hiremath 22 views 3 comments 0 points Most recent by MitG-Oracle Reporting and Analytics for HCM -
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme…Marie Joyce Wynona Marzan 20 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an… -
Display Value for Time Entry Layout Component fieldSummary: Display Value for Time Entry Layout Component field Content (please ensure you mask any confidential information): Hello, I have a time entry layout component o…Irina Erhan 125 views 7 comments 0 points Most recent by Rob Williams Reporting and Analytics for HCM -
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …Peter Downer 11 views 4 comments 0 points Most recent by Peter Downer Reporting and Analytics for HCM -
Embedded Reports not loading 1st time opening the screensSummary: Embedded Reports not loading 1st time opening the screens Content (required): Hello We have 2 embedded reports in the absence screens which are not loading on t…Helen Thomas 31 views 5 comments 0 points Most recent by David Chang R. Reporting and Analytics for HCM -
Employee/Person Addresses not visible in per_addresses_f tableSummary: We have loaded Employee/Person Home Addresses data using HCM HDL file and the load was successful. I can see the data in the table per_person_addr_usages_f but …Pankaj Pandey 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to have a common parameter for ESS Job SetSummary: We have 8 Custom ESS Jobs in HCM, all use the same date parameter. We have placed them all into an ESS Job Set to execute in Parallel, but need a method to wher… -
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac…Valerio Curzi 382 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
Is there a way to add field of Responsibilities under Work Experience when printing the candidate?Is there a way to add the field of Responsibilities under Work Experience when printing the candidate details?Shaina_Manalo 12 views 1 comment 0 points Most recent by Jessica Reilly-Oracle Recruiting, Opportunity Marketplace -
organization seniority date on multiple contractsSummary: How can I report on the Org Seniority Date when person has more than 1 contract Content (please ensure you mask any confidential information): Hello Has anyone … -
Unable to bring max effective date record in a report while using an EIT flex fieldSummary: In a report with 2 subject areas, columns are not working properly. Subject Areas used: Worker Assignment Real time and Person Real time Created a report with s…Elavarasan S 12 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) … -
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component… -
Can i get a list of reports from Catalog in OTBI?Summary A client has requested a report showing names and location of all reports available in OTBI (including custom reports). How can i get such a report? Content (ple… -
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that… -
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def… -
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 2.5K views 10 comments 1 point Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext… -
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a… -
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant…Lucas B Maciel 12 views 3 comments 0 points Most recent by Nidhi Prasad2 Reporting and Analytics for HCM -
Error changing ReportsWhen trying to change the report from the custom folder, the following error appears:Matheus Vitorelli 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Employee Connection - Colour bar represents assignment typeSummary: My Organization chart page displays yellow bar for contingent workers and blue bar for employee assignments type. I do not see this colour bar feature on connec…ArunSolanki18 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM