Category 81
Discussion List
-
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 5 views 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM -
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f…
-
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…Niharika123 233 views 17 comments 0 points Most recent by Nathan CCC 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.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9.8K views 128 comments 35 points Most recent by Kaushik R-Oracle Payroll and Global Payroll Interface (GPI) -
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers…Abdelhafid Rhofir 183 views 13 comments 0 points Most recent by Deepak Veetil Reporting and Analytics for HCM
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…
-
Participant Feedback Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi…
-
OTBI agent More Details - success?Some OTBI Agents More Details read: "Last Run 09/12/2025 8:00 AM GMT+00:00 | Agent Successful | Next Run 10/12/2025 8:00 AM GMT+00:00". Other agent More Details read "La…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 1.9K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM
-
Buyer Assignment Rules OTBI ReportGood Day Experts, Is there a way to create an OTBI report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Applicatio…
-
Multiple Absence Actions Sharing the Same Object IDThere was an error rendering this rich post.
-
can we add element entry section under hire an employee, change assignment page in redwood VBSSummary: Hi , Can we add element entry selection into Hire an employee, change assignment, Convert Pending Worker ,Local and Global Transfer, Promote and Transfer pages …KanchamMaheswar 11 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management
-
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j…Sayali Pawar-Oracle 765 views 7 comments 1 point Most recent by Subhojit31 Reporting and Analytics for HCM
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
RTF Template| Bar Graph | Error: Invalid DataSummary: Hi all, I am working on the RTF template where requirement is to show the data in the bar graph format and it is giving me error like invalid data. For testing …
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.2K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
BI tables for standard compensation plan columns regarding salarySummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables store the following standard compensation plan column fields? New …Valerio Curzi 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
We have requirement to create goal report contain all information like measurement and tasksSummary: Any Help regarding creating goal report to have goal info and measurement and tasks Content (please ensure you mask any confidential information): Version (incl…Tareq Yousef 16 views 6 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Approach to get historical login details for a userSummary: Hi All - The ASE_USER_LOGIN_INFO table only gives me the latest sign-out details for a user? How can I get historical login/logout data? I also tried to use Fus…
-
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Need SQL query/table to get Progress note in goal detailsSummary: In goal details, there is option to enter progress note. Need table name or sql query to get progress note. Thanks Content (please ensure you mask any confident…Ranjith1166 21 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c… -
OTBI report export is not pulling all dataSummary: Whatever the data showing in the report is not showing in the exported data. It's only around 5,000 records. Content (please ensure you mask any confidential in…
-
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …