Category 81
Discussion List
-
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu…Valerio Curzi 65 views 6 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM -
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 68 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company … -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing?Harish B Choctaw 27 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to Default Assigned Project to Web Clock and Time Card Based on Project Execution AssignmentSummary: Hello, In Oracle Time and Labor, we want the Project field in both Web Clock and Time Entry Layout (Time Card) to be automatically defaulted with the project th… -
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…
-
Unable to open Assign Journey page in Visual Builder studioSummary: Hi, I am unable to open 'Assign Journey' redwood page in Visual Builder studio, I am getting one screen where journeyid needs to be entered to open the page. Ki…
-
Can we have BI/OTBI Report to extract details to get data about privileges of the RolesCan we have BI/OTBI Report to extract details from security console to get data about privileges of the Roles as below: It should include Role, Privilege details and Inh…
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…
-
How can we identify the columns for Employee comments and manager comments in the OTBI Report?The issue we're facing is that we are unable to locate the columns for employee comments and manager comments in the OTBI subject areas in order to retrieve the accurate…Vikas V. Kamat 52 views 3 comments 0 points Most recent by Thulasi Ram Reporting and Analytics for HCM
-
Interview Percepts feedbackDear team Hope you are doing well Could you please provide a query to retrieve the Interview Percepts feedbackManal Almutairi 2 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Is there a report available for all transaction across all module for leadership prospective ?Summary: We are looking at all transactional report, like which and how many employees click on view paycheck link from self service, who's clicking on other features av…
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…
-
Help with this error when trying to create offer "There was a problem creating the job offer..."What is the solution to fix this error when trying to create new offer? Have already tried reloading the template.Sara EW 31 views 1 comment 0 points Most recent by Erika B-Oracle Recruiting, Opportunity Marketplace
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
which table stores the booked seats field of learning coursewhich table stores the booked seats field and if the field is not available in table directly then what can be the other ways to calculate the booked seats
-
Is there a report that will show all data roles and their security policies?Summary: Hello - Our organization has 3 Document Type Security Profiles created that are spread across many roles. Instead of manually trying to find which data role has…
-
Goal Approval workflow notification issue with CLOB type data which have > or < symbol ?Summary: Goal approval workflow notification is having success criteria field where field is having below combination of text : 7800 and when notification triggered and …Ankur Jain--Oracle 5 views 0 comments 0 points Started by Ankur Jain--Oracle Reporting and Analytics for HCM
-
Public IP Address?Summary: Hello, our data team is interested in using SFTP to have the ability to automate reports from Oracle to our dashboard and have real-time updates. However, our I…B_Meiling 31 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration -
icp sortingHi, I am trying to sort the icp column so that the recurring records comes first and with in recurring records the latest records comes first and after recurring the non…
-
query to fetch educational details.query to fetch educational details.
-
Few privileges are not available in the database tableSummary: There is issue with the privileges: Few privileges are not visible when query directly from roles/privilege screen while the same is visible when query a role. …Shailender Ahuja-Oracle 2 views 0 comments 0 points Started by Shailender Ahuja-Oracle Reporting and Analytics for HCM
-
Department Costing Information related PVOSummary: We have a datawarehouse where we are pushing most of the HCM data using BIACM using the standard PVO. We couldnt find any PVO for department costing. I have gon…Sahil Kathuria 4 views 0 comments 0 points Started by Sahil Kathuria Reporting and Analytics for HCM -
How to provide the correct Return Value from the List of Value query in the BIP Data ModelSummary: I have this BIP Data model which extracts the pending approval of a certain user. This used to work before but now I am getting this error "Invalid parameters r…Boying 31 views 11 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How can I safely handle cases where GET_VALUE_SET returns null, and default the value to 0Summary: When the value set returns null (i.e., no leave has been taken), the formula either fails or doesn't return the expected accrual. Even though I am checking for …Pranjal Mohla 29 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM
-
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 11 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
How to create report on employee project manager ?Summary: Hello, For our Blue Collar Population we are using the role of Project manager in addition to the Line Manager. Our issue is that we don't find the subject area…LucieWS 24 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM