Category 81
Discussion List
-
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 35 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 475 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 11 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 https://us.v-cdn.net/60…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.7K 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 11 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
-
How can I display user chosen from and to dates in OTBI?Is there way to show the dates a user has selected in the output of the report? Date run can be shown in the title, but I want the user to enter a from and to date and t…
-
In which table has the information of Mail Stop in Legal Reporting Unit AddressesSummary: Hi, In which table has the information of "Mail Stop" in Legal Reporting Unit Addresses under the setup Manage Legal Reporting Unit. We checked in below tables …
-
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…Elavarasan S 13 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM
-
Where can I find HCM Extract user entity to database lineage mapping?Where can I find HCM Extract user entity to database lineage mapping?
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 122 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont…Jagdish Varadraj 4 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_FSummary: Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_F Content (please ensure you mask any confidential information): I am extracting data fro…
-
My Team Activity Center Org HierarchySummary: Redwood. 25A. Test Pod. When logged in as a Line Manager and accessing My Team Activity Center, the manager will click on the Org Hierarchy. When moving up the …
-
Calculation Card Component - Provincial Tax CardSummary: Column / Table where the Location held on the Provincial Tax Card is stored. Content (required): Hello experts, We've been trying to report on the Calculation C…
-
Missing folder in BI Catalog under Custom/Human Capital Management - Reports and AnalyticsHi Team, One of the folder "Talent Management" is missing under /Shared/Custom/Human Capital Management/ and we could not replicate what happened to the folder and when?…
-
Standard VS Custom ReportsSummary: Hi Everyone, Content (please ensure you mask any confidential information): How to check if reports are standard reports vs custom report? I need a table that s…Srushti Dhote 33 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…Karlie Backman 164 views 7 comments 1 point Most recent by Felix_fei Reporting and Analytics for HCM