SQL
Discussion List
-
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…
-
per_personSummary: We could see lot of system users are exists in oracle fusion. We would like to build a report to identify only the actual users in oracle fusion. FUSION_APPS_AM…Alexander W 41 views 10 comments 0 points Most recent by Alexander W 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…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
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 398 views 6 comments 0 points Most recent by Derrick Ellis Reporting and Analytics for HCM -
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err… -
Sql query to get reporting unit hcm information data - tax reporting unit -French Establishment InfoSummary: Hello, We need to extract data in BIP for the reporting unit hcm information data - tax reporting unit -French Establishment Info. Does anyone have more details…Stanciu Maria 31 views 7 comments 0 points Most recent by UchihaItachi Reporting and Analytics for HCM
-
Accrual Plan Balance value for the future dateSummary: We are trying to fetch the accrual Plan Balance value for the future date records. Content (please ensure you mask any confidential information): As of now, we …ViswanadhK 41 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
BIP Bursting Email Delivery Failing - SMTP_FROM Missing Required Property in Oracle Fusion CloudSummary: I have set up a BIP bursting report in Oracle Fusion Cloud (SCM/Inventory Management) to deliver personalized Excel reports to multiple email recipients based o… -
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
Supplier master Alias name tableSummary: Need a query to get the Supplier master Alias name Content (please ensure you mask any confidential information): Hi, we are maintaining some naming conversion …Mamdouh Ahmed 11 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr… -
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…Sai Revanth 641 views 7 comments 0 points Most recent by Anirudh Baranwal Reporting and Analytics for SCM
-
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 106 views 10 comments 0 points Most recent by KellyHickman1423 Reporting and Analytics for HCM
-
Sickness balances by proration periodSummary: I am trying to export the person number, minimum date and maximum date for all staff who between September 24 and March 26 had received "Statutory Sick Pay" whi…Kameron Withak 11 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 61 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…Amit Baghel 11 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Need Guidance/References: Reporting Post-Approval Timecard Edits in OTLSummary: Hello Everyone, We have a requirement to build an OTL BI report that captures post approval timecard edits. Specifically, when an employee updates a timecard af…tejaswi kilaru 1 view 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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…
-
Query to get Languages in ORCSummary: Based on the screenshot I provided, What table in HCM can I get the list of values for the Languages in ORC. Content (please ensure you mask any confidential in…
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C…MHanif 81 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 376 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM
-
Query to get all the defined UOMSummary: Query to get the UOM that we've defined in our application. Content (please ensure you mask any confidential information): Hello, We need to have a query to get…Mamdouh Ahmed 11 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Link learning evaluation questionnaire to learning assignment in Bi publisherHello, I have a requirement in BI Publisher in wich I need to extract the answer of a specific question from the offering evaluation (in learning) My base is that, howev…Sara Suleiman 11 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS…
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.8K views 7 comments 2 points Most recent by Shubham Kadam Reporting and Analytics for HCM