SQL
Discussion List
-
How to retrieve APPLLOG_DIR/xxxxx.log log file using BIPSummary: We enable AFLOG and generate a log file in directory APPLLOG_DIR. Is there a way to retrieve this log file in BIP? I google and it say that we can use ULT-FILE …Yeung Shing Keith 6 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for SCM -
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 151 views 11 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
BPM Worklist: SQL query to skip approval if job requisition is pipelineSummary: I need to skip the job requisition approval in 2 scenarios: Job requisition is created as pipeline Job requisition is not having position id However the skip ru…
-
Need table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This …Janardhana Kondaveeti 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track…
-
Best way to pass multi-select parameter list SQLSummary: I am working in an Oracle BI Publisher environment and ran into challenges converting a single-value parameter into a multi-select parameter, specifically for s…MichaelV823 26 views 3 comments 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for SCM
-
Grouping data in Excel TemplateSummary: I am trying to group data in my Excel Template. Every employee has 2 annual leave plans. This is how the data currently display when I group by G_1. I want to g…Consultant Ian 35 views 6 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us… -
Is there any query to identify which flow generated the output file that included the given PNHi Team, Is there any query to identify which flow generated the output file that included the given person number. I want to identify which flows picked up the given pe…Kollamsetti Kiran 21 views 12 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables …nmdp-andrew 558 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Min-Max Planning Details Across All Orgs ReportSummary: Needs a query to fetch the Min/Max details for all the items across all the inventory organization in the application. Content (please ensure you mask any confi…Mamdouh Ahmed 19 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve…Oriana L. 33 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
REST APIs or SQL Queries to fetch the Fusion SAAS BI Report's list from "/Custom" FolderSummary: We have a requirement to fetch all Data Models & Report from "/Custom" folder in Fusion SAAS. Content (please ensure you mask any confidential information): Loo…Pradeep Kumar-Oracle 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit…
-
Exception Report for Inventory Pending TransactionsSummary: We need a query to get the details of the Inventory Pending Transactions. Content (please ensure you mask any confidential information): We are seeking a PL/SQL…Mamdouh Ahmed 20 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
How to export all HCM extracts in one goSummary: How to export all HCM extracts in one go Content (please ensure you mask any confidential information): Hi All, Greetings! We typically export the XML for a giv…
-
per_pos_tree_node_rf and PER_POS_TREE_NODE_RF tables empty, though it is visible from frontendSummary: I am developing an HCM Extract to send Position Structure data external source. One of the required fields is the Parent Position Code for each position. When n…Vishal Purohit 10 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 312 views 4 comments 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for HCM
-
Annualized Full Time Salary not in Compensation TablesSummary: Looking for a workaround for CMP_SALARY table not reflecting the actual salary information ()Doc ID 2403581.1) Content (please ensure you mask any confidential …Joe Dorrian 81 views 5 comments 1 point Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM -
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…Saher 82 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM
-
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh…Valerio Curzi 5 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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…
-
Select query to fetch the PO header detailsSummary: We have a requirement to create a report to show the PO header details Content (please ensure you mask any confidential information): We have a requirement were…Mamdouh Ahmed 20 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 121 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
Getting Invalid format excel format requested error using RTF templateSummary: Getting Invalid format excel format requested error using RTF template Content (please ensure you mask any confidential information): Hi, I have a report that I…Pritam Das 21 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl… -
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 1.3K views 20 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
How to fetch the calculation card association details TRU for a specific assignmentSummary: I am currently working on fetching the TRU for Tax withholding calculation card. The calculation card has association and association details. It uses US taxati…