Category 81
Discussion List
-
How to create report of Payroll check numbers with employee name and addressWe have a requirement to provide list of payroll checks with check date, amount, employee name, employee address. If it can be done using "Analysis", please advise on Su…Kit Stephenson 84 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
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 31 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Recruiter Preferred NameSummary: Wondering if anyone was able to pull the recruiter preferred name and preferred last name in OTBI reports.Marta Martinho 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How to report in BI Publisher the Approval Date for Change Assignment TransactionSummary: How to report in BI Publisher the Approval Date for Change Assignment Transaction Content (please ensure you mask any confidential information): Hi, we configur…Barile Alberto 3 views 0 comments 0 points Started by Barile Alberto Reporting and Analytics for HCM
-
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…SAHAD 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
BI Report for otbi reports and the scheduled agentsWhich table stores the information of otbi reports and its scheduled agents.Aishwarya Somvanshi 63 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
OTBI - worker assignment real time - user visibility issueSummary: OTBI - worker assignment real time - user visibility issue Content (please ensure you mask any confidential information): Hi team, we have an issue with an otbi…Claudia Schiff 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Get all EMP reporting to a manager in certain time periodI am looking to get all direct reports(all active and term) of a manager during the time period 10/31/22 to present day 05/20/24. If termed I need also need the term dat…Trupti Khodke 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Total Compensation Statement OTBISummary: Analysis for Total Compensation Statement - Feedback Survey Content (required): Is there an analysis available in OTBI to pull data for the Total Compensation S…Shelly Feyerherm 76 views 13 comments 0 points Most recent by Art Cannon Reporting and Analytics for HCM -
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. There are a number of…
-
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
How to get the latest record in OTBISummary: Hi , I am just working on very simple requirement . Where i need to get below columns. Employee/ZinZai ID Person full name Person email address Person status ( …Vishnupriya 282 views 6 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM
-
OTBI Report to get capacity rule's booked seat from Learning ModuleHello Expert's, Want OTBI Report to get Booked seats from Capacity Rule in HCM Learning Module. Please check below navigation and Image. My Client Groups> Learning Catal…Rajdeep Chavda 52 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e…MilanMohanty 155 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anup Karmankar 13 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …
-
Oracle Payroll fast formula to fetch from VbyC tables?Summary: Can we access our own VBC records with a Oracle Payroll fast formula to fetch from VbyC tables? ex. PAY_VBC_VALUE_IDENTS_VL OR below picture list. thank you Con…JBW_HCM 1 view 1 comment 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM
-
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree…Parag Hiremath 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Workforce Management - Workforce Trends Real Time subject area data dictionarySummary: Workforce Management - Workforce Trends Real Time - metrics calculation We are using the Workforce Management - Workforce Trends Real Time subject area for tren…tanyak 82 views 10 comments 0 points Most recent by Shaik Saddam-Oracle Reporting and Analytics for HCM
-
Enrollment effective end date meaningSummary: Enrollment effective end date meaning Content (please ensure you mask any confidential information): Hello experts, I've created a report with the Learning Reco…Oriana L. 11 views 3 comments 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell…
-
how to report learners in waitlist otbiSummary: how to report learners in waitlist otbi Content (please ensure you mask any confidential information): Hello experts, we would like to create an OTBI analysis t…
-
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to set in OTBI report the difference between a variable (an input parameter) and a fieldSummary: How to set in OTBI report the difference between a variable (an input parameter) and a field Content (please ensure you mask any confidential information): Hi, …Barile Alberto 72 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …Parag Hiremath 51 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to run the report USOnlinePayslip from BI PublisherHi All, I need to run the report USOnlinePayslip from BI Publisher. I am not able to get the output whatever parameters I pass. I need to get the xml data of the output …SowmyaSk18 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
BICC VO for PAY_COSTS linking to XLA tableSummary: We are looking for a BICC VO that links the PAY_COSTS Table with XLA tables. This VO should bring in the segment details. Currently we are using PAY_XLA_COSTS_V…Conor Murnane 41 views 4 comments 0 points Most recent by Conor Murnane Reporting and Analytics for HCM
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM