Category 81
Discussion List
-
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 95 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ… -
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 82 views 4 comments 2 points Most recent by Lisa Elaine Vega Reporting and Analytics for HCM
-
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 7 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …Alyssa T. 4 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 12 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
Custom Criteria Person Security ProfileSummary: Hi all I've created a custom role and created a Person Security Profile which is secured by Area Of Responsibility, and the scope of responsibility is Organizat…Nicolas-Vahman 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 6 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 10 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to perform conditional formatting on Excel template when old value is not equal to newSummary: I have built a Changes only extract to get the employee Demographic information and getting data in Excel format in separate sheets. First sheet contains new hi…Sreenivasulu Kaveti 12 views 0 comments 0 points Started by Sreenivasulu Kaveti Reporting and Analytics for HCM
-
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom…
-
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 12 views 0 comments 0 points Started by Joliver Caangay Reporting and Analytics for HCM
-
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…Rohit Kumar Singh 453 views 7 comments 1 point Most recent by SirilG Reporting and Analytics for HCM
-
Is anyone else getting a geospatially error in their Payroll Validation Report?Summary: In the Payroll Validation report, we are getting this error for all employees in the first pay cycle since going live on 25C: "The address couldn't be validated…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 3 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…
-
Required table for Quick move action for Candidate Selection Process Configuration in ORCSummary: Required a table or SQL query where the information of Quick move action stored for the HCM-ORC setup Candidate Selection Process Configuration. Attached screen…
-
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Not able to retrieve data from Security - Roles and Privileges Real Time subject area.We are not able to retrieve data from Security - Roles and Privileges Real Time subject area. We are trying to fetch columns from the folder Function Security Policy, Da… -
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …
-
How to get users logged on info in HCMSummary: User session info required Content (required): Need to get logon info for users. Seems to be a few posts but not a concrete answer. FND_SESSIONS seems to hold t… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 4 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Benefits Enrollment Window - reporting on window start and end dateI would like to be able to report on the start and end dates of a benefits enrollment window. What table or what OTBI subject area would have these dates?Stephen Jones 21 views 5 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 143 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…Khel 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…Bhavna-Civeo 11 views 3 comments 0 points Most recent by Bhavna-Civeo Reporting and Analytics for HCM