BI Publisher
Discussion List
-
Report for supplier invoice with address not pullingWe are developing a supplier invoice report BIP report using the below listed tables. Admin users are able to get the data, but the end user with access to just this BIP… -
Need help to modify SQL to retrieve the journal approver field pleaseSummary: I am trying to update the GL Ledger script to include the following additional fields Journal Approver name beginning and closing GL account balances for the se… -
Is it possible to generate a list of Oracle Fusion users and the method they use for authenticationSummary: Is it possible to generate a list of Oracle Fusion users and the method they use for authentication (SSO or Local authentication)? Content (required): Is there …snagavarapu 51 views 1 comment 1 point Most recent by EGISEDGE TECHNOLOGIES PRIVATE LIMITED Reporting and Analytics for ERP -
How to convert date to Thai and Buddhist era in Custom BIP Report.Summary: Convert date to Thai and Buddhist era in Custom BIP Report. Content (please ensure you mask any confidential information): We have requirement to show dates in … -
Difference between Ess Job Derived attributes and AttributesSummary: Content (please ensure you mask any confidential information): We are creating Custom ESS job for one custom report requirement. We need know, what is the real-… -
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re… -
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 97 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP -
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …Thanigainathan R 593 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP -
Purchase Order PDF Using Sub TemplatesSummary: We have multiple entities and developed a custom data model and appropriate custom purchase order PDF's. All working fine for PdfDraft and PdfArchive sections. … -
Max columns display in BIP dynamicallySummary: Hello, We have a requirement to display more columns dynamically in BIP, would like to know any limitations in MAX columns display. If not, please suggest us. T… -
Parameter getting defaulted automatically - BI publisherSummary: When I run a report, one of the parameters is unusable because, after I select one value, it gets defaulted to "All" The data model works fine before running th… -
BI report cannot be restricted with data access setSummary: A user without a data access set(where only ledger A is attached) is able to select ledger A as the report's parameter, and view its data as well. (the user is … -
BI Report Migration Not Captured in Audit LogSummary: We have noticed that some of the custom BI report and data model migrations are not captured in the audit log. The same functionality is working for the same us…Divya Sidhaiyan 22 views 6 comments 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to convert Customer TRX ID into textHi Team, We have developed Invoice Extract report and the output is in the CSV format. In the report having the column as Customer trx id which is the length of 8/9numbe… -
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 3 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
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 391 views 4 comments 0 points Most recent by HARSH0891 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…User_2025-01-25-04-31-49-957 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 71 views 1 comment 1 point Most recent by James McBride Reporting and Analytics for ERP -
Receivable Invoice Report returns nullHi, When I ran the query it returns no rowsMohammed Rafi 31 views 7 comments 1 point 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 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 41 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… -
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 131 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 111 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 41 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 41 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