Category 129
Discussion List
-
Historical Depreciation & Total Accumulated Depreciation from Depreciation Real time Subject areaSummary: I am trying to calculated the Historical Depreciation & Total Accumulated Depreciation from " Fixed Assets - Depreciation Real Time" subject area. There seem to… -
Using Oracle Database Cloud Schema Service to access Oracle Fusion DatabaseSummary: Using Oracle Database Cloud Schema Service to access Oracle Fusion Database Content (required): in MOS article 1910762.1 it states "If the SaaS / Fusion service…Jeff Hainsworth 44 views 3 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for ERP
-
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
SQL query to generate Fiscal Classification Code on customer profile & site levelSummary: Need help in determining SQL query to retrieve fiscal classifcation code from customer profile & site level. Content (required): Hi all, What SQL query should I…
-
Tables not available for BICCC extraction - what is the alternative?Summary: While configuring data extract from BICCC, we notice that within a data store many tables do not have equivalent PVO. Below are few examples where I could not f…Sharas Vitalapuram 84 views 2 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for ERP
-
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…Mohamed Iqbal Jahangeer 265 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
How to send the BIP Report Output to Customer without Scheduling Cloud BIP ReportWe need to send BIP Report output to a mail id which is passed as parameter. We have enabled the Bursting it is working. But customer is not accepting to schedule the Re…Muthukrishnan-Oracle 87 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Data modelling in OTBI?Summary: Hi In Payables (and therefore also in the Procurement subject areas such as Procurement - Spend Real Time) it sometimes happens, that an invoice is matched with…Anders W. Langholm 24 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
How to put current financial year filter to date columnSummary: hi we are developing an Otbi report to find out the revenue recognition amount for the current financial period, can any one suggest us, how to put the filter o…
-
Having issues with BI Report. Wont pass multiple selections on ParametersSummary: I have the following attached report where when attempting to select multiple parameters such as Expense Status or departments I encounter the ORA-00909 error. …RRR RRR 91 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Bi Publisher - How to read the content of an attachment using sql script in data modelHi, We have a requirement in BI Report, to check for the attachment at Supplier Profile and if the attachment is present then we need to read the content of the attachme…Nepal Bhumireddy 514 views 8 comments 0 points Most recent by Nepal Bhumireddy Reporting and Analytics for ERP
-
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaRamaKrishna-Oracle 35 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to fix envelope section in the first page when there are more than one page output in RTF?Summary: How to fix envelope section in the first page when there are more than one page output in RTF? Content (required): We have a requirement to fix the bottom secti…Abhilash K - Deloitte USI 33 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Calling runReport in xmlpserver/services/v2/ReportService Webservice with SSO enabled user(Azure AD)Summary: Hi All, I am working on calling a BI Publisher report from a custom application using xmlpserver/services/v2/ReportService webservice. The requirement is to use…Sarthak Mohanty 150 views 0 comments 0 points Started by Sarthak Mohanty Reporting and Analytics for ERP
-
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…
-
"FAWService" Oracle Account is consuming Oracle Cloud Fusion LicenseWe have ran order built "UserPrivilegesByService" report and found "FAWService" which is an Oracle Account is consuming licenses due to "Supply Chain Planner" role. Plea…SUDHIRNARAHARISETTI 63 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 38 views 0 comments 0 points Started by Ananda Bhargav Potluri Reporting and Analytics for ERP
-
How do I get my .csv output columns in same order as ExcelHow do I get my .csv output columns in same order as Excel? Thank you. Esmeralda -
Editing a page using sandbox subjected to a user roleSummary: Content (required): Hi All, We have a requirement to publish the dash boards created using OTBI analysis in the 'My Dashboard' page. However, the published dash…Vipusha Chandrakumaran 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data SourceSummary: Is it feasible to connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data Source ? If yes, can you provide us with any white paper docu…SUDHIRNARAHARISETTI 45 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Which function can be used to display only one value from multiple values result?Summary: Display the first value from a result including many values Content (required): We're using an OTBI analysis for delayed PO deliveries and we've supplier's deta…
-
Supplier Qualification Infolets page showing initiatives status graph by login baseSummary: Supplier Qualification have Infolets page showing initiatives status by graphical view by the login base and customer want to see the globally ,how many initiat…SivaRamaKrishna-Oracle 31 views 3 comments 0 points Most recent by SivaRamaKrishna-Oracle Reporting and Analytics for ERP
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows Financials OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was availa…Ibrar Hussain 34 views 2 comments 0 points Most recent by Ibrar Hussain Reporting and Analytics for ERP
-
Fusion BI Report Custom LOV description alignment problemSummary: The problem : The description is not properly aligned (see below in yellow) in custom LOV. The user has requested for the description to be left-aligned. Conten…
-
How to enable the File Data Sources in Oracle BI PublisherSummary: How to enable the File Data Sources in Oracle BI Publisher? The guide shows how to do it but we are getting the error (Fusion Middleware Administrator's Guide f…Raymond Alvizo 23 views 2 comments 0 points Most recent by Raymond Alvizo Reporting and Analytics for ERP
-
Analysis - SQL expressionSummary: How to get first month of previous date - SQL Expression (Criteria ) Content (required): We have created a Analysis report and business needs to schedule this a…
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 84 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
What is SQL Receipt Accounting join to source_id_int_1 column from xla_transaction_entities?Summary: Trying to go from GL through Subledger Accounting to Receipt Accounting in Data Model SQL. Didn't find any documentation or hints on this. Content (required): V…huronstevesmith 1K views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Is it possible for an analysis to link to a dashboard prompt?Hello, I would like to link one analysis to the prompts on a dashboard which will then update another analysis. Is that possible? Thank you, Julia Oracle Fusion v23AJulia Looi 37 views 1 comment 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
OTBI Dashboard combining two subject areas of two different modulesSummary: We want to prepare an OTBI dashboard having 2 analysis. First analysis will pull the data from Procurement contracts module for lets say 10 suppliers and then s…Vicky Adwani 87 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP