SQL
Discussion List
-
table that stores "Enable Role for Access from All IP Addresses" indicator value (Role Basic inform)Summary: table that stores "Enable Role for Access from All IP Addresses" indicator in role page Content (please ensure you mask any confidential information): Need to k…SaiPavan Kumar Gadepalli 42 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
Reporting Variance - Security Console vs Security Detail ExtractWe would like to understand the source of truth for user roles and privileges. We have a report that is looping through the ASE_ROLE_ROLE_MBR table linking the child and…Clare Paone 27 views 1 comment 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Information of the logged in userCan I detect which operating system or device the user logging in to the system is using?Sinem Kara 12 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Oracle HCM Table for currency exchange ratesSummary: Content (required): Hello experts, we have implemented custom BI Compensation reports displaying payroll elements and amounts in local currencies. Our customer …Valerio Curzi 284 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 135 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration -
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting …
-
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can…Nick Dorfner 23 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 127 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I am getting exception error for one of scheduled report through bursting.Summary: I am getting exception error for one of scheduled report through bursting. Does anyone know what should be the reason. Content (required): Job Priority: Normal …
-
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 139 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM
-
In which table does the Candidate Selection Process Code field is storedSummary: I'm trying to fetch the Candidate Selection Process code, but couldn't figure it out where this field is stored. Content (please ensure you mask any confidentia…Sujeeth Chinta 652 views 3 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 404 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 21 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Where retrieving Process Workforce compensation change statements processes Transaction IDSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where I could find the Transaction ID when processing Workforce compen…
-
fast formula to have the eligibility criteriaSummary: Eligibility Criteria to Assign Benefits Tasks through Journeys Content (please ensure you mask any confidential information): I have built a fast formula to hav… -
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 31 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…Nishu_Kumari 42 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Report of employees with element entries during the pay period NOT calculated due to ineligibility.Summary: For reconciliation purposes we need to identify the elements that were not included in the calculation process for employees since they were not eligible for th…
-
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
i want to join (PAY_PAYMENT_TYPES) tables with person details.wanted to fetch payment type and payment source highlighted in the below snapshot.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Report related detailsSummary: Hello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report …Namrata_20 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Inbound Integration HCM Extract - Zero RecordsSummary: Hi All, I face a unique scenario where my HCM Extract may not always generate HDL Data records to be loaded to HCM Data Loader. Due to this, a blank .zip file g…VinayDama 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 17 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…Oriana L. 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM