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.
Get Started with Redwood: Oracle Cloud SCM and Purchasing
Reporting and Analytics for ERP
Discussion List
-
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…
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
Can I apply a Receivables Credit Memo while referencing the Invoice Transaction number in FBDI?Summary: While uploading Receivable credit memos via FBDI, I aim to automatically apply open invoices by providing references in the sheet. I'm aware of using the Refere…
-
Custmization on AR Transaction Image ,error occurred File name must end with .xdoz / .xdmz / .xssz /Hi Team , when I changing the query, system asking for Lexical parameter . For this issue , I found below documentHow To Work With the Lexical Parameter Value When Custo…
-
sSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…
-
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…
-
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…
-
BICC 24 Version BICC Mapping DocumentSummary: Please share the Rel13_24.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zip Mapping Document Content (please ensure you mask any confidential information):…
-
Cannot access name on errored out EssBIPJobSummary: 24C version The errored out process name is not displayed, when i check from Report job history page, not able to check the details of this ess bipjob, can anyo…
-
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…
-
SaaS BIP reports in waiting for long timeWe have kicked off BIP Report in SaaS/Oracle Financials Cloud and its in waiting mode for 2 hours 40 mins before it started executing.
-
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanks
-
Conditional Formatting to display field in redHi, In the PO template if the amount
-
Getting java.lang.NullPointerException error while invoking fscmService/ServiceCatalogService?WSDLSummary: fscmService/ServiceCatalogService?WSDL We are trying to using above ServiceCatalog WSDL for FDBI upload process..which upload zip file and submit the ESS Job as…
-
While the ESS job names are visible in the ui, they are only partially displayed in the BIP ReportSummary: While the ESS job names are visible in the user interface, they are only partially displayed in the BIP Report, with approximately 50% of the job name informati…
-
OTBI Data Discrepancy for "Performed Action" Approve in Procurement - Requisitions Real TimeSummary: Hi Community, I'm encountering an issue in OTBI (Oracle Transactional Business Intelligence) when retrieving data from the Subject Area: Procurement - Requisiti…