BI Publisher
Discussion List
-
Getting error ORA-00918: column ambiguously defined while adding table to seeded reportSummary: I am trying to modify the datamodel of Journal Entry Reserve Ledger - seeded report while adding this table FA_MASSADD_DISTRIBUTIONS. Content (please ensure you… -
Hide Data Models from BI Author and BI Consumer Roles - Access Impact?Summary: Content (please ensure you mask any confidential information): We want to remove the BI Author and BI Consumer roles from any folders that just contain data mod…Rory Mullin 22 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to get count in pivot table in rtf templateHow to get count in pivot table in rtf templateLakshmiVanarasi 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to have a fixed table for stub before check regardless of the number of invoicesSummary: We have a business requirement to create a custom in-house check wherein the remittance table is causing the check to shift and overflow to the 2nd page. We nee…slopez 21 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Any one has idea on Pivot table in rtf, need some help on itAny one has idea on Pivot table in rtf, need some help on it. It is allowing only 5 columns, can we extend it more than 5 columns and also grouping data , need it to be …LakshmiVanarasi 3 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
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 11 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 101 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 61 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 11 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 1 view 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 11 views 1 comment 1 point 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…
-
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 11 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…
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 11 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
-
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 51 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP
-
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 164 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 102 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 21 views 3 comments 0 points Most recent by Toyesh Patra 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 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …Gurvinder Singh Gill 755 views 3 comments 0 points Most recent by Sravani Budde Reporting and Analytics for ERP
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 1.2K views 6 comments 1 point Most recent by RKSharma Reporting and Analytics for ERP -
How to display sysdate in an excel template. I am using an HCM Extract.Summary: I want to display the sysdate in one of the columns of an excel output. I am using an excel template. Content (please ensure you mask any confidential informati…
-
Which table has Journal Transaction details?Hi, Does anyone know where the details below can be found in the Oracle Fusion? This is inside of a Journal Transaction
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 927 views 7 comments 7 points Most recent by Marwa Reporting and Analytics for ERP -
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t…
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP