BI Publisher
Discussion List
-
query to fetch educational details.query to fetch educational details. -
Department Costing Information related PVOSummary: We have a datawarehouse where we are pushing most of the HCM data using BIACM using the standard PVO. We couldnt find any PVO for department costing. I have gon…Sahil Kathuria 4 views 0 comments 0 points Started by Sahil Kathuria Reporting and Analytics for HCM -
How to provide the correct Return Value from the List of Value query in the BIP Data ModelSummary: I have this BIP Data model which extracts the pending approval of a certain user. This used to work before but now I am getting this error "Invalid parameters r…Boying 31 views 11 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 11 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 16 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle Fusion BI Publisher - RTF - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage… -
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >…
-
Query to fetch candidate personal email address and personal phone numberHello Team, Please provide SQL query to fetch candidate's personal email address and personal phone number. These details should be taken from candidate info/candidate t…Ooha Pranathi Akkala 76 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…Alpesh Sanghvi 3 views 0 comments 0 points Started by Alpesh Sanghvi Reporting and Analytics for HCM
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
Looking for Table for Issue Description & Resolution in Transaction ConsoleSummary: Hi Team, I am looking for the table which store the 'Issue Description' & 'Resolution' details captures. I have tried in this table "HRC_CONSOLE_FAULT_DETAILS_V…Mohan Murali P-Oracle 267 views 13 comments 0 points Most recent by Venkat5678 Reporting and Analytics for HCM
-
BIP Output file is not moving to FTP ServerSummary: BIP Output file is not moving to FTP Server Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that the file SF…Parag Hiremath 85 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden…
-
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…
-
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to…
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 4K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 11 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it…Stefano_Mazzocca 11 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 109 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Export to XLSX and avoid limitation for 65k rowsSummary: Content (please ensure you mask any confidential information): Hi there, I use Learning reports in Fusion. When I export a BI report that has more than 65K rows…Bobby Jourdan 102 views 12 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sivaram Injeti 22 views 3 comments 0 points Most recent by Sivaram Injeti Reporting and Analytics for HCM
-
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …Ruzwan Akram 456 views 10 comments 0 points Most recent by John Guner Reporting and Analytics for HCM
-
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid…Matheus Roberto 21 views 0 comments 1 point Started by Matheus Roberto Reporting and Analytics for HCM -
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…
-
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…