SQL
Discussion List
-
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 3 views 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 21 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… -
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.…PriyaPenugonda-SC 101 views 2 comments 0 points Most recent by Marilyn O Reporting and Analytics for HCM -
BIP report to get the approval status with history and attachments for Leave encashment, salary trasSummary: Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for DOR requests like Leave encashment, salary transfer lett…
-
Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or TablesSummary: Hi There, looking for Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or Tables Content (please ensure you mask any confide…Sai Raja Kanneboina 1 view 0 comments 0 points Started by Sai Raja Kanneboina Reporting and Analytics for HCM
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.5K views 11 comments 0 points Most recent by ValentinaG-Oracle Reporting and Analytics for HCM
-
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 621 views 5 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 91 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 201 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 362 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM
-
Scheduling in HCM ExtractWe have the following requirement for the extract and would like to seek inputs on feasibility and the recommended solution approach. Requirement: The extract XX needs t…
-
How to bring the value from Previous schedule in HCM ExtractTeam, We have scheduled an extract where the Union Name parameter has a default constant value of CUPE. During the first scheduled run, we manually selected NBUPPE. Howe…
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
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 …
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 1 view 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
How to pass person id from redwood page to Value setSummary: How to pass person id from redwood page to Value set Content (please ensure you mask any confidential information): Hi all, We created a value set to fetch late…MSQamar 11 views 5 comments 0 points Most recent by Vasanthakumar Ravi 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…
-
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed… -
sql to fetch payroll process having ui_task_status = 'COR_FLOWS'Summary: Parameter having p_start_date , p_end_date, p_payroll_name based on this parameter will identify period name and start_date and end_date from pay_period table. …Ankush Jadhav -Oracle 1 view 0 comments 0 points Started by Ankush Jadhav -Oracle Reporting and Analytics for HCM -
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 21K views 22 comments 11 points Most recent by Michael E Reporting and Analytics for HCM
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b…Consultant Ian 1 view 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…usr_a.nv 171 views 19 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …User_2025-01-30-23-59-27-880 1.7K views 12 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM