SQL
Discussion List
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheethttps://us.v-cdn.net/6034893/uploads/XTAY0TAIX14K/rel13-24-x-bicc-hcm-database-mapping-with-viewobjects-xlsx.zip Summary This posting includes R13 HCM BI Cloud Adapter B…Rashmi M-Oracle 21.4K views 23 comments 11 points Most recent by Jae.L Reporting and Analytics for HCM -
Customize the Organization Chart ReportSummary: Hi All, Can you please helps us with any Sample BI or OTBI Report for Employee Organization Chart Content (please ensure you mask any confidential information):…Vamsi Jeela 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle 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 …
-
Participant feedback questionnaire reportContent Hi, I am not able to pull a report for participant feedback questionnaire. Can someone help? Regards, Nivya Version 19C -
I'm trying to write a SQL that will show SIT withheld by stateSummary: I'm trying to write a SQL that will show SIT withheld by state so I can find out which legislative updates will affect our employees. Content (please ensure you…
-
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… -
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …User_Z7BKU 273 views 6 comments 0 points Most recent by Lucas B Maciel Reporting and Analytics for HCM
-
Select BIP Query to Fetch the Requisition DetailsSummary: PL/SQL Select Query to Fetch the Requisition Details in Oracle Self Service Procurement Content (please ensure you mask any confidential information): We have a…Mamdouh Ahmed 12 views 3 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 171 views 2 comments 0 points Most recent by Dineshkumar.A-Oracle Reporting and Analytics for SCM
-
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: …Welsey 4.4K views 6 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…User_IYN7Q 884 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Query to fetch the item wise lots with the on-hand per subinventorySummary: Request to have a select query to fetch the item wise lots with the on-hand per subinventory Content (please ensure you mask any confidential information): We h…Mamdouh Ahmed 22 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
default List of values based on login user in BI ReportSummary: I am trying to Default Division in List of values based on user login, is it possible?? If I login as someone from Operations, I want only Operations Division t…SAI KOMATIREDDY 13 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a…George Chernikov 83 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 1 view 0 comments 0 points Started by Vasanthakumar Ravi 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 …
-
How to fetch Burden Cost Burden Cost Code (Oracle Project Costing) — tables/SQL?Hi All, We’re trying to fetch burden cost details along with the burden cost code in Oracle Project Costing. Environment (please confirm) Product: Oracle Fusion Cloud: 2…
-
Dynamic Hyperlink/deeplink that is more user friendlySummary: I am looking to insert a dynamic hyperlink/deeplink that is more user friendly. The current URL at the bottom of the email is very long and not user friendly at…Consultant Ian 12 views 4 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 213 views 6 comments 0 points Most recent by lbodeddula Reporting and Analytics for HCM -
There is time delay to display requested absence information in the tables.Summary: There is time delay to display requested absence information in the tables ‘ANC_PER_ABS_ENTRIES’ and ‘FND_BPM_TASK_B’, Is there any other tables can be used to …AntonyD 1 view 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.4K views 9 comments 4 points Most recent by PranjulG Reporting and Analytics for SCM -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
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.1K views 17 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
Report Query to Determine Subject Area UsageSummary: With the 26A release, the Workforce Management - Vacancy Real Time subject area is being discontinued. Is there a query that can be run in OTBI that will provid…Nick Henderson 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t…Valerio Curzi 41 views 2 comments 1 point Most recent by Diane Stuart Reporting and Analytics for HCM -
Retrieve User ListSummary: I would like to create a BIP report to retrieve a list of user information. Content (please ensure you mask any confidential information): Please let me know wh…higuchi 24 views 8 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
How to pass custom BI Publisher parameters (p_start_date, p_end_date) from HCM Extract than and HDLSummary: Hi everyone, We have a requirement to run a parameterized BI Publisher (BIP) report from an HCM Extract and then auto‑load the generated HDL file. The report us…