SQL
Discussion List
-
Need help on Logical SQL with UnionContent Hi Experts, I am trying to identify the New Hire's/ Exits and TEC changes using Logical SQL. Both parts of the sql works , but when UNION is applied it breaks. A…User_2025-01-30-00-14-06-021 109 views 3 comments 0 points Most recent by SM-Oracle Reporting and Analytics for HCM -
How to replace DATA_CACHE columns in 21B with XML_DATa_CACHESummary How to replace DATA_CACHE columns in 21B with XML_DATa_CACHEContent Hello, Can anyone help me replace DATA_CACHE columns in 21B with XML_DATa_CACHE, in BI report…Varkey George-Oracle 43 views 4 comments 0 points Most recent by VibhaSorte Reporting and Analytics for HCM -
Report that pulls out the extract runSummary Do you have a report ready?Content Hello, I need to develop a report that pulls out the extract run in a specific date. Do you have something ready? Thanks Nicol…
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi ExpertsSelect LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. B… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 29 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for HCM
-
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. …Mansur Khalil 90 views 7 comments 2 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…User_2025-02-11-08-39-07-186 48 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 481 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106 Reporting and Analytics for HCM
-
Require a report to show when a Primary Mailing Address is missing in the systemSummary It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing…User_2025-02-04-08-51-08-912 1.1K views 6 comments 3 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co…GauravGupta39 16 views 3 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 39 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
SQL to Pull Most Current Ethnicity recordSummary Looking for BIP Data Model that will select the most current EthnicityContent Hi, I am creating a data model of person information and have been challenged when …Denise Izzi 1.2K views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Retrieving Affected Party column in HRHDContent Sharing the data model for reference and for others to benefit. This column was unavailable in OTBI at the time the report was built.User_2025-02-10-08-27-16-805 35 views 6 comments 1 point Most recent by Noopur Sapatnekar Reporting and Analytics for HCM
-
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)…User_2025-02-07-19-03-14-525 38 views 6 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM
-
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank YouAwadhendra Tripathi 36 views 1 comment 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 54 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…Iann hick 42 views 5 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro… -
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj…Pedro Teixeira 25 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 48 views 2 comments 1 point Most recent by Rajesh Ravikumar Reporting and Analytics for HCM
-
Oracle Documents of Records linkContent Hi Guys, Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. tha…User_2025-02-05-11-53-59-507 32 views 2 comments 1 point Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 43 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 31 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 129 views 4 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
HCM Audit tablesSummary Need to find a table where audit information will be stored.Content Hi All, I need to find the tables where audit data is stored. Columns such as Data, User, Eve…User_2025-02-10-16-28-01-402 1.5K views 2 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
Database Table and Database Column for Target Bank presentation tableSummary Need the parameters to build a BIP report for outputContent I am building a report that displays as a form completed for each new starter however it will not out…Dawn Cawston - CPS 31 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Query to pull earnings balance for each assignmentContent Need help on pulling earnings balance for each assignment or identifying which assignment has earnings.Renzel Keith Coquia-204674 54 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Disclosure for DiversitySummary Diversity TrendContent Hi Experts, We are trying to track diversity eg. Gender , ethnicity, Sexual Orientation, Disability etc over time Has anyone attempted thi…