Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Get Started with Redwood: Oracle Cloud SCM and Purchasing
Reporting and Analytics for HCM
Discussion List
-
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming… -
OTBI Report does not show Person Legislative information DetailsSummary: Our business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming b…
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one… -
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo… -
More details in the access Log in Oracle HCMAs administrators, we regularly download access logs to monitor user activity in Oracle. These logs provide a basic summary of successful and failed login attempts While…
-
OTBI field results cut offSummary: When I run the attached XML in OTBI, the field results in the vendor name are being cut off. Content (please ensure you mask any confidential information): An e…
-
Unable to Add Home or Work Address for Internal Employee in Offer Letter TemplateHi, We are currently unable to include the Home Address or Work Address of internal employees when generating the offer letter using our offer letter template in Oracle …
-
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However… -
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask… -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
ELIGIBLE WORKERS FOR COMPENSATIONSummary: How can I extract the list of workers that concur to determine the number of eligible in the fields ELIG_COUNT_DIRECT of CMP_CWB_SUMMARY table?
-
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…
-
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
Unable to Only Return Rows Relevant to the User Running the Agent using more than one subject areaContent Hello, We have a bursting agent to let our managers know that they have a new hire which was working previously. We've recently added the personal email into the… -
how to display salaries in arabic words in salary certificate?Summary: In salary certificate we display salaries in English and Arabic. For English we are using below code in template. For eg: For Arabic: In arabic…
-
OTL Audit Report HelpI am trying to create an analysis in OTBI to show the different versions of an employees timecard. I need to see the trail of the changes and when they were done. We are…
-
I am not finding the Observation Checklist in Add Content MenuSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…
-
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…
-
How to capture a field with blank spaces at the end?Summary: We are trying to create an audit report that will identify email addresses that have extra spaces in them. Any idea how to capture those outliers in a report? C…
-
360 peer review participants not showing in OTBI reportI am trying to create a report to show the name of the peer participant and status of the task for a 360 document. The only names that I can get to appear are the employ…
-
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…
-
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the…
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
Job Offer Letter - RTF template If Condition for hire dateSummary: Hi Everyone, Does anyone has experience to write the condition rule under the RTF Template for Job Offer Letter (BI Pulisher), I would like to get some advise o…
-
Fusion Quarterly Upgrade to export in ExcelPlease use the below URL to chose and send to customer in excel format.
-
Dynamic file name generation for data model reportsSummary: I have requirement for dynamic file name generation which will be like the file name with year or period and date extension .I have included the sql code at the…
-
OTBI report for Offboarding Journey also pulling rehires along with termsWe are trying to create a simple response and count report for Offboarding journey (for voluntary terms only) . We have added Workforce management - Checklist Real Time …
-
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…
-
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…