BI Publisher
Discussion List
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
If Position or Department attributes getting changes how to extract all the employees assignedSummary: If Position or Department attributes getting changes how to extract all the employees assigned to that position/department in fusion hcm Content (please ensure …
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 21 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
How to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F tableHow to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F table select * from ANC_ABS_USAGE_RULES_F usage_rules where ABS_USAGE_RULE_ID =300000134481566 -- ABSENCE_TYPE_…Rama Krishna_Annam 12 views 1 comment 0 points Most recent by Carl Bequilla-Oracle 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)…
-
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…
-
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 767 views 4 comments 0 points Most recent by Yves_Guyon-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…
-
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
-
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… -
Looking for a Applicant Report < Oracle delivered report>Summary Looking for a Oracle out of box report output - To display all candidate responses to the application questions/fields including the signature with date and time…Prabhu Krishnamoorthy 19 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
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…
-
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…
-
We could see some extract sections from bakend for the task Profile Content Section AccessSummary: Hi Team, We are encountering an issue that there are some more sections in UI which we are unable to find functionally and technically where these extra section…
-
Purge older data more than 90 days in fnd_session_user_activityAfter activating FND_TRACK_USER_ACTIVITY profile option, is it possible to delete data older than 90 days in fnd_session_user_activity table
-
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO… -
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction…
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Does exist a BIP table/view with both Person Number and Employee Name?Summary: Building a valueset Content (please ensure you mask any confidential information): I need to create a value extracting person name, person number and person id.…Stefano_Mazzocca 12 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Query for Assignment Action and Action reasonSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…TestUser35 766 views 4 comments 0 points Most recent by L.G.M Manikanta Reporting and Analytics for HCM
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
Equivalent FUNCTION (per_bipntf_utility) for XPATH QuerySummary In Fusion Cloud Applications Update 21C, Oracle will deprecate a column in a table in the BIP Data Models (HRC_TXN_DATA.DATA_CACHE) and advised to replace XPATH …Sandeep19rm 1.4K views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM