SQL
Discussion List
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…Carlos Benassi 11 views 2 comments 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition… -
Table for Manage Content TypesSummary: Hi team, Need a table or SQL quere where Manage content type information stored. Content (please ensure you mask any confidential information): Version (include…
-
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.Mohamed Eliyas 21 views 3 comments 0 points Most recent by Mohamed Eliyas Reporting and Analytics for HCM
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…John Aitken 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Moving to PER_EXT_PAY_EMPLOYEES_V2_UE from PER_EXT_PAY_EMPLOYEES_UESummary: Moving to PER_EXT_PAY_EMPLOYEES_V2_UE from PER_EXT_PAY_EMPLOYEES_UE Content (please ensure you mask any confidential information): Hi Team, Greetings! As we kno… -
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 41 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 541 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
how to loop through a value set from a fast formula to get multiple valuesHi All, I have requirement to get multiple rows from a value set from a loop and then add up all the returned values from the value set in the fast formula. how can this…
-
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)Good Day Experts, How can I join ZX_LINES and XLA_AE_LINES? I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then th…
-
Query for finding Assignment number from Calculation Card under Associations.Summary: Need a query through which we can find assignment number from calculation card under association. Content (required): Hi All, Can anyone please share the query …Pinky Mukherjee 1K views 5 comments 0 points Most recent by FCL_coop_AS Reporting and Analytics for HCM -
Query to fetch DFF's used across modules in a PODSummary Query to fetch DFF's used across modules in a PODContent Hi Team, Please help with this: Please share query which shares all DFF's used across modules in a POD l…C.R.Balaji 589 views 2 comments 1 point Most recent by Silpa Sathyan Poyyara Reporting and Analytics for HCM -
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 301 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter? -
Business Unit Name ER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
HCM table to fetch eligibility status of compensation plan.Looking for HCM table to fetch eligibility status of compensation plan as "Eligible" or "Limited".Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress…Valerio Curzi 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
SQL to fetch the history ratings from talent profilesSummary: Hi, Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation: Me>career and performance>skills and qualifica…
-
Oracle HCM Extract - Department - GL Cost Centre informationSummary: Hi Experts, I need to fetch the department GL cost center information details. Also need to fetch multiple rows or all existing rows. like we have two row for c…
-
HCM Extract filter takes longer than same sql in BISummary: I verified the performance of the UE plus custom filter by running a BI report with the same SQL, but HCM Extract takes hours to complete whereas BI takes minut…
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there…
-
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 126 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM