Reports
Discussion List
-
How to SUM G_1, G_2 and G_3 in DATA_DS summary record for ETEXT template?Summary: we have 3 Records as G_1, G_2 and G_3 and need to show the total number of records in each of them have to be sum and display in DATA_DS in E-text fixed length …Vinay Prasad 17 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need to create a report on the bursting job history detailsHi, We have a job which triggers letter to employees. We need to create a report wo whom and all the letter is triggered from job history. Can you help me with the table…Shanmukhi 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to correctly write a BIP query in the OAC environmentSummary: Obtain the value list of launch parameters in a BIP report on the OAC environment Content (please ensure you mask any confidential information): Hi when I write…AM HRE 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is CRC32 function supported by Oracle fuion BISummary: Is CRC32 function supported by Oracle fuion BI Content (please ensure you mask any confidential information): Version (include the version you are using, if app…Ishtiaque AHmed 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.6K views 11 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
what is the table that can pull Available absence plan balance.i just want to pull absence plan and balance available for each person in system . Can someone ping me the table name,and is it possible to pull the balance for each abs…
-
Some of reports when we try to download the report we are getting processing errorSummary: HI Team, Some of reports when we try to download the report we are getting processing error . Export>Data>CSV or Excel Content (please ensure you mask any confi…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL query to find the Users that has role provisioned by an role mappingI'm trying to create a query that return the MAPPING_NAME from the PER_ROLE_MAPPINGS table and the USER_ID from the PER_USER_ROLES table to know which USER_ID is associa…Letícia Costa-Oracle 339 views 0 comments 0 points Started by Letícia Costa-Oracle Reporting and Analytics for HCM -
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'Summary: Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each em…Chelsea Holden 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 2 views 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I assigned the cost center code at the Person Costing level to an Assignment.Summary: I assigned the cost center code at the Person Costing level to an Assignment. I need to pull the OTBI report with the effective start date and End date. Can I k…
-
Get firstname lastname of user without person recordSummary: Requirement to get firstname, lastname of a user record which doesnt have a person record. since its ERP project, HCM part would not have been configured. PER_L…Jaeyshree K K 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Can anyone please share the best practice to create BIP Report template having more than 50 columnsSummary: Can anyone please share the best practice to create BIP Report having more than 50 columns I have a requirement to develop a BIP report having 54 columns and he…Kundan Kumar17 12 views 0 comments 0 points Started by Kundan Kumar17 Reporting and Analytics for HCM
-
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he…Janine Brown 394 views 10 comments 4 points Most recent by Murali Togaru Reporting and Analytics for HCM -
SQL query that returned the Leave approverSummary: Does anyone have a SQL query that return the leave approver? Content (please ensure you mask any confidential information): Version (include the version you are…Consultant Ian 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Oracle FDI initial configuration guideSummary: Oracle FDI initial configuration guide Content (please ensure you mask any confidential information): We are trying to setup a brand new FDI environment. Does e…Stefano_Mazzocca 148 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 45 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…Consultant Ian 22 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Are there subject areas for Connections Reporting?Summary: We'd like to report on activity and user participation in the Connections feature. Are there subject areas available for analysis reports? Content (required): W…Janine Brown 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report Perfomance issue when I apply the 7 countries in promptSummary: Hi All, We have OTBI report but in report Perfomance issue when I apply the 7 countries only but if i apply one country working fine in prompt . needs all the d…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
The journey report also tracks journeys that have not startedSummary: Hi experts, The journey report has tracked journeys that have not been started Hi experts, The journey report has tracked journeys that have not been started, i…Mihaela13 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please …
-
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture …
-
OTBI Report for Gross EarningSummary: Hi Can you please suggest if it is possible to create a report in OTBI that will provide gross earnings per element for a specific period? If it is possible, ca…
-
Oracle Report Rendering IssueHi All, When I try to run a report post mapping the fields using BI, the excel output is not generating. Getting the below issue.. But when I try to download the same in…Dhilipkumaar-Oracle 12 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM