BI Publisher
Discussion List
-
Need to find a Learning OTBI subject Area for Audience Occurrence ColumnSummary: Hi Team, I need the assistance to get the "audience occurrence" column in Learning OTBI subject Area. we have tried the below subject areas but we are unable to… -
The Payee Email Address is always appearing as blank in the OTBI report for onetime PaymentOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): We would like…NarasimhaPalla 1 view 0 comments 1 point Most recent by NarasimhaPalla Payables, Payments & Cash Management
-
BI Publisher Report - Prompt IssueSummary The drop down list for selecting criteria will not wipe cleanContent Hi, Everytime someone opens this report the Business Unit, Package Type, Legal Entity and Lo…User_2025-02-05-22-44-35-842 26 views 7 comments 0 points Most recent by Stacey Williams Reporting and Analytics for HCM -
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but…
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 35 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.6K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Child data groups XML tags are not generating in HCM Extract while email burstingSummary: We are using HCM Extract and created a BIP report to place the report in DOR and Email bursting. Now when we run the extract, the extract xml is generating data…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…Kristy Fung 32 views 5 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Printing Checks from Oracle Cloud SaaS to Local Internal PrintersFrom a Network Architecture standpoint, I have the following questions regarding Oracle Fusion check printing: Essentially, we are trying to eliminate the need to expose…ChrisN-EFX 74 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
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
-
How to get delivery status of each bursting file of BIP report using Sql QueryHow to get delivery status of each bursting file of BIP report using Sql QueryPrafulla_Chaskar 4 views 1 comment 0 points Most recent by Luca Campelli Payables, Payments & Cash Management
-
ZATCA verified XML embedded inside PDF/A3Summary: We have a requirement to generate the invoice output in PDF/A-3 format. Specifically, we need to embed a ZATCA verified XML file (generated from another report)…Shatha Bin-Nooh 30 views 0 comments 0 points Most recent by Shatha Bin-Nooh Receivables & Collections -
Is there a way to restrict an access provided by previous role using another roleSummary: Is there a way to restrict any user from accessing below even if they have somehow access to below features: 1. Data Exchange 2. Tools - > Transaction Console ,…
-
Exclude 0 amount tax boxes from tax box allocation (e.g. cancelled tax lines or invoices) and xml ouContent Hi everyone, I am finishing implementation of JPK (Polish SAFT file) in our instance. Allocations and rules work perfectly with one exception. We should not repo…
-
Get the description of a value in a valueset using HCM ExtractSummary: Hi, I need to extract the field description from the value set for each value and I need to insert the description as an attribute in the HCM extract Content (p…
-
Is Reginal information for Mexico field stored in GL_INTERFACE Table?Summary: We have a requirement to upload journal lines under Reginal information for Mexico with UUID but we are unable find the exact column from GL interface, Is there…Sreenivasulu Donka 81 views 3 comments 0 points Most recent by martingabriel Kinovisques General Ledger & Intercompany
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…User_2025-12-05-01-24-53-219 17 views 3 comments 0 points Most recent by Vinith Kumar P V Reporting and Analytics for HCM
-
Hide Disable Actions Menu in BI Publisher Report or Hide Export and Schedule buttonSummary: I want to hide Action menu in BI Publisher Report or want to hide Export and Schedule button. Only need online view. Is there any way to do this ? Version (incl…
-
Download External certificateSummary: Dear Expert, Is there any way to download the non-catalog item certificate for a user via the BIP report? Content (please ensure you mask any confidential infor… -
How to enter a different date as the Value Date in Payment FileSummary: I have a requirement where I have to generate the payment in Oracle Fusion Payables AP on 2/15/2026 but I want to send the Value Date to the Bank as 2/17/2026. …Srinivasan1 1 view 0 comments 0 points Most recent by Srinivasan1 Payables, Payments & Cash Management
-
What are the limitations for BI Published reports?Summary: What are the limitations for BI Published reports? Content (please ensure you mask any confidential information): What is the maximum number of rows I can expor…Max Prestes 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…Opkey PA 11 views 1 comment 0 points Most recent by Kunwar Singh-Oracle Recruiting, Opportunity Marketplace
-
Custom template is not reflected in ap invoice approval notificationSummary: Custom template is not reflected in ap invoice approval notification Content (please ensure you mask any confidential information): We've customized the AP invo…VenkatesanR-Oracle 65 views 3 comments 0 points Most recent by VenkatesanR-Oracle Reporting and Analytics for ERP
-
For recording External Learning, we intend to create a BI Publisher (BIP) reportSummary: Hi Team, For recording External Learning, we intend to create a BI Publisher (BIP) report that displays employee details along with the approver information and…
-
Enabling Pay Group in Payment File - 23A FeatureSummary: Reviewing some earlier What's New Features - I came across this in 23A: VAT PAYMENT IN LOCAL CURRENCY FOR POLAND FOREIGN CURRENCY INVOICES As part of this - I n…AllenN 197 views 4 comments 0 points Most recent by Anjali Jain Payables, Payments & Cash Management
-
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens…
-
Extend OTBI Agent Extract Maximum Rows for Excel FormatSummary Extend OTBI Agent Extract Maximum Rows for Excel FormatContent We recently implemented OTBI Agents that delivers extracts from an analysis that captures data wit…User_2025-02-07-20-17-33-726 246 views 10 comments 1 point Most recent by Max Prestes Reporting & Analytics for Sales
-
Can you please investigate why we cannot use the permissions against folders in OTBI ?Summary Why we cannot use the permissions against folders in OTBI ? what happens now is: when we got enough access, we can set up a specific permission at a certain leve…Aarti Karale 2 views 0 comments 0 points Most recent by Aarti Karale Reporting and Analytics for ERP