Category 81
Discussion List
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 48 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
BI Reporting function that creates link to attachmentsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Consulting Description (Requir…Claudio Marini-Oracle 36 views 0 comments 3 points Started by Claudio Marini-Oracle Reporting and Analytics for HCM
-
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…Riti Malhotra 47 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
How do I run a report on average age of employees?Summary: I need to run a quick report on the average age of employees in the whole organisation and per Legal Employer. Content (required): I have the report with employ…User_2025-03-10-21-26-28-299 36 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
how to restricted otbi report to show employee absencesDear , I have a otbi report which is showing correctly result with all employees absences but issue is its showing for those employee who applied leaves on 2021 Dec to 2…Mirza_Adeel 36 views 6 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 544 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
Questionnaire Score - 360 FeedbackSummary: Hello everyone, Does anyone know how to fetch Questionnaire Score in a performance document using OTBI? What is the subject area and column folder for this? You…Hazel De Castro 66 views 15 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
In Otbi reports where we find Absence DatesDear , I need to put Absences Dates in otbi report but i cant find Not need Date Start and End Date i need only Date For example if one employees taken 30 leaves from 25…
-
Can we include a pivot table in a OTBI report.Summary: I have a report and wondering if a Pivot table can be added so if we run this report or schedule it, it would include that pivot table? Content (required): Vers…Rajib_Samanta 56 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
Deep Links in narrative textSummary: Content (required): Hi, I would like to insert a deep link inside an alert with narrative text. For example: https...fscmUI/faces/deeplink?objType=DOCUMENT_RECO…Alberto Americi 76 views 12 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Reset the sequence in etext template when I have only one level where data residesExperts, I have to generate a sequence that resets after printing details for every person. The Cost_ID tag makes sure every record that is needed is fetched on the repo…Aloka Bhattacharya 61 views 2 comments 0 points Most recent by R Ravichandran Reporting and Analytics for HCM -
Restrict Participation in Another Plan Fast FormulaSummary: Content (required): Hello everyone, I'm currently trying to create a Fast Formula that will restrict population's eligibility for Compensation Plan B if they ar…Maria Xydopoulou 39 views 0 comments 0 points Started by Maria Xydopoulou Reporting and Analytics for HCM -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 115 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 199 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
ADFDI GPO InstallSummary: Any examples of successfully deploying ADFDI via Group Policy Objects? Content (required): We have previously pushed out ADFDI through GPO by extracting the MSI…JoshE 68 views 2 comments 0 points Most recent by Kelsey Von Tish-Oracle Reporting and Analytics for HCM -
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi…Christian Suarez 34 views 3 comments 0 points Most recent by Christian Suarez Reporting and Analytics for HCM -
Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…Gerardo Peluso 36 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
Unable to Join Multiple Subject AreasSummary: Unable to join "Workforce Management - Absence Real Time" Subject Area with "Workforce Management - Worker Assignment Real Time" Content (required): Our require…Jyothi Gorantla 35 views 4 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
Goals shared but not added to a planSummary: I'm looking for a way to identify employees that have goals shared with them but not assigned to their goal plan. I understand I can pull which goals are shared…Lauren K. 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Reports for Goals Completed in Plan YearSummary: I'm looking for the best way to report on all goals completed based upon the plan year. I've attempted to use the 'Goal Status Overview Real Time' subject area.…Lauren K. 18 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Recruiter ScorecardSummary: Content (required): Has anyone created a recruiter scorecard before? How do you deal with requisition metrics if there was recruiter turnover and the new recrui…Riti Malhotra 36 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
'Performance Document Rating Distribution' report not runningSummary: Hi Peers, I'm trying to make use of the seeded report 'Performance Document Rating Distribution'. It is not running whereas other seeded reports (e.g. 'Performa…S Shree 55 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we define hierarchies in OTBI reportsDear , I have a requirement to do hierarchies in OTBI report, it is possible in otbi report? For example if i am login and open report its shows only my and under my emp…Mirza_Adeel 56 views 28 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for HCM
-
Performance Template field is not available in "Compensation - Workforce Compensation Real Time" SASummary: Unable to get Performance Template used while defining workforce compensation plan for performance calibration Content (required): We are using workforce compen…Jyothi Gorantla 24 views 2 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
EEO Reporting for Federal, State and LocalHi all, Is there any document which tells us more about "Submit EEO-4 State and Local Government Report for US". Thanks, Sathish
-
Where can I find "Job Definitions" for ESS jobs?Summary: I'm looking for a list of ess job definition names such as: 'JobDefinition://oracle/apps/ess/hcm/users/SyncRolesJob' Content (required): The end goal is to crea… -
OTBI: Questionnaire ScoreSummary: Trying to pull the overall score from a questionnaire tied to performance document Content (required): Hello all, I'm trying to build a report in OTBI where I c…Hazel De Castro 47 views 9 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM