Reports
Discussion List
-
Error opening journey reportHi experts, When I try to open the journey report, this error appears. It happens every now and then, not all the time. Is there a way to solve this problem? Thank you, … -
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
we have given the row num in select statemnt but we need row count also ?Summary: Hi we have given the row num in select statemnt but we need row count also ? need row count=2 ? Content (please ensure you mask any confidential information): V…AjayKumar Maddipati 11 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 51 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI agents and P2THello! We are setting up our first OTBI agent to send out daily notifications and wondering what will happen to the agent in test environments. Will it be automatically … -
We have ORC Offers Transactions Report but need to add country column for below query ?Summary: Hi Team, We have ORC Offers Transactions Report but need to add country column for ? Content (please ensure you mask any confidential information): select a.OBJ…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This …Erica Williams 61 views 11 comments 1 point Most recent by Erica Williams Reporting and Analytics for HCM -
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 41 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Report/Dashboard about Performance ModuleContent Hi Guys, Does someone know where could we find Performance Reports or Dashboards standard? I hope in your answer, Best Regards, GiuseppeGiuseppe Iacono 68 views 5 comments 0 points Most recent by Dileep Reddy Vattimi Reporting and Analytics for HCM -
Hire Report - Two subject area report erroring with two measuresSummary: Hello, we are building a hire report using the Workforce Management - Worker Assignment Event subject area and we only need one field from the Workforce Managem…CCannadayCTR 11 views 2 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
How do I query Estimated Time To Hire from ORC using BI Publisher?Summary: I need to query data on Estimated Time To Hire for existing requisitions. Any information is greatly appreciated. Content (please ensure you mask any confidenti…
-
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …
-
Count Distinct by Two AttributesSummary I am not able to get distinct count by management level and genderContent Hello - I'm creating a simple analysis to count the number of employees by a grouped ma…User_2025-02-11-03-07-51-707 36 views 3 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…Opkey PA 184 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We need termination reson column but how to link with any table ?Summary: We need termination reson column but how to link with any table ? PER_ACTION_REASONS_TL Thankss, Ajay Content (please ensure you mask any confidential informati…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
In BIP template how can i get columns printed by and printed on ?Summary: Hi Team, we have BIP template how can i get columns printed by and printed on ? Thanks, Ajay Content (please ensure you mask any confidential information): Vers…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to query for encumbrance amount on an Open status Purchase OrderSummary: We currently have PO139487 that has a status = Open. We are trying to query the tables to identify the encumbrance amount of $ 8,773 (35,700.00 - 26,927.00) usi… -
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Creating Recruiting Support ReportsSummary: We need to create support reports for our mapping operations in the recruiting module. Specifically, we need to extract the following data: The list of Candidat…Giuseppe Iacono 11 views 2 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
How to remove blank line from RTF template report output?There is a BI report(RTF Template) with the following data as output: Name: DOB: Gender: DOJ: The requirement is to hide DOB(both text and the value) for a certain c… -
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We need citizenship column in BIP querySummary: Hi Team, We unable to find the citizenship column and we checked on per_citizenships table also . any one help me on ? Thanks, Ajay Content (please ensure you m…AjayKumar Maddipati 52 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one rowHI Team, when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row. how to…AjayKumar Maddipati 34 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Supplier contracts OTBI/SQL reportSummary: Is there any standard Supplier contract OTBI/SQL report available? Content (please ensure you mask any confidential information): Version (include the version y…NASYED 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
FTP server setup for BIP - Save or Test connection not availableHi Team, I am trying to add FTP server setup. I can enter all the details but I do not see Save or Test connection. I should be a complete administrator, but seems I hav…SM_EP 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
FAW connection - Is support Oauth for Salesforce and PeopleSoft & SFTP supports - PGP encryptionFAW connection - It supports Oauth for Salesforce and PeopleSoft & SFTP supports - PGP encryption: Please confirm it is possible.Saravanan Pandian 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
HCM Table to fetch Saved SearchHello, I'd like to create a BI report to see whether employees have created their own Saved Searches on Document Record page. Do you know which HCM table store this piec…
-
Where can I find the BIP tables storing the "Personal Brand Administration" related details?Summary: Hello, We have a requirement to fetch Personal Brand Administration related data, specifically the information under the "Skill Settings" section - "Skill Data …Prashanth Sangram-Oracle 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
Can we recall the triggered emails from scheduled reports via the system ?Hi All, Is there any possible ways to recall the triggered emails from scheduled reports via the system ? Regards, JebaJebarsan Thangam John Durai Raj 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
User Entity to extract Absence plan enrollments of an employeeSummary: I have a requirement to extract all absence plan enrollments of an employee , using HCM Extract. I am looking for a User Entity which can suffice this need. The…Pankaj_Singh 151 views 2 comments 1 point Most recent by Pankaj_Singh Reporting and Analytics for HCM