Category 81
Discussion List
-
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 25 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
In which table does the Candidate Job Application Fields are storedSummary: Hi Everyone I have loaded the Candidate Job Application into the system using HDL. So I'm trying to fetch those loaded fields using SQL for verification. Conten…Sujeeth Chinta 651 views 4 comments 0 points Most recent by Emerson Oliveira Reporting and Analytics for HCM
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)… -
How do I return vacation request data in the transaction console, which tables can I use?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single recordSummary: Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single record Content (please ensure you mask any confidential information): Hi, We understoo… -
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro… -
How to provide the gap between the 2 bars in bar graphSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which table contains data for Candidate's Job Application Id. I need SQL for BIP report .Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …DHILNA P 1 view 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
if else condition in rtf template is not workingi tried using these conditions in rtf but its not workingminati_behera-Oracle 776 views 4 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 21 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 22 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Redwood: Can we make attachment mandatory in Refer Candidate PageSummary: Redwood: Can we make attachment mandatory in Refer Candidate Page Content (please ensure you mask any confidential information): We are unable to make Attachmen…Twinkle Dudani 11 views 2 comments 0 points Most recent by Saurabh Sonkusare-Oracle Reporting and Analytics for HCM -
Is there a way to set a section to collapsed state by default on OTBI dashboard page?Summary: Need solution to set section collapsed on load of dashboard page. I understand there is an option to save the customization for each user but it is not viable t…Shreya Agarwal-Oracle 5 views 0 comments 0 points Started by Shreya Agarwal-Oracle Reporting and Analytics for HCM -
Query to pull error details of failed terminations from transaction consoleSummary: Query to pull error details of failed terminations from transaction console Content (required): We need a query to pull error details of failed terminations fro… -
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis… -
Transaction Console -> Error Description and Error Resolution (hrc_txn_error)Summary: I have a requirement to get the data related to the transaction console when the transaction fails I need to get the error description and error resolution as d… -
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor… -
Tables lock or obsolete statisticsSummary: Hello experts! It's possibile to verify if it's present a lock on a table o the statistics are obsolete? We have a BI query of a scheduled job that times out ra…Gian Luca Triglia 1 view 1 comment 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration -
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref…CCannadayCTR 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…DanSut 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Facing " There is no data to process" in BIP reportSummary: Facing the error " [INSTANCE_ID=bip.bi_server2] oracle.xdo.servlet.scheduler.ProcessingException: There is no data to process" in BIP report and there is bursti… -
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi… -
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o… -
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre… -
Resource mapping Report: feasibility to append the Job Requisition URL with external Site detailsIs there any feasibility to append the Job Requisition URL with the external site name details for tracking the candidate flow from the source website.(E.G; LinkedIn, In…Suneetha Narisipuram 21 views 2 comments 0 points Most recent by Pandey Roma Reporting and Analytics for HCM -
Page Composer Read Only FailureSummary: Attempting to mark the "Posting Description" field to "Read Only" using the following EL expression #{securityContext.userInRole['ST_HR_REC_ADMIN_SUPER_USER_TA_…Aashish Choyal 19 views 2 comments 0 points Most recent by Aashish Choyal Reporting and Analytics for HCM -
Select performance goal seeded report customization in not working in Production.Summary: Select performance goal seeded report customization in not working in Production . where as working in TEST pod. Below are the steps followed to customize the r… -
Could not find the table link between Rating Model and Profile section nameSummary: We could not find the table link between Rating Model and Profile section name HRT_PROFILE_TYP_SECTIONS_VL - section names are available in this table HRT_RATIN…