Category 129
Discussion List
-
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.… -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 77 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP -
How to default a Prompts selection in OTBI dashboard from Lookup code based on logged in UsernameWould like to reach out to you on how to set the default value of a Prompt with a value from lookup code which is related to the logged in User name. We have an Analysis…Dinesh R 14 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 148 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
How do you delete BICC UCM filesSummary: For data security, once the UCM files have been generated and the data has transferred to destination using BICC, how do we get the UCM content deleted. Content… -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 24 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to control the scheduled BIP report Output based on Row CountRequirement : BIP report schedule daily - which is configured to send an email - base don the configured emails. Is it possible to control sending an email based on the …Sridhar Gupta Yerram-Oracle 10 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need guidance on Malaysia specific localizationWe are looking for information regarding Malaysia localization changes that have been implemented from reporting perspective. What are the possible changes we need to ca…Harshal Kailas Desale 42 views 5 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
U.S 1099 Payment ReportHi, We had requirement to add below columns to U.S 1099 Payment Report. Vendor Type of TIN ( E/S) Vendor Recipient Address 1 Vendor Recipient Address 2 Vendor Recipient …Ismail Sherief 9 views 0 comments 0 points Started by Ismail Sherief Payables, Payments & Cash Management
-
How to customize standard OTBI ReportSummary: How to customize standard OTBI Report Content (please ensure you mask any confidential information): I need to customize one of the standard OTBI reports in Fus…
-
Unwanted Linefeed characters getting returned in eText outputSummary: Linefeed characters getting returned in eText output Content (please ensure you mask any confidential information): I am having an issue where there is both Lin…
-
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …Gurvinder Singh Gill 141 views 3 comments 2 points Most recent by Sai Sunkara Reporting and Analytics for ERP
-
Combining Procurement Subject Areas for Enhanced AnalysisI am currently attempting to combine two subject areas, namely Procurement - Requisitions Real Time and Procurement - Purchasing Real Time, for a comprehensive analysis.… -
Is it possible to implement a parameter refresh function when the parameter is in date format at BIPSummary: Is it possible to implement a parameter refresh function when the parameter is in date format, like a text parameter? Content: Hi, In the SQL for the parameter …M Watanabe 17 views 1 comment 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management
-
Need help : Looking for table with 'Alternate Account Owner Name'Hello, I'm currently working on a report related to customer bank accounts, and I would appreciate your support. Does anyone know which table and column store the "Alter…
-
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…
-
How to hide parameters in scheduled process ?Hi, we want to hide some parameters that we don't populate in a scheduled process. For example, we want to hide source locator and destination locator from "Print moveme…Daniele Landinetti 7 views 0 comments 1 point Started by Daniele Landinetti Reporting and Analytics for ERP
-
Please advise how to create a scheduled report of all administrators of the oracle application?Summary: IT would like a monthly report of all administrators of the oracle fusion application. The Scheduled Process report, User Role Membership Report, contains data …
-
Not receiving emails from bursting querySummary: We are trying to develop a bursting query to send email notifications, but are not receiving any emails though the report job shows to be successful. Content (p…
-
<Line 3, Column 94>: XML-22002: (Fatal Error) Error while processing include XSL file..Summary: Hi, I have created BIP report which have main template and created one more bip report which have sub-template as I need to show the 2 layouts according to inpu…
-
SQL query or oracle table names to extract the actual values of supplier change request detailsHi, Business requirement is to see the actual values that got changed on all of those tabs under supplier i.e. organization details/Addresses/Banking/Business Classifica…
-
Report or table details for Chart of account listing values for natural account in General LedgerSummary: Hi Team, I have to create BIP report for COA listing values for Natural Account in General Ledger as per attachment. I am looking for table details or query to …ManishaPatil 32 views 3 comments 0 points Most recent by ManishaPatil Reporting and Analytics for ERP
-
Values exported from Financial Reporting Studio to Excel with the wrong sign!We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values present in the system (e.g. in the system the …Michele Ferro-Oracle 18 views 2 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany -
Sql query or Table name for Classify Organizations under Manage Project Organization ClassificationSummary: Hi Team, We need a table or query to get the flag columns for Classify Organizations under Manage Project Organization Classification Attached the screenshot fo…
-
OTBI - can we apply case condition on columns from different subject areas ?Summary: CASE WHEN SA1.COl1 = 'Y' THEN SA1.COL2. ELSE SA2.COL1 END ; The above is not working as expected. Does OTBI supports CASE condition on multiple subject areas or…Sridhar Gupta Yerram-Oracle 20 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Oracle SaaS metric-descriptions-fusion-offeringsSummary: Hello Team, We are in a need of support to get information on following points. Scenario: We are in a need of adding these 2 privileges in our custom role ‘View…
-
How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Summary: How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Sridhar Gupta Yerram-Oracle 9 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Best Practices for OTBI Reports Handling Large Data VolumesSummary: Hi everyone, I’m looking for recommendations and best practices for developing OTBI reports that need to handle large amounts of data. Is there a recommended st… -
Duplicate lines in PVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVOIn the Oracle Business Intelligence Cloud Connector (BICC) Console, the Support Incremental option is enabled under Manage Job for FscmTopModelAM.FinExtractAM.GlBiccExtr…Jaydeep_Chaudhari_1802 74 views 6 comments 0 points Most recent by Hbsampa General Ledger & Intercompany
-
What is the usage of ROW[#Ref] function in the Financial Reporting StudioSummary: There is a Function called ROW[#Ref] in the formula for FRS. What is the usage of it. Content (please ensure you mask any confidential information): Version (in…SuniChacko 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany