BI Publisher
Discussion List
-
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 126 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 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 222 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 11 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 21 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report…Koteswararao Yenikepalli 94 views 3 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 295 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP
-
Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties… -
Backend tables or SQL query to know "Manage Enterprise Scheduler Job Definitions"Summary: Hi Team, We are unable to find the tables or SQL query to get the data under the task "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, S…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 163 views 8 comments 0 points Most recent by Satyam Roy Reporting and Analytics for ERP
-
Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…Lisa D 31 views 4 comments 1 point Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP
-
Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 11 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
scheduled proccessess in Fusion: need to fetch data for 2023 yearSummary: I have a request to provide a list of all processes which were executed in the Fusion system in 2023y Cotent (please ensure you mask any confidential informatio…Ann Djiyanova 21 views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP -
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
ERP Secured ViewsSummary List of secured views to secure ERP data in BIP reportsContent Could you please let me know how can we secure data in datamodel for Financials data? We couldn't …User_2025-01-25-01-31-47-378 109 views 3 comments 1 point Most recent by Ashish_Jain -Oracle Reporting and Analytics for ERP