BI Publisher
Discussion List
-
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 770 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 794 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 -
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 3 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Query to fetch structural details of the admin pages and the EL Components used within themSummary: Is there any way or Query to fetch structural details of the admin pages and the EL Components used within them Content (please ensure you mask any confidential…Swati Rana2805 11 views 2 comments 0 points Most recent by Swati Rana2805 Reporting and Analytics for HCM
-
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…Ashish Chawla-277800 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to center align a custom bip notification with an rtf templateHello, Can anyone tell if there is a possible solution to center align a custom bip notification in the user's end. We are using an RTF template. While viewing it on the…
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 224 views 4 comments 2 points Most recent by Atta Oduro Reporting and Analytics for HCM