SQL
Discussion List
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 66 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM -
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 935 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM -
Query to fetch BIP report job historySummary Query to fetch BIP report job historyContent Hi Team, Is there any query from table to fetch the BIP report Job History. Thanks, Sourav -
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…Valerio Curzi 25 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 1.1K views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
BIP | SQL query to get details of the employees belonging to departments below the selected departmContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging… -
BI report to extract time informationSummary Any pre build BI report to extract time information available?Content Hello anyone has any prebuild report to read Time information? Thanks, Nicola
-
Is there a way to round-off numbers and truncate dates in simple XML outputs?Content hi. I can't seem to find a way to round-off numbers and truncate dates for simple XML hcm extract outputs. Is it possible?notautomni9 22 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for HCM
-
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering…Mani Venkataraman 1.1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going …User_2025-02-04-08-51-08-912 117 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM
-
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…Raymund Jerome 36 views 2 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas…Dhanuka Chamal 3.1K views 6 comments 2 points Most recent by Dhanuka Chamal Reporting and Analytics for HCM -
how to extract sql query in data modelSummary how to extract sql query in data modelContent Hi, I wonder if there is any way to extract SQL Query in Data Model using table/web service/etc. Regards, Suyoung V…Suyoung 37 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
In which table is the issued by field for license and certificate for talent profileSummary issued by field for license and certificateContent In which table I can see the full entry for issued by field for license and certificate ? I can only see the a…
-
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 425 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…User_4VVG2 428 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM
-
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Analysis with EIT fieldsSummary Need to display current Parent Position Code for the record but EIT causing duplicationContent HI all, I need some help with an Analysis - I have paired the anal…User_2025-02-04-08-51-08-912 160 views 4 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 51 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 49 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…User_2025-02-04-08-51-08-912 56 views 1 comment 1 point Most recent by Srdjan Ostojic Reporting and Analytics for HCM
-
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, NivyaNivya Mathire 88 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
CONVERT FF to UDT creationContent hello Experts, I would like to ask for your assistance in converting fast formula - XX_RECOMMENDED_MAX_QUARTILE_FF to a user defined table. This FF is used in BP…
-
Delegated Roles TableSummary Delegated Roles TableContent Hi All, Is there any other table which stores delegated roles details? I am able to find the table PER_DELEGATED_ROLES but this repo…nitin Sharma 12 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
Latest Assignment ChangeContent Hello, I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've u…User_2025-01-31-00-25-12-234 131 views 8 comments 0 points Most recent by Ahmed AZA Reporting and Analytics for HCM
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 100 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Performance goals report - which should iclude all stages of goal details (Approved,Saved,Sumitted)Summary Need to develop a BI report for the Goal Plan Goals which are in saved state and submitted state and approved state.Content When employee runs the report , the r…User_2025-01-30-17-37-30-647 80 views 5 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Need the logic to convert English to Chinese language in SQLSummary Need the logic to convert English to Chinese language in SQLContent Hi Team, I have a BI(SQL) report and some of the fields like 'Legal Entity, BU, some EIT fiel…User_2025-02-01-03-43-13-079 96 views 4 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM
-
Table in Data Source: AuditViewDB where it contains the names and employee number of employees.Summary I'm currently using the Data Source: AuditViewDB for some audit purpose. I need the table from that data source that contains the names and employee number of em…Mark kristan De los Reyes 39 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM