Category 81
Discussion List
-
Emails with analysis tables are putting in extra spacingSummary: We have analysis that displays jobs that were posted in the past week. We send this report to users via email and have the data displayed in the body. The data … -
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
It is possible to obtain a history of all changes made to the security profilesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…JESSICA RODRIGUEZ 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Does SFTP setting done in Production is copied over to non-production environment during P2T?Dear Experts, Can someone let me know if SFTP setting done in Production is copied over to non-production environment during P2T? Please share oracle documentation for r…B S Rafatullah-Oracle 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Arabic Text in PDF Output Not Bold and Font Does Not ChangeSummary: Hello everyone, I am facing an issue with generating PDF output where the Arabic text does not appear in bold, and the font does not change as expected. • The b…
-
Subject area to pull checklist questionnaire in OTBISummary: We are trying to develop reports on questionnaires that have been configured for checklist. But when we are using "Workforce Management - Checklist Real Time", …Priyanka Ray 31 views 4 comments 0 points Most recent by Priyanka Ray Reporting and Analytics for HCM -
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m…Consultant Ian 31 views 7 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…Smitashree Pradhan 22 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…Gunal Baskar 775 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Analytics for scmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…john.hutchinson 11 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
Need Sample SQL Data Model for EFF for defaulting data using Sales order Header IDSummary: Business requirement to default the Demand Class value in EFF. need to know how to default that value which is applied on Line level and will be defaulted in EF… -
For Performance documents, is there a report area available to show completion date for tasksSummary: We need a report to identify the date each of the tasks within the process flow of our performance documents are completed. If they are not complete, we would e…
-
Absence Plan does not update when worker's employment details updated.Summary: Has anyone encountered an issue where, when a worker's employment was updated, the new eligible plan was not enrolled, even though the Update Accrual Plan Enrol…Shannon Teves 22 views 1 comment 0 points Most recent by Priya Palanivel-Oracle Workforce Management
-
Looking for advice regarding creation of a report to load details into Costing for PersonsSummary: We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is …
-
Way to hide hyperlink on Workflow Notification / BIP RTF template based on Security Role?Summary: My customer wants to have me hide a "View Attachments" hyperlink on a DoR notification (BI Pub - RTF template) based on specific AoR role. I don't see how to pi…
-
BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS WordSummary: BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS Word Content (please ensure you mask any confidential information): BIPubli…FCL_coop_AS 193 views 13 comments 2 points Most recent by FCL_coop_AS Reporting and Analytics for HCM
-
Experience with Fivetran BICC integration with Oracle Cloud HCMWe are looking for an integration tool to support us with the data ingestion from HCM to support our analytics team to extract and analyze HR data. I want to hear your f… -
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could …Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Report allows user to see data from multiple Legal EntitiesThe issue is that when the user tries to access a report, if they have this role assigned: Compensation Administrator CAN Data Role They can pull more data, outside of t…jose_enrique_gayatin 1 view 0 comments 0 points Started by jose_enrique_gayatin Reporting and Analytics for HCM
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 7K views 17 comments 2 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
The supervisor hierarchy should be displayed in the report as a graphical representation.Summary: The supervisor hierarchy should be displayed in the report as a graphical representation. Content (please ensure you mask any confidential information): Require…
-
Dashboard prompt dependentSummary: Creation of a Dashboard prompt with Job Family, Job Function and Job Profile field dependent from each other. Content (please ensure you mask any confidential i… -
Remove Null value from Dependent LOV prompt in OTBISummary: When we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL param…
-
Prompt filtering based on another promptSummary: Hi, I have 2 prompts as presentation variables and I need them to connect between each other. For example when I selected a specific country on the first filter…
-
Need query to get Employee contribution and pretax deduction information of person Result?Summary: Hi Team, I need BI Report query for Employee contribution and pretax deduction information from Fusion Content (please ensure you mask any confidential informat…Ratan Nahak-Oracle 21 views 0 comments 0 points Started by Ratan Nahak-Oracle Reporting and Analytics for HCM
-
WLF_ASSIGNMENT_TASKS_F does not have Latest InfoSummary: Content (please ensure you mask any confidential information): Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables. Unfor…
-
Has anyone created a custom role for staff outside of HR to access other staff addresses?Summary: Content (please ensure you mask any confidential information): I am still figuring out how to create custom job roles for HCM, but I am hoping someone that has …