SQL
Discussion List
-
OBIEE BIP Report LogSummary Where to find report log which shows SQL that's generated by report while report executionContent Hello Everyone, I'm trying to find log of a BIP report which I … -
Need a report for AOR with scope of responsibility ?Summary Need a report for AOR with scope of responsibility ?Content Hi Team, Need a report for AOR with scope of responsibility ? I need to create a report for AOR but n… -
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 71 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in…User_2025-02-05-23-01-57-438 44 views 1 comment 0 points Most recent by RaviThejaDarbha Reporting and Analytics for SCM -
Account Segments Report ExampleSummary Account Segments Report ExampleContent Hello all We need to develop a report about Account Segments. We made it by Query and it is bringing the correct informati…Pedro Teixeira 20 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM -
Bursting sending duplicated reports.Summary Some outputs are being sent duplicted (or more!) by mailContent I have a report to get the hand quantity for each subinventory. The output is like: SUB ITEM QTY.…User_2025-02-07-06-48-26-537 27 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for SCM
-
Conditional Formatting in Pivot TableSummary Colour by Absence Type working in Table but not pivotContent Hi I'm trying to show a calendar for this month and next month. The number of days/hours shows corre… -
Query Data Model securitySummary Example of query or config to allow data models be displayed to all employees without them seeing whole company data.Content Hello all When a more robust report …Pedro Teixeira 39 views 6 comments 1 point Most recent by Pedro Teixeira Reporting and Analytics for HCM
-
Looking for National Insurance Category LetterSummary I am looking for the NI Category LetterContent Does anyone know where in the tables (OTBI or BIP) I would find the National Insurance Category Letter? Just to cl…User_2025-02-06-00-01-08-606 87 views 12 comments 0 points Most recent by Jay A Reporting and Analytics for HCM
-
BPM tablesSummary BPM tablesContent Team, BPM tables (FND_BPM_TASK_VL and FND_BPM_TASK_ASSIGNEE) have the initiated_by column as null or blank for few transaction? Could you help …acmhari 218 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to show 2 sets of data based on dates selected by the userSummary Report needs to show several fields for different dates(not necessarily the current and previous values)Content Hi All, I have built a query that returns data ba…User_2025-02-04-08-51-08-912 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Check-In Performance Template BIP table Joins.Summary Can anyone please explain how goals and its feedback are tied/joined to check-in peformance template for reporting purpose using BI Publisher.Content We have a B…User_0REWN 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 135 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Generating a indented BOM list report.Content Hey there, I'm trying to generate a report with the indented list of a BOM. In Oracle 10 we had fields to build the structure based on a starting node and then j…User_2025-02-07-06-48-26-537 155 views 4 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for SCM
-
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20AUser_2025-02-05-04-17-04-394 388 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 32 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo…
-
How to identify resubmitted goals for approval?Content Hi, I am creating a goal status report where I am able to get proper goal status from the table HRG_GOALS with column GOAL_VERSION_TYPE_CODE except for those who…Nivya Mathire 56 views 6 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
User Role Historical DataSummary Getting the Historical data of RoleContent Hi, Is it possible to get the historical data of User Role in HCM? We are not using the End_date on the user role, but…User_2025-02-04-07-19-57-588 62 views 5 comments 1 point Most recent by Ravi Shinde Reporting and Analytics for HCM
-
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
How to link Person Real Time Subject Area with Workforce Management - Worker Assignment Event Real TSummary Is it possible to do this using logical SQL?Content Hi, I'm new to OTBI and I'm experiencing a lot of frustration regarding the Person Real Time Subject Area not…User_2025-02-05-22-44-35-842 86 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Error on Report Template - java.lang.ClassCastExceptionSummary In the data model, all is good, data is is showing but when I run the report template this error pops out "java.lang.ClassCastException". Please see attached ima…Mark kristan De los Reyes 18 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is there any way to connect Oracle Fusion OBI from SQL ServerContent H Is there a way to connect to Oracle Fusion OBI server to our local SQL Server? We would like to report on Data in conjunction to our local HRIS system. Thanks,…Nizar Kassam 50 views 8 comments 2 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
Data Models Best PracticesSummary Are the Best Practices for Building Data Models using Tables vs. ViewsContent Wondering if there are best practice guidelines for building Data Models? For examp…Denise Izzi 54 views 4 comments 0 points Most recent by Valeriy Gorbunov-80491 Reporting and Analytics for HCM
-
Logical and Relational Data Model Diagrams For Fusion Applications HCMSummary Logical and Relational Data Model Diagrams For Fusion Applications HCMContent I wondered if there was an updated Fusion Cloud HCM data model to easily identify t…Ruzwan Akram 515 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Use text box for user in analysisContent Hi, I am trying to create analysis that return data for selected reference designator. I succeeded to create analysis that let the user to select reference desig…