To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
FRS report for particular ledger and Period not returning Data. What may be the reasonSummary: FRS report for particular ledger and Period not returning Data Content (please ensure you mask any confidential information): Summary: FRS report for particular… -
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b… -
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req… -
Chinese letters turning to special character when extracting via CSV BIPHello Oracle, Is there a way to adjust the output character set when extracting a BIP Report (Oracle BI EE Data Source) to CSV? We are having issues when extracting Chin…
-
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe…
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?
-
Table to find PO line level attachmentsSummary: We can see line level attachments on the PO page. However, we don't see the attachment details for all the lines in the fnd_attached_documents table. We also ch… -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…
-
Request for Information Notification disappears in the Things to FinishSummary: Request for Information Notification disappears in the Things to Finish Content (required): Hi, We have an issue where the PR approver request for information. …
-
Beginning and Ending balance in Subject Area "Fixed Assets - Asset Balances Real Time" not showing cContent Hi all I'm trying to build a Fixed assets balance, based on the Subject Area "Fixed Assets - Asset Balances Real Time". For some reason it shows the wrong deprec… -
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…
-
Changing Legal Entity and Business Unit namesSummary Impact of changing LE/BU names for HCM/Financials and PayrollContent Hello, Our company has recently been purchased, and a request has been made to change all na…User_2025-01-28-01-21-57-465 400 views 2 comments 2 points Most recent by chandraobulreddy bogireddy
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…
-
OTBI Prompt - Default Programmatically setting dateSummary: When adding in an accounting period, I'm not able to programmatically set a date with the format YYYY-MM. I've tried a few different things but I can't seem to …
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Oracle Fusion Cloud Sustainability posibility to report via OTBI/Subject AreasThere is a module available for all ERP customers where you can store sustainability data. Created via AP invoices or imported via external systems. This is something th… -
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias… -
Guidance for selecting PVOs for BICC extractSummary: We are using Oracle Business Intelligence Cloud Connector (BICC) to extract transactional data & load it into external tables using Informatica Cloud Services. …
-
How to output of a BIP Report in multiple excel sheets in XLSX format?Hi we would like to know if there is the way to output of a BIP Report in multiple excel sheets in .XLSX format. Currentry we can see only .XLS format is avaiable when E…
-
In My Data model only see Bursting and ParametersSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SaaS Service Usage Metrics Report, Is it possible the overusage generates additional billing?Summary: The SaaS Service Usage Metrics Report / Hosted Named User Unexpected Usage, shows an overuse in B91079 SKU, is it possible that this overusage generates additio…
-
Is it possible to enable audit and tracking of all user activity?Summary: Business requires all user activity regardless of module and transaction within the Fusion SAAS ERP to be tracked. Is there a way to achieve this functionality?…
-
ESS JOB User defined list of value with multiple displayed fieldsSummary: Creating a parameter for a custom ESS Job with a custom list of value . Content (please ensure you mask any confidential information): In Oracle Fusion I've cre…
-
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce…
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…
-
Fusion Payables OTBI Query for Invoice Approval RulesSummary: Does anybody have a query for invoice approval rules Content (required): Does anybody have a query for invoice approval rules. Our client needs to see who has n… -
Oracle BICC not providing PVO's for IEX tables of AR ModuleHi Team, Currently we are consuming Fusion FSCM data via BICC console for loading data to our warehouse. We are able to load all data related to Customer, AR Invoices ,R…
-
Report 2x - 5xing values when using the hierarchical tiersI'm having issues trying to get the right data when using the object 'Level 22 Value' in Natural Account Segment under the General Ledger - Transactional Balances Real T…