BI Publisher
Discussion List
-
AP check template MICR Font is showing as square boxesSummary: I am working one of the Saas Customer and trying to customize the AP check template. Existing custom template was build by Solution Implementation team is worki…Madhan Sanjeevi-Oracle 2 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?Summary: We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can …
-
Query to identify BPA changesSummary: Query to identify BPA changes Content (please ensure you mask any confidential information): I am building a query to identify BPA's that have had their UNIT_PR…
-
How to convert the “Amount in words to be changed to Millions and hundreds?We need to get the “Amount in words to be changed to Millions and hundreds instead of Crores and Thousands for all non INR invoices.
-
Adding a parameter to custom data model of a seeded reportSummary: We need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gi…Ashu Raj-Oracle 321 views 4 comments 0 points Most recent by User_ZR4R1 Reporting and Analytics for ERP -
Render images in BI Publisher PDF outputSummary BI Publisher: how to render images residing on UCM (represented by URL) in BI Publisher PDF outputContent We have a requirement wherein we need to render the ima…ManiShankar Choudhary 63 views 1 comment 2 points Most recent by Poh Chie Reporting and Analytics for ERP
-
GL Detail Report w/ Subledger DetailsSummary: Finalize/Tweak built custom OTBI report to export the last bits of data needed by our auditors. We've built a custom OTBI report that exports GL and SLA numbers…Henry Imgrund 26 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
Receivable Invoice Report returns nullHi, When I ran the query it returns no rowsMohammed Rafi 32 views 7 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP -
Customer require to extract FRS report data in XML or SQL format. Is this possible?Hi All, Customer require to extract FRS report data in XML or SQL format. Is this possible?Janitha Perera 1 view 2 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 22 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to handle null values in BIP report param which is "text field contains comma seperated values"Summary: In BI publisher Report,I have a parameter Type enabling check box of :text field contains comma seperated values" This parameter is not mandatory so how to hand…Manjusha Poluparthi 21 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve… -
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically …Kishore S-Oracle 308 views 5 comments 3 points Most recent by Nicolas S Reporting and Analytics for ERP -
Load XML file into the dataset with xmlpserver/services or use BIP as print serverSummary: I am looking for a way to upload an XML file to a dataset that uses an XML file through the services offered by xmlpserver, but I can't find how to do it. I see…Edisson Gabriel López 44 views 3 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 101 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Encrypt File Bursted Via EmailSummary: Hi, Is there a way we can encrypt file bursted via email? File type is Excel Regards, Kay
-
Run SOAP web service from bi publisher.Summary: Hi, please I would like help with the following: I try to setup a connection as web service: I define the datamodel to use this connection: Looks good! it seems…Juan Jesus 42 views 5 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
How to add Reports and Analytics menu to Order Management Dashboard pageSummary: We have a requirement to add Reports and Analytics drop down menu with access to all reports on Order Management Home Page. Content (please ensure you mask any …Nagarjuna Nudurupati 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
oracle fusion ESS job request limits per hour.Summary: We have a requirement to run a report through ESS in Oracle SaaS application, expecting 1500 requests per hour. is oracle supports these volume? is there a way …Santhosh Mothepati 78 views 2 comments 1 point Most recent by Gerardo Carrillo Applications Security
-
IN OTBI How to display the data as per user preferred time zone and dynamically add GMT /- ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Manoj Vasa 21 views 2 comments 0 points Most recent by Kadiri Prathusha Reporting and Analytics for ERP
-
I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any…S.A.A Dinoli 21 views 5 comments 0 points Most recent by S.A.A Dinoli Reporting and Analytics for ERP -
How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte…
-
Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…Dona Das-Oracle 21 views 3 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for ERP
-
How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure …
-
"Check Digits" on a Supplier Bank Account Record in BIP SQL TABLE locationHi Guys Does anyone know please which BIP table contains the field "Check Digits" for a supplier bank account? I need to get the checkdigits field for a supplier bank ac…
-
Populating xcc_balances table - requesting more informationSummary: Hello, Our BI report which shows the budget amounts for our accounts is missing a certain account for specific periods. It looks like the period names are missi…
-
How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 12 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…Soare Oldrich Alexandru-Oracle 25 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP