Category 67
Discussion List
-
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 19 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 1 view 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 1 view 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…
-
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 5 views 0 comments 0 points Started by Chinnamsetti Satyanarayana Swamy BI Publisher Learning Center
-
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 1 view 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 11 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…
-
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 27 views 0 comments 0 points Started by Gavindu Saranga BI Publisher Learning Center
-
Custom Recruiting Report Using Message TemplateGood Day Experts, Is it possible to create a custom recruiting report using OTBI or BI Publisher to extract 'Start Date Change Request' message template in Oracle fusion…
-
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 -
How to Burst Email and FTP Output Delivery from the Same Schedule in BIP Report?I have a data model and a report in BIP, and there is a requirement to distribute the report output both by email to HR representatives and also to store the output on a…JayeshKori-Oracle 18 views 2 comments 2 points Most recent by Ketan Janva-Oracle BI Publisher Learning Center
-
How to Trigger 'Send to Fixed Email' for an Integrated Report in a Dashboard Using Action LinksHello, We are trying to automate a dashboard that contains a report (prompted by an OpportunityID) to be sent to our automation server, for example, via a button. Unfort…
-
Oracle Fusion Publisher - How to design a template with merged cells and recurring rowsHi Community, I am trying to develop a excel template report for my client with Oracle Fusion Publisher. This report composes of multiple tables with recurring rows at t…
-
Generate multiple Excel sheets based on parameter valueHi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel outpu…Sonia Choudhary 13 views 0 comments 0 points Started by Sonia Choudhary BI Publisher Learning Center