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
-
Performance considerations while doing Bulk Email BurstingSummary: At a time, need to send around 5K email notifications to supplier/supplier sites belongs to country . Content (please ensure you mask any confidential informati… -
Can we customize Print Receivables Transactions report Bursting query from emai To FTP/SFTP ?Summary: Client requirement is to receive AR transaction PDF to FTP location rather sending it via email so want to customize Print Receivables Transactions Bursting que…
-
How does user level data security work in Fusion Financials BI PublisherSummary: Trying to confirm if I understand the correct way data security works for BIP reports in Fusion as its not working as expected Content (please ensure you mask a…
-
Item EFF/DFF public viewobject in BICCSummary: What is the BICC Public View Object to extract the Item EFF and DFF values from Fusion Cloud. I am unable to download the 26A version BICC extract files for HCM…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeAs per the business custom requirement OTBI subject areas to be used are Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time which is cc…
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…
-
What is the recommended way to extract item data in bulk from Fusion Cloud(PDH) by External SystemSummary: What is the recommended way for an external system to extract item data in bulk from Oracle Fusion Product Data Hub (PDH) to be used with OIC. Content (please e…
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
Is there any Supplier Statement Report?Summary: Is there any Suppliers Statement Summary Report? including Opening and closing balance paid and unpaid invoices. Content (required): Supplier transactions Versi… -
How can we pull last day of current month in eText templateSummary: How can we pull last day of current month in eText template Content (please ensure you mask any confidential information): Hi Team, Our bank wants last day of m…
-
When using Journals real time subject area the amount for a journal is getting doubledSummary: When I add the Journal Batch details folder columns, especially the 'Created By' field to the OTBI analysis, the amount gets doubled for the journal. This is ha…
-
Create custom role to files in UCMI need the ability to view files in UCM, we have a report which runs via an ESS job but its erroring because users don't have the relevant privileges to access UCM. The …
-
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…
-
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…
-
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …
-
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust…
-
Help with query to pull Spoke System Items for a given itemHi, I need to create a query to pull all "Spoke System" linked to a item. A have tried the query below, however if won't work because the source_system_id on EGP_ITEM_RE…
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
How to replace invalid XML character (fffe)Summary: Due to invalid characters in Purchase Requisition header description (mostly likely due to requestor copied and pasted content containing this invalid control c…
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
Download Attachment File from Oracle REST API (HCM/SCM) without MiddlewareI was able to successfully retrieve the download URL from Oracle Fusion REST API within BI Publisher (Data Model only), and the link works correctly. However, when downl…
-
OTBI Risk Management Catalog Deployment After Instance RefreshSummary: Hi, We have deployed the OTBI dashboard for Risk Management by unarchiving the Risk Management OTBI catalog into our lower environment. We would like to underst…
-
How to populate JG_ZZ_VAT_REP_STATUS tableSummary: We are working on a Bulgaria rollout. VAT reports are customized and uses JG_ZZ_VAT_REP_STATUS table.We could not find how to populate this table Content (pleas…
-
Standard oracle functionality is not working when one custom button added in the Edit Journal Page.Summary: I have created one custom button in the Edit journal page name 'Validate' for a business requirement in my project. That custom button itself is working as expe…
-
Fixed Assets – Asset Description Real Time report OTBIHi, We have identified an issue in the Fixed Assets – Asset Description Real Time report. It appears that the asset number is not being correctly mapped to the asset boo…
-
Project field is blank for below querySummary: WITH hours_data AS ( SELECT prr.payroll_assignment_id, prr.run_result_id, TRUNC(prr.ora_part_key) AS trx_date, SUM(TO_NUMBER(prrv.result_value)) AS hours FROM p…
-
MISC code in OTBISummary: Is it possible to get the MISC code in OTBI? We need to build a report for 1099 since Oracle's 1099 capability is severely limited. Content (please ensure you m… -
Person Number column is blank when creating an analysis using Project Costing Subject AreaSummary: Wehave created a report using the Project Costing Actual Costs Real Time subjectarea. In that report we have selected the Person Number and Person Name fields,b…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …