Category 129
Discussion List
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…VasanthaFusion90 13 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Creating a Headerless CSV File Using eText TemplateSummary: We are planning to develop a report in BI Publisher that generates a CSV file without column headers. Our understanding is that in order to exclude the header, …Jimin Park 42 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use number format of process options of ess job in the BI publisher concerned ?Hi, how to format amounts of my custom BI Publisher depending on Number Format of my custom ESS job (defined for this custom report), submitted to Scheduled Processes ?LaurentDup 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
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 204 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 12 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Set up IP Restrictions for FDI instancesHello All, Is there any documentation out there on how to restrict network access to Oracle Financial Data Intelligence URL's through IP restricting? I cant seem to find…
-
how to load jobrequisitions.dat with minimal mandatory fields onlySummary: I went through the below documentation before i started doing a basic load of open job requisitions, as part of our data migration requirements: " Examples of L…Subhadeep2 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
In OTBI unable to filter the trxs with 0 adjustments and with the status of approvedWhile creating an OTBI report, When we take the source criteria as Adjustment status we aren't able to filter out only the approved ones along with the transactions whic…Surbhi_1-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
When clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp ChangedWhen clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp Changed Is this normal functionality? How can we revert this?PhillipJ 1 view 1 comment 0 points 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 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
how to extract data from a PVO using BICCCI need to extract data from FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderExtractPVO to a file or at least to query this table. ( I need to do a count over a column to …
-
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 31 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
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 21 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 1.8K views 2 comments 4 points Most recent by MarkS 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 31 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 82 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
-
customizing payables dashboard/Invoices requiring my attentionSummary: How do I customize the build-in dashboards, eg. Payables Dashboard? Content (required): I have a requirement to customize this dashboard: The only thing that I …Anders W. Langholm 331 views 3 comments 0 points Most recent by NikitaLarson Reporting and Analytics for ERP -
how to see when a role was deleted from a user?Summary: how to see when a role was deleted from a user? Content (please ensure you mask any confidential information): how to see when a role was deleted from a user? a… -
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…
-
DFF causes error in joint GL and SL subject area analysis in OTBIReposting this question using my corporate ID as I am still having the same issue. I created a joint subject area analysis for General Ledger Journals and Subledger Acco…Walter L Gess 41 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP