Category 129
Discussion List
-
How to give Unarchive option in Custom folder which is read only for a user in BI Catalog?Summary: We have a custom role which gives read only access to the Shared Folders > Custom folder. We also want to provide Unarchive access under the Custom folder. The …Bishal Dutta 33 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
performance issue in transaction listing reportSummary: I am trying to optimize the performance of GL transaction listing report. It is taking longer time to load the report & after 30 mins it is getting failed while…Abhijeet Tamoli 110 views 6 comments 0 points Most recent by emmamccrory Reporting and Analytics for ERP -
How to split the selected areas of the BIP Excel sheet into different sheets according to numberSummary: Is there a way to split the selected areas of the BIP Excel template sheet into edifferent sheets according to number? Content: Hi, we are trying to build BIPub…M Watanabe 81 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 29 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Request for Information on Managing Budget Versions Approver details in fusion TablesSummary: I am currently working on a requirement to display the approver's name and the submitted person’s name for budget versions in our Grant Management system. Howev…Chetan Yeola 7 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to Display Date and Time as per User Preference in Excel TemplateSummary: Not getting data as per the user general Date Format/Timezone preference in EXCEL template for BIP report Template build in RTF, is working fine as per User Pre…sudipta.mandal 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
incorrect result when calculated measure by multiplying 2 columnsSummary: multipying revenue amount with ledger amount is giving incorrect results Content (please ensure you mask any confidential information): External Revenue Amount …mathew060581 5 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi…Abhilash K - Deloitte USI 18 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
FTP Files of BI Publisher Report Via Bursting > Defining The Bursting QuerySummary: FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query Content (required): Hello All, We would like to send a report generated in CSV forma…
-
Project List Details OTBI report not showing any DataSummary: Project List Details OTBI report not showing any Data. Custom role is configured with all the below required duty roles Project Performance Reporting Transactio…Rohit Kumar Singh 49 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create View Image in AP invoice pageSummary: How to create View Image in AP invoice page Content (please ensure you mask any confidential information): Hi All, We got a requirement to create one button and…Venkatesan 16 views 1 comment 1 point Most recent by Venkatesan Payables, Payments & Cash Management
-
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based…
-
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…
-
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …Vipul_vipul 7.5K views 12 comments 1 point Most recent by Alexandru Dicu-Oracle Reporting and Analytics for ERP
-
Where to get the file size of Work Order AttachmentI have created this query to pull the attachments for Work Order, I need to get the file size for each attachment. Is the object_size the right column to use to know the…
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 20 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Cannot find GL_JE_LINE table when trying to create Data Model for BIP. "SELECT * FROM GL_JE_LINE"When I try to run this sql in a data model it says the record does not exist, but I'm positive it does. Any ideas why we can't select from it? SELECT * FROM GL_JE_LINEWilliam Jordan 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…Krishan_Palihakkara 128 views 1 comment 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for ERP
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 119 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP
-
Is it possible to edit and add column in Manage Invoice report on Fusion screen?Summary: Is it possible to edit and add column in Manage Invoice report on Fusion screen? User want to add one column in the output report from Manage Invoice. Content (…
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 368 views 2 comments 1 point Most recent by User_0P0CT Reporting and Analytics for ERP
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 221 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Deep link for Journals to view Journal Entry ScreenSummary: Hi Team, Need some details about the Deep link for Journals to view the Journal. In BIP report on Journal Batch Name column , respective journals can be opened …
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 49 views 3 comments 0 points Most recent by Toyesh Patra Reporting and Analytics for ERP
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 86 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP
-
Error for some user when opening Customer AccountHello, I am encountering an issue when accessing a customer account in Receivables. Steps performed: Navigate to Receivables > Billing > Manage Customers Search for the …
-
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…Jahnavi Konduru 35 views 4 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 19 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Need Information on Parameters for AP_TRIAL_BAL_REPORT_PKG.BEFORE_REPORTWe are using a customized version of the Payables Trial Balance Report to pull one specific account via custom parameter on the data model. We would like to add another …User_2025-07-18-08-13-53-790 153 views 3 comments 0 points Most recent by User_ZLZWZ Reporting and Analytics for ERP