Category 81
Discussion List
-
Set up a virtual/matrix organization in Oracle HCMSummary: In our organization, there is a regular organization hierarchy showing the line manager and its department. However, as we move more into an agile way of workin…Andries 117 views 14 comments 0 points Most recent by Jordan Gariety Reporting and Analytics for HCM -
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 12 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM -
OTBI: manager with at least a direct report both based in the same countryHi everyone, Our customer has the following requirement: To retrieve the list of the manager L1 located in italy with at least a direct report Both manager and direct re…Alessandra T. 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Pivot Table limits numbers of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…Arnabb 46 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Periodic Payroll Activity Report bursting Based on LocationSummary: Hi I have a requirement to split Periodic Payroll Activity report based on location. I tried bursting option by creating a copy of globalreport data model and c…
-
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 15 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM
-
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A…
-
Line Manager Dashboard custom with Manager Name HeadcountSummary: Hello, I made a custom OTBI dashboard from the vanila Line Manager Dashboard. In that dashboard we added one prompt Manager Name that is prompted. So when we se…Ilzura Ismailhodjaeva 65 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table… -
Enterprise Hire Date in BI PublisherSummary: Enterprise Hire Date in BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to create a BI Publisher report which cont…Barile Alberto 22 views 4 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Payroll Balance Real Time - Multiple Assignments Not showingSummary: Trying to pull a report with the Payroll Balance Real Time that brings in the multiple (primary & secondary) assignments with hours worked & payroll for each as…Rhonda Fischer 1 view 2 comments 0 points Most recent by Rhonda Fischer Reporting and Analytics for HCM -
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 142 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting on Performance Documents of Workers post Global TransferDuring the Global Transfer of Workers, their existing performance documents can be assigned to the latest assignment. In such cases, the cloud application displays the p…Radhika Ramachandran-Oracle 101 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need help on Long Running Custom BI Report - running more than 5 hours and failingSummary: The Custom bip report is running for long time(more than 5 hours) and erroring out saying that "Elapsed Time is exceeded" . Would you please help in tuning the …Rama123-Oracle 243 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Benefits arrears OTBI reportHi all, We are trying to develop a new OTBI report for benefits arrears , we have used the following 2 subject areas with effective date prompt. 1.workforce management -…yugandhar 164 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to select more than one filter option in OTBI ReportSummary: How to select more than one filter option in OTBI Report Content (please ensure you mask any confidential information): Hi, we created an OTBI report. This repo…Barile Alberto 44 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
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 78 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 32 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 13 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 5 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 13 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 66 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 13 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 72 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 264 views 6 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM