BI Publisher
Discussion List
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la… -
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
Reporting the candidate offer transaction approval attachmentsSummary: Reporting the candidate offer transaction approval attachments Content (please ensure you mask any confidential information): Hi All, Greetings! This is about t…Parag Hiremath 25 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
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 36 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Display a Document of Records Image in a BIP ReportSummary: Hi All We have a requirement to display photos stored in Documents of Record within a BI Publisher (BIP) report. Has anyone implemented this before or can provi…
-
Physical inventory in Oracle Fusion Fixed Assets - underlying tables and purge behaviourHi all, We are currently developing a custom BI Publisher report in Oracle Fusion Cloud Fixed Assets (Release 26C) that consolidates physical asset verification results …
-
JPMISO20022CGIV2 template is not available in Fusion, Any idea on how to generate the sameSummary: We are not able view JPMISO20022CGIV2 template Content (please ensure you mask any confidential information): We are unable to find JPMISO20022CGIV2 template in…
-
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…
-
how to create ARCS report smoothly using EPM toolSummary: I want to create a report for the below requirement. Do we have any tool in EPM so that it can be created easily rather than creating report in BIP Analytics? I…Debasmita Adak 22 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections
-
how to create a bip report in ARCS/EPM easilySummary: A custom BI Publisher report needs to be developed, data model, or approved extract/integration is required. Oracle Fusion does not provide one standard XLA fie…Debasmita Adak 45 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections
-
How to add Intermediary Bank account field for Customized ISO20022 Payment FormatSummary: Hello, We need a customized ISO20022 Payment format with the intermediary bank account fields. I followed the doc ID How To Add Intermediary Bank Fields for Cus…Mariam Lefranc 162 views 7 comments 0 points Most recent by TM_18 Payables, Payments & Cash Management -
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…AS_Cons 56 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Bulk report to identify users and roles with access to custom BI Publisher reports.We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and…Sawan Choudhary 61 views 0 comments 1 point Started by Sawan Choudhary Reporting and Analytics for ERP
-
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… -
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 43 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 created custom offerings and added PVOs in that custom offerings. BICC Job is created and the source is the PVOs with in that custom offerings. Now the…
-
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 107 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 294 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 528 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 74 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 1K views 7 comments 0 points Most recent by PhilippeTawk 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 … -
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…