Category 81
Discussion List
-
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 -
OTBI error - Error during query processingSummary: We have an OTBI report, pulling from 2 subject areas — Workforce Management - Work Relationship Real Time and Workforce Management - Person Real Time. Our HR us… -
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 340 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 -
How to disable Export -> Data in selected OTBI reports?Summary: Hello, Do you know how to disable Export -> Data in selected OTBI reports? When user clicks Export -> Formatted -> Excel, the report contains only columns that … -
HCM secured views - listHi, Can you please suggest where can I get all the list of secured views for HCM? Thanks in advance. Version (include the version you are using, if applicable): 24C -
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Vijay Kumar Reddy 2 views 1 comment 0 points Most recent by Harish Vummidi 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 3 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
-
Notifications are disappearing from bell icon under "Assigned To Me / All" Tabs but showing in BPMSummary: Notifications are disappearing from bell icon under "Assigned To Me / All" Tabs but showing in BPM worklist Content (required): Version (include the version you…pparamesh 136 views 3 comments 0 points Most recent by Walid Hamdy87 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 14 views 0 comments 0 points Started by Kundan Kumar17 Reporting and Analytics for HCM
-
Identifying the Main Legal Reporting Unit via BISummary: Identifying the Main Legal Reporting Unit via a SQL query. Content (required): Hello experts, We have multiple LRUs, and TRUs, setup for our implementation, and…
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…Dhilip Kumar P. 23 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
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 -
'Report Category' parameter usage within a custom flow patternSummary: 'Report Category' parameter usage within a custom flow pattern Content (please ensure you mask any confidential information): When building a Custom Flow Patter…Roderick Vails Jr 15 views 2 comments 0 points Most recent by Roderick Vails Jr Reporting and Analytics for HCM -
Need SQL query to fetch answers submitted by employee for questions configured using flex fieldSummary: Need SQL query to fetch answers submitted by employee for questions configured using configurable forms as follows. Hence i need SQL query to fetch Country of B…Kundan Kumar17 28 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Approach required for Benefits post election formulaSummary: Approach required for Benefits post election formula Content (please ensure you mask any confidential information): Requirement: If employee has enrolled in Emp…
-
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 -
How to use ASCII Values in OTBISummary: We are using this statement REPLACE(REPLACE("Document and Rating Details"."Rating Comments", CHAR(13), ''), CHAR(10), '') in BIP Report.How can i use the same s…Narendar-Oracle 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Grade Legislative Information not available in OTBISummary: Grade Legislative Information not available in OTBI Content (please ensure you mask any confidential information): Hi All, We want to pull out the Grade Legisla…Arther Bu 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to schedule an agent to run only if new / upcoming terminations are enteredSummary: Hello, I'm working on a push report for our security operations team who wants to be notified of upcoming terminations entered into the system. Unsure how to pr…CGardner01 13 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need an help for SQL querySummary: Content (please ensure you mask any confidential information): I want to extract report for Manage Legal Reporting Unit Registrations, however I have a SQL whic…Shilpa Dam 77 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 219 views 3 comments 11 points Most recent by Shyam Patel Reporting and Analytics for HCM -
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a… -
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear…