BI Publisher
Discussion List
-
Recommended properties/parameters for an image to be used in RTF template of BI PublisherHello Oracle Experts, We are working on with updating the template for PO print to add logo/images. As such, may we know if there are any recommended properties for the …marc.joed.de.guzman 23 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Nees SQL query to get the transaction status of Intercompany transactionsHi team, I'm creating a BIP report to extract intercompany transactions and related details. I need to join 'AP_INVOICES_ALL' or 'XLA_AE_LINES' table to 'FUN_TRX_HEADERS…Tharushi Sathsarani 501 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle Reporting and Analytics for ERP
-
EGP_EXPLOSIONS_V loads nothing, component tables do.Content Hi. I'm querying the view EGP_EXPLOSIONS_V and loads nothing. I queried its individual tables and DO load data: * egp_system_items_b_v * egp_structures_b B, * eg…User_2025-02-07-06-48-26-537 48 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
System Accounts from per_usersSummary How to identify system accounts like FUSION_APPS_SEARCH_APPID from per_usersContent Hi Is there a way to query and get a list of system accounts like FUSION_APPS…Manish Mohan-96908 54 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
How to Reduce Sftp Bursting completion times.Hi Team, We would like to inquire if there are any options to reduce SFTP bursting completion times. Currently, we are trying to place 10K files into an SFTP folder usin…Sravan Komminedi 21 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
INV_MATERIAL_TXNSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…RAMESH VANGA 13 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How to schedule a custom weekly GL report, which includes date parameter of "PostedDate-7"Summary: Custom GL Report which needs to run at 12:05 AM weekly on Tues night and include data only from the previous week. If PostedDate = Aug 6, the report should incl…
-
Recommended approach for data warehouse extract from Fusion FinancialsSummary: We have implemented Oracle Cloud/Fusion Payables and Procurement modules. We have built custom data models and reports to extract data from Fusion and deliver t… -
Best approach to create a report templateHi everyone, I’m seeking advice on the best approach to create a report template with the following requirements (Bi Pulisher report): Year-to-Date (YTD) totals Subtotal…Omran Zeaiter 21 views 2 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP
-
ERP Sofware Version and NameSummary: I need to include the ERP application name and version in a custom report. Does anyone know if this information can be queried? Specifically, I'm looking for th…
-
Does the purpose of Cloud Collections related columns in AR Payment Schedule align with EBS R12Summary: We have a custom report running in EBS R12 that we are looking to port to erpCloud. The R12 report references columns: AR_PAYMENT_SCHEDULES_ALL.STAGED_DUNNING_L…
-
Missing Republish Button @ ESS Jobs to open outputSummary Missing Republish Button @ ESS Jobs to open outputContent * Should be able to view the output of Jobs run from SOA user as jobs are scheduled from SOA User.For a…Senthilrajan V 117 views 8 comments 1 point Most recent by Grant Abbondanza Reporting and Analytics for ERP -
Incrimental logic for fetching the data in Custom report is not working as expectedSummary: Hi Team, We have a custom BI report which fetches Customer Invoices related columns. The ESS job for this report is scheduled to run every 15 minutes. The repor…
-
job which populates invoices into the fixed asset moduleSummary: Would like to know which job populates invoice data into the fixed asset module. Content (please ensure you mask any confidential information): We're missing so…
-
Connection to SFTP is failing from BI ServerSummary: Hi Team, The BI Server connection to SFTP is failing with error "Could not establish connection. java.net.ConnectException: Connection timed out (Connection tim…Nidhi Chhajed 93 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…
-
printer setupSummary: Questions regarding printer setup Content (required): Hi team, Kindly clarify below points. *BI Publisher >Administration>Manage Publisher>Delivery>Printer>Add …BhargavC 42 views 2 comments 0 points Most recent by Priyanka Girdhar Reporting and Analytics for ERP
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered errorSummary: Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : I have full ownership of the folder that i'm trying to copy the shortcut : Plea…Shashidhar Goud 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 194 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to create Account Range parameter?Summary: Standard ESS job - Supplier Balance Aging Report, has a parameter 'Account Range'. How to define the parameter for a custom ESS job? Content (required): Standar…
-
Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda… -
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 552 views 12 comments 14 points Most recent by Jose Carlos Amaral Flinco Financial Management Resource Center -
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 129 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP
-
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer…Vinay Gharge 194 views 2 comments 0 points Most recent by Praveen Gollu-Oracle Reporting and Analytics for ERP
-
Unable to generate consolidated output for Create Customer Statement Report.Summary: We have a requirement to customize and enable consolidated output for Create Customer Statement Report. Although we have activated the feature to display consol…
-
Automating BI Catalog archivingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…G8rNtn 24 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…Srinivas B 845 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o…
-
BI Publisher report parameters do not workSummary: Requisition Header Description based parameter is not working Content (please ensure you mask any confidential information): I have created a BIP report for Req…