Category 81
Discussion List
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 43 views 2 comments 0 points Most recent by Eric Geddes Reporting and Analytics for HCM -
Redwood Issuing Comments field in Document Record Displays html Text in OTBISummary: We just implemented Redwood for Document Records. The Redwood field for Issuing Comments (seeded Oracle field) displays as a rich text editor field where bold, …Linda Chirash 18 views 5 comments 0 points Most recent by Linda Chirash Reporting and Analytics for HCM
-
Issues with section-level guided journey for the Assignment step in employment infoWe are having Issues with setting up- section-level guided journey for the Assignment step in Redwood employment info pages We are trying to follow steps under -https://… -
I am not able to get an etext output without Special charactersSummary: I am getting special characters in my etext output. I tried using UTF-8 character set, that still didnt help. I used save as encoding UTF-8 on rtf template. Tha…RohithGundreddy 12 views 0 comments 0 points Started by RohithGundreddy Reporting and Analytics for HCM
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 6 views 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 264 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
OTBI - Legal Employers that use this jobSummary: OTBI - Legal Employers that use this job Content (please ensure you mask any confidential information): Subject Area: Workforce Management - Worker Assignment R…Julie S. 10 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 16 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a… -
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 27 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
How to report the 'Attachment Count' of a DoRSummary: How to report the 'Attachment Count' of a DoR Content (please ensure you mask any confidential information): Hi, we created a Document Of Record. The employee h…Barile Alberto 18 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…Camilla Crescenzi 107 views 2 comments 0 points Most recent by DanWoodward Reporting and Analytics for HCM
-
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…
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 68 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
Bold letters are showing in PDF Output?Summary: We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, all the letters are…
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…Srushti 78 views 18 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …bwdata 73 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …SARAVANA KUMAR T-Oracle 132 views 5 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"?Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"? If so, what is the Subject Area? I've tried several "Knowledge" SA's, and a few "…Phillip Jones 59 views 17 comments 0 points Most recent by KMChris-Oracle Reporting and Analytics for HCM -
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 91 views 7 comments 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM
-
How to restrict special characters for account holder name in redwood personal payment method pageSummary: Customer want validation needs to be thrown as an error when there are Special Characters in the the Account Holder Name. And in personal payment method page I'…
-
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu…Vishal Purohit 4 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 21 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.