BI Publisher
Discussion List
-
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 283 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i…
-
How to check Memory Used Information for ReportSummary: We would do an enhancement for reducing the 'Memory Used' and 'Memory Read' for one BI report. However, we do not khow how to get 'Memory Used' and 'Memory Read…Abby Chen522 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Line breaks in RTF template with Excel outputSummary: I have a report with two datasets. The first dataset is joined to the second dataset in the data model designer. The report used is an RTF template, and when ex…Ayala01 29 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Need a table for Payment Document Category in Manage Bank account setupSummary: Hi Team, We need a table where the information of "Payment Document Category" meaning stored. There is a column PAYMENT_DOC_CATEGORY in CE_PAYMENT_DOCUMENTS but…
-
How to get Column headings to repeat across multiple pagesSummary: How to get Column headings to repeat across multiple pages Content (please ensure you mask any confidential information): Hello all - I am struggling to setup m…KDR 35 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Expense Approval Report - how to show stops in between destinationSummary: Content (please ensure you mask any confidential information): Hi all, I have been trying to modify the seeded Expense Approval Report by adding any stops taken… -
Restricting BIP Data Model to signed in userSummary: Trying to use the data model to restrict the signed in user to only their information in projects. I'm trying to do this so that project managers when the open …
-
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
BIP Security - Need to restrict user from deleting the Folders from Shared FoldersSummary: Hello All We would like to restrict the users from deleting the folders from shared folders and user should be able to run and schedule the reports and data mod…ROHIT NAYAK_120 24 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen…SushmaMeesala006 35 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need a table or query to get Latest open period column in Manage Intercompany Period StatusSummary: Hi Support, We need a table for the column's "Latest open period" and "Open Transactions" under the setup Manage Intercompany Period Status. We have the table F…
-
BIP Bursting report failsSummary: Creating a report that will be emailed (bursting) to employees that have outstanding PCard charges that need to be added to a report for reconciliation. The rep…Kaz Myskiw 94 views 9 comments 0 points Most recent by Cosmin Foslea Reporting and Analytics for ERP
-
Exist a report that show all page composer in the ERP?Exist a report that show all page composer in the ERP?Cristian Gonzalez S 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is…
-
Is there any way to send UCM file to email/sftp though bursting ?Hi All, I would like to send the attachment of negotiation messages to others. I can get the document id of the attachment( non-pdf) in UCM, Is there any way to send the…
-
Blank pages in my BIP ReportSummary: Student Statements with 0 balances printing blank page Content (please ensure you mask any confidential information): I have developed a custom student statemen…
-
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…Daniel Martin-Oracle 1 view 1 comment 0 points Most recent by Daniel Martin-Oracle Reporting and Analytics for ERP
-
How to change newline characters in BIP reportI have created a BIP report using RTF template. When exporting the report to CSV, the newline character is line feed, but I want to make it carriage return and line feed…
-
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss Added Font Ma…
-
Required interface tables for the below tasksSummary: Hiteam, We are unable to find interface tables for the following tasks, we gone through the oracle docs but we could not find the below tasks interface tables. …Opkey PA 21 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Feasibility Check and Help for a OTBI ReportSummary: I am creating a new OTBI Dashboard for the Payroll Reconcillation Details. The Dashboard will have multiple sections including 2 waterfall charts and once pivot…VaibhavChavan20_ 2 views 0 comments 0 points Started by VaibhavChavan20_ Payroll and Global Payroll Interface (GPI)
-
Download Excel template BIP Report using SOAP Web ServicesSummary: We are currently using the following two web services to schedule and download BIP reports: soapWsdlUrlSchedule: https://{instance-name}.oraclecloud.com/xmlpser… -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Excel template with multiple sheets in outputSummary: I require my excel template to push out multiple sheets. One for each business unit with underlying customer transactional data per business unit sheet. Content…Chez 237 views 10 comments 1 point Most recent by Ankur Jain--Oracle Reporting and Analytics for ERP
-
RTF Template with multiple sheetsSummary: RTF Template must push out results in Excel with mutiple sheets Content (please ensure you mask any confidential information): I have put in place a rtf templat…Chez 517 views 4 comments 0 points Most recent by Ankur Jain--Oracle Reporting and Analytics for ERP