Category 67
Discussion List
-
How to use SUBSTR on Clob in BI Publisher which is not an XMLI am trying to get the Report delivery information of the reports executed with Bursting from the AuditViewDB in Fusion SaaS. The delivery details are in a CLOB column w… -
Is there a limit on number of parameters that can be added to a BIP report/Data Model?Hi Team, Is there any restriction to add number of parameters in a BIP Report? Thanks, SatyaChinnamsetti Satyanarayana Swamy 9 views 1 comment 0 points Most recent by Chinnamsetti Satyanarayana Swamy BI Publisher Learning Center -
How to Create Custom PVO on Oracle Interface TablesWe have a Requirement where we want to use BICC Console to extract data for oracle Interface Error Table. Can anyone please help with Guided Steps.
-
HR Help Desk - Can CategoryHierarchy (Category Hierarchical Picker) Be Set as Required in VBS?We are looking to make our Category selection a requirement for our HR Help Desk Agents, without affecting our Employees (not required for Employees). I was wondering if… -
Is it possible to send email with multiple attachments in a single email with the bursting process ?Hi Team, We are currently working on bursting an invoice format using a BI Publisher data model and scheduling it to send invoices in PDF format via email. Currently the…Gavindu Saranga 79 views 1 comment 0 points Most recent by Sindhu Munipally BI Publisher Learning Center
-
Bi Publisher data model parameter not displaying into Bi publisher report parameterHi Team, I observed one issue in FDI Bi Publisher environment data model created with List of Values and parameter. Data model working perfectly. But when same data mode…Indranil Basak-Oracle 29 views 1 comment 0 points Most recent by AbulKhair BI Publisher Learning Center -
How to invoke rest api from Oracle BI ReportHow to invoke Rest api/webservice using BI reportShruthiPrabhuram 11 views 0 comments 0 points Started by ShruthiPrabhuram BI Publisher Learning Center
-
XML-23029: (Error) FORG0001: invalid value for cast/constructor ERROR IN BIP REPORTHi All, We are getting below error while running BIP report, while it runs successfully for some orders and gives error for 2-3 orders Can you suggest nay possible solut…
-
Need Approval Group Details in GeneralLedgerHi all, I am working on a GL Manual workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments in GL. P…
-
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se… -
Need SQL Query to Extract Seeded and Custom Audit Report DetailsHi Team, I would like to extract details for both seeded and custom audit reports in Oracle Fusion. Specifically, I’m looking for a SQL query that can provide the follow…Karthikeyan s-Oracle 63 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
ESS Job Status Shows "Error" Despite Successful Report Output in Oracle FusionHi Team, We are facing an issue in Oracle Fusion Applications where a report or ESS job scheduled via "Schedule New Process" generates the expected output file, but the …
-
Aa BIP has a data fetching limit of 2GB .What will be alternative solutions to get huge data.As we are aware, Business Intelligence Publisher (BIP) has a data fetching limit of 2GB, which can pose challenges when working with large datasets. This limitation may …
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 8 views 1 comment 0 points Most recent by Akhila.Allagadda BI Publisher Learning Center
-
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 6 views 0 comments 0 points Started by Akhila.Allagadda BI Publisher Learning Center
-
To print a table at the bottom of the page, irrespective of the space taken up by the previous tableUsing the Oracle BI Publisher add on for Microsoft word we need to print a table at the bottom of the page, irrespective of the space taken up by the rest of the data/te…
-
How to convert User Defined Table text to date in BI PublisherHello I'm trying to work with a User-Defined Table (UDT) and am running into reporting issues working with the data in BI Publisher and am looking for help. The business…
-
How can we implement SQL-based data security in a BI Publisher Data Model to restrict PII columns?We have a custom BI report which contain 5 columns of data and out of these 3 columns are related to PII(Personal Identifiable Information). These 3 fields are secured o…
-
OTBI Prompt returning wrong DataWe are creating a report in OTBI using subject area "Maintenance Management-Work order performance Real Time". Select Work Order Priority in Data as well as Prompt. In D…
-
Need to Fetch Last Updated Records in ess_request_history tableI’m building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’t find a 'last update…
-
Schedule BI Publisher report to run every first Monday based on Fiscal Month EndWe need to schedule a BI Publisher report which should be ran on every first Monday when the Fiscal Month ends. For exm : January 2025 Fiscal year starts from 12/28/2024…Lakshmi Prasanna Bandaru 11 views 1 comment 0 points Most recent by Shankar-Oracle BI Publisher Learning Center
-
BI Publisher - Obtain YTD / accumulated balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…
-
Number to name conversion of currency value in RTF templateI have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a …Manu Krishna T M 24 views 1 comment 0 points Most recent by Ravi Tilekar BI Publisher Learning Center
-
How can I build an ASL report in BI Publisher with supplier, item, and organization names?Hello, I am currently building a BI Publisher report based on the PO_APPROVED_SUPPLIER_LIST table. The report works fine when using this table alone, but I need to enric…
-
Inquiry Regarding Availability of "Go Noto" Font Installation Files in Cloud ERPMay I confirm that, as a Cloud ERP product, there is no available feature to download the installation files for the "Go Noto" font used in the PDF reports generated by …
-
FA Asset Addition and FA Asset Register reports lexical parameter and Temporary tableHi , Both of these reports use lexical parameter &l_fa_whatif_rep_t. We want to understand how this parameter value is derived. We tried to use fa_whatif_rep_t table, to…
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
Reports to get Service Usage in fusion HCMWe need reports for below: 1) Anonymized Authorized User Names by Service Details 2) Authorized User Names by Service 3) Authorized User Privileges by Service 4) Authori…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Which SQL Table store the Activity Information of Time Entry in OTL. Please share the inputs if you know