Category 81
Discussion List
-
RTF template: hide empty column in pivotGood day, I created a custom RTF template that displays a pivot table. The field "BASE_ELEMENT_NAME" lists different elements but it's empty for some employees and, as a… -
**SOLVED** How can I get Manager grade step to display in OTBI?I have a requirement to include the grade step of managers in a report I am building however there doesn't appear to be anything available out of the box for this. Does …Rob Ward 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 5.4K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM
-
BI Report for Job Requisition Approval FlowSummary: BI Report for Job Requisition Approval Flow containing full approval flow related data. Content (please ensure you mask any confidential information): Hi expert…
-
how to personalize / customize all Oracle HCM notifications - my changes are not showingSummary: Customer requirement is to personalize all HCM notifications for users. The requested changes are the following: - place their logo in all HCM workflow notifica…Katarina Bartova-Oracle 135 views 2 comments 0 points Most recent by InaNotra-Oracle Reporting and Analytics for HCM
-
What are the limitations of language pack?Summary: We need to translate the entire Oracle Cloud for users in a specific region. Could you please explain how the language pack will function in this scenario and w…Kritika Gupta 21 views 3 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Is it possible to report on element config? (e.g. is it taxable, pensionable etc)Summary: I'm looking to create an analysis which shows me the configuration of each element in terms of which have been set as taxable, pensionable, which payrolls they …BFell 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
generate statement custom field values not picking from rtf templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…karthies 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to pause scheduled process and prevent a child process from running?Summary: Hello everybody. I recently discovered that releasing a process that was on hold will cause it to run all child processes, even if the date/time of the original…AppsSupport 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Compensation Change statementsSummary: We use Centrally managed and stored delivery options and Allow managers to do a staggered release of statements. We only give access to senior managers and abov…
-
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…Bhushan Kulkarni 1 view 1 comment 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Payroll DD/Taxes Report SQL HelpWe have a New Hire Direct Deposit/Tax report that captures employees who have not completed DD and/or Taxes. How would I update the query to pull all new hires/rehires (…
-
User is unable to access job profileSummary: When the user is trying to access "Job profile & OPS dashboard", they are unable to access the Job profiles dashboard. The role is restricting the users to not …
-
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…Valerio Curzi 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Cost centres report in OTBISummary: Hi, I am wondering if anyone has a way of reporting on cost centres along with HR employee data in the same report. So far i have seen that Payroll costing setu…BillM 392 views 7 comments 0 points Most recent by Ignacio Velando-Oracle Reporting and Analytics for HCM
-
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet…Matheus Roberto 147 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
Notes Attribute in Assignment Action Occurrence Subject AreaHello , We are interested in leveraging Notes attribute in Assignment Action Occurrence Subject Area from 25A , however I am having trouble locating where this attribute…
-
how to call BIP report using REST webserviceSummary: I want to get the BIP report output using REST webservice REST API for Oracle BI Publisher - Run report I have followed oracle doc and this Run Oracle BI Publis…Ketan- 268 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
BIP Report timing out for select Associates in-consistentlySummary: This report is run by about 165 associates. Almost 80% of runs are successful where others are getting “Time out error” for rest. It’s not consistent, though. C…
-
Report to identify employees with corruption in "PER_PERSON_NAMES_F" tableSummary: Hello, We are looking for a report to pull all employees with corrupted "PER_PERSON_NAMES_F" table. We had several employees with this corruption that caused er…
-
Performance Issues for specific usersSummary: Some users receive the same error message of timing out while trying to pull a report. However, I can pull the same report without any issues. I am trying to de…MMS 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Recruitment - Candidates How to get a SMS/Email Communication Message History OTBI AnalysisSummary: Hi, On a Requisition via the Messages Tab a Recruiter sends out messages to candidates via Email or SMS using templates or custom messages. We need to have the …
-
Bullet points formatting getting changed during output of bursting BIP reportSummary: We have bursting report which sends email notifications. We have designed the RTF template and providing some instructions like below format. But while sending … -
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 1 view 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 447 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Secured List Views for compensation worksheet displaySummary: HCM table of Secured List Views for compensation worksheet display Content (please ensure you mask any confidential information): Version (include the version y…Tamseel Aijaz 1 view 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Which Subject Area holds Management Level, Retention Risk, Vacancy Risk and MobilitySummary: I'm trying to create a Talent report, but unable to find few attributes in any Subject Area, and those attributes are Management Level, Retention Risk, Vacancy …KamalTeja 1 view 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM