BI Publisher
Discussion List
-
Which HCM Extract DBI to use to fetch full state name (region2) from person address?Summary: Extract_address_region2 and address_region are giving only short forms of state. Is there any other way? Content (please ensure you mask any confidential inform… -
In BIP, when clicking on the download button in PDF output, an HTML file is downloadedSummary: The issue is when clicking on the download button in PDF output, an HTML file is downloaded instead of a PDF. Would there be any setting to set in the BIP repor… -
Query to fetch the employee assignment history.We require a report that captures the complete assignment change history for employees, along with the associated action codes, details of the attributes that were chang…
-
Role/privilege is required to retrieve Position Code from OTBI "Position Real Time" in BI Publisher?Summary: Hello Experts, I am trying to retrieve Position information from OTBI subject area Workforce Management - Position Real Time through a BI Publisher Data Model. …PavelACT 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
IEX_DUNNING : get_language_from_locale ORA-01403: no data foundSummary: Send Dunning Letters Job is giving above error Content (please ensure you mask any confidential information): Version (include the version you are using, if app…
-
BICC - Custom offerings migration Import / ExportSummary Dears, We custom offerings and PVOs in that custom offerings. BICC Job is created and the source is the PVOs with in that custom offerings. Now the concern in ho…
-
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…Opkey PA 81 views 3 comments 0 points Most recent by PhilippeTawk Recruiting, Opportunity Marketplace
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 265 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database ObjectsSummary: Hi All, We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the communit…
-
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 463 views 6 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM
-
Looking for SQL to Retrieve BI Report Job History and Deleted Job History in Oracle FusionHi everyone, I have a requirement to retrieve BI Report job history using SQL in Oracle Fusion. I also need to identify or retrieve deleted/removed BI report job history…Kanishka DIas 58 views 4 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 978 views 7 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Our SQL Query only show Account Alias Receipt TransactionsSummary: Our SQL Query only show Account Alias Receipt Transactions Content (please ensure you mask any confidential information): Hi I want to create SQL query that can…
-
BI SQL FILTERWhen I search for a code in a filter, it correctly returns two values—as shown in the query below—but when I select both, only one code appears in the list of selected v…Rosita Santosuosso 20 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Sql to get the Administrative section in Learning offeringSummary: We are struggling to identify the table name for Administrative section in Offering details page in Learning module Content (please ensure you mask any confiden…
-
Purchase Requisition Rejection Email TemplateSummary: Hello all, We are looking for the email template corresponding to the email sent to the requester when a Purchase Requisition is rejected. Could you please let … -
Is it possible / How to create BIP report output in .xlsx format?Is it possible / How to create BIP report output in .xlsx format? Currently we can only see .xls option while creating the template. Please advise.RahulMore 14 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Does oracle Fusion supports TT Payments file format for a bank in pain 001.001.03 formatSummary: We are trying to setup a new XML based pain 001.001.03 format for a bank in Fusion. However, for TT payments there are some additional tags required to clear va…
-
We need to see the detailed patch notes from the mandatory security patch that was applied on Sep 19We need to see the detailed patch notes from the mandatory security patch that was applied on Sep 19 We are having issues with the Cash Management report integration pos…Nida Syed 12 views 1 comment 0 points Most recent by Devesh Tyagi Payables, Payments & Cash Management
-
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… -
What is the field name of checklist status?Summary: Content (please ensure you mask any confidential information): Unfortunately it is not per_allocated_checklists_vl.CHECKLIST_STATUS, any other idea? Version (in…Stefano_Mazzocca 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Phone Numbers are not showing up in BI Publisher ReportSummary: Phone Numbers are not showing up in BI Publisher Report Content (please ensure you mask any confidential information): I created a custom BI Publisher report to…
-
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…Kalyan Amaravathi 253 views 15 comments 0 points Most recent by Gopinadh Vipparla Reporting and Analytics for HCM
-
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 50 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 5.9K views 10 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM
-
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 351 views 3 comments 1 point Most recent by Kalyani-Oracle Reporting and Analytics for ERP