Category 129
Discussion List
-
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 delete page entry which are created using structure toolSummary: How to delete page entry which are created using structure tool Content (please ensure you mask any confidential information): Hi All, We created page entry(Rep…
-
Disability CategorySummary: We are building a report that displays a summary of Disability Categories Specifically the "Workforce Management - Person Real Time" subject area - Person Disab…
-
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 3 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 …
-
Method to Bulk Retrieve and Review Job DefinitionsSummary: Method to Bulk Retrieve and Review Job Definitions Content (please ensure you mask any confidential information): Task Name: "Manage Enterprise Scheduler Job De…
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 114 views 4 comments 0 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
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 24 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 11 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 14 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 2 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 45 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 3 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is it possible to change the output language of the log of scheduled process?I logged into the ERP with the default language set to "Spanish." However, when I download the log file from the "Scheduled Processes" UI, the output shows information i… -
BIP report only bursting to default printerHi Team, I have bursting logic in my BIP report to burst the output to different printers based on a lookup. If the selected printer is set as default printer in Adminin…
-
Request for Guidance on Data Export Prior to Tenant ExpirationOur Oracle tenant is set to expire next month, and we would like to ensure a smooth and complete export of all relevant data prior to that date. We have reviewed the ref…
-
Data Roles and Security Profiles - Unable to find 'STATUS' column for BI reportsHello, I’m currently working on a report related to Data Roles, and I was wondering if anyone here has worked on something similar or knows which table/column stores the…
-
Why Fusion and OTBI report gives different Validation StatusIn OTBI I use the MATCH_STATUS_FLAG from AP_INVOICE_DISTRIBUTIONS_ALL to get the validation status. A - Validated Null - Never / Not Validated T - Needs Revalidation Is …Alvin 14 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
MOT_REF_ENTITIES custom object table not pulling dataSummary: There is a OTBI report built using custom object subject area whose dimension and fact tables are populated with data thorugh some integration reports through s…
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine…
-
What are the Best practices when implementing Fusion Cloud HCM Succession Management and TalentSummary: What are the Best practices when implementing Fusion Cloud HCM Succession Management and Talent Please share the What are the Best practices when implementing F…Priya Nathan-Oracle 3 views 0 comments 0 points Started by Priya Nathan-Oracle Performance Management
-
How to split a single row into multiple rows in oracle fusionDear All, I got an requirement like need to split single row into multiple rows dynamically, but here that single row is having value like 99 so i need to split 99 rows …
-
How can I get the image of products in report OTBI Query?I want to get the images uploaded in the Product Information Management module for a report using a query, I have the following query, but I have not been able to get th…
-
What does the FND_GRANT report data mean?We have a report in Oracle ERP Reports and Analytics that pulls data from FND_GRANTS that were modified during a specific time frame. Usually this report is empty but du…