Category 129
Discussion List
-
Connection to SFTP is failing from BI ServerSummary: Hi Team, The BI Server connection to SFTP is failing with error "Could not establish connection. java.net.ConnectException: Connection timed out (Connection tim…Nidhi Chhajed 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR reportSummary: Account Profile Conversion Rate Type field is showing Id instead of Name in OTBI AR report, it is showing name only for the seeded value i.e Corporate. P.N - We…Rahul Kumar Gupta.-Oracle 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Need the table name that stores job history of BIP reports submitted through BI publisher dashboardSummary: Need the table name that stores job history of BIP reports submitted through BI publisher dashboard but not the Scheduled processes page. (I know the ESS_REQUES…Chetan Konda 174 views 7 comments 0 points Most recent by Raman_Balasubramaniam Reporting and Analytics for ERP -
How to join fnd_bpm_task_comment to fnd_bpm_task_history_b table?Summary: I am trying to get data from fnd_bpm_task_comment table and joining with fnd_bpm_task_history_b table with Task_id but i am dropping the data which doesn't have…
-
printer setupSummary: Questions regarding printer setup Content (required): Hi team, Kindly clarify below points. *BI Publisher >Administration>Manage Publisher>Delivery>Printer>Add …BhargavC 41 views 2 comments 0 points Most recent by Priyanka_Girdhar Reporting and Analytics for ERP
-
scheduled report not getting data in output filewe have scheduled a report on daily basis to the SFTP folder using the destination while scheduling reports. Reports are scheduling but not showing data in the output ge… -
bicc povSummary: We are trying to extract data using BICC. We need to know whether : 1) BICC POV s can be joined together to get the desired data 2) We can create our own POVs W…DebjaniRoy 32 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered errorSummary: Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : I have full ownership of the folder that i'm trying to copy the shortcut : Plea…Shashidhar Goud 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to create Account Range parameter?Summary: Standard ESS job - Supplier Balance Aging Report, has a parameter 'Account Range'. How to define the parameter for a custom ESS job? Content (required): Standar…
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…Luis Orihuela 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
view past versions of PDF in oracle fusionSummary: How to view the past revisions of PO PDF within Oracle Fusion ? Content (please ensure you mask any confidential information): Version (include the version you …
-
Adding Days to DayNameI am trying to calculate the end of a weekly cycle. I have a column with day names and another column with the number of days to add. For example, adding 3 days to Monda… -
BICC Extract Schedules vs Job SchedulesSummary: Hi, I would like to create a pipe line between BICC and data warehouse to extract Financial Data I wonder what the difference and use case is for one or the oth…Daniel Sobotka 21 views 2 comments 0 points Most recent by Goutham PPM Reporting and Analytics for ERP
-
Error when generating report, unsupported output format XLSXWe've received an error on one of our reports. Error message is the following: "Output failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=158261] oracle.xdo.servlet.data.D…Francisco Carrillo-Robles 101 views 2 comments 0 points Most recent by Francisco Carrillo-Robles Reporting and Analytics for ERP
-
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 121 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 4.6K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
็How to custom Trial Balance ReportSummary: How to custom Trial Balance Report by adding Filter Conditions accounting segment in Trial Balance Report Content (please ensure you mask any confidential infor…
-
'Create Accounting for Assets' Custom ESS Job for Draft Accounting Mode only.Summary: How to create custom 'Create Accounting for Assets' ESS job where Accounting mode parameter must be - Draft only..? Content (please ensure you mask any confiden…Annpurna Swami 62 views 6 comments 0 points Most recent by Hasan Hasan Reporting and Analytics for ERP
-
Unable to generate consolidated output for Create Customer Statement Report.Summary: We have a requirement to customize and enable consolidated output for Create Customer Statement Report. Although we have activated the feature to display consol…
-
Rows repeating with different values though it's not available in the Front end under Customer SiteSummary: Hi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a …Rahul Kumar Gupta.-Oracle 21 views 2 comments 1 point Most recent by Daniel S.-Oracle Receivables & Collections
-
Find corresponding data of field in oracle database table.Hello, I am currently looking for the following information: From Edit Payment System page Field: "Name" From Edit Payment System Account page Field: "Name" From Edit Fu…
-
General Ledger Balances Real Time OTBI not fetching Cost center values from COASummary: I am using General Ledger Balances Real Time Subject Area to extract all COA value set values and i am able to derive all COA values except for Cost center, Onc…Texas Children 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Automating BI Catalog archivingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…G8rNtn 21 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to submit BIP Report in oracle fusion with soap webserviceSummary: How to submit BIP report in fusion with soap Webservice https:///xmlpserver/services/ExternalReportWSSService In this soap webservice need sample payload forsub…Srinivas B 81 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Best Practice for Monitoring Performance and Resolving Issues?Hello, We are experiencing recurring times of slowness in our system and want to better monitor the performance to potentially troubleshoot this problem. When users repo…Alex Cavanaugh 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
how to enable incremental value schedule standard report in oracle fusionSummary: how to enable incremental value option while scheduling standard report Report : Payable trial Balance reportMohammed Masoodhu Hashir 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How to duplicate a DashboardI need to duplicate and modify an out of the box dashboard: CIP Account Analysis. How do I duplicate it and save it, when I try to do so, I am unable to edit components.erp_expert03 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Period Name parameterSummary: Hi , I am currently working on report which is filters using period_name. when i select single month(period_name), the data looks promising. when multiple perio…Praveen_Chouhan 71 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP