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
-
Substitution Variables in FRSSummary Substitution Variables in FRSContent Can anyone please direct me to documentation on how to set and administer substitution variables for use in Financial Report… -
ERP – Things to Know About Updates, - 13 November 2019, 8 a.m. PT - Submit QuestionsContent Submit your questions for the ERP – Things to Know About Updates session to have them answered during the live event. Post your questions by posting a new commen…
-
ODBC driver returned an error (SQLExecuDirectW)Content I tried to build a report on the subject area 'Payables Invoices - Installments Real Time', by querying the following 5 fields: Business Unit.Business Unit Name … -
Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one rowSummary ORA-01427Content I am using Oracle Fusion, the finance/payables reporting side of things I have the following code: SELECT DISTINCT PHA.SEGMENT1 FROM AP_INVOICES… -
Error in BI Desktop InstallationContent Hi, During BI Desktop installation I finding the error as attached any inputs will be helpful Download URL : https://www.oracle.com/middleware/technologies/busin… -
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat…
-
ERP – Navigating the General Data Protection Regulation (GDPR) Future Challenges - 6 November 2019,Content Submit your questions for the ERP – Navigating the General Data Protection Regulation (GDPR) Future Challenges session to have them answered during the live even…
-
Sales Credit information not available in Projects - Cross Subject Area Analysis - Real TimeSummary Sales Credit information not avaible in Projects - Cross Subject Area Analysis - Real TimeContent Sales credit information such as salesperson name, percent, sta…
-
SQL gives me wrong purchase order number for invoiceContent Hi, When I go into the front end of Fusion, I can see that an invoice number of 26427 only has 1 purchase number matched against it which is PO 911753 When I do …
-
OTBI - Display the row of SUM onlySummary How can I edit the OTBI report to display the row of count and SUM only?Content I built a report to display the 'count of invoice number' and 'SUM of invoice amo…
-
Tools for backing up, managing version history of BIP ReportsSummary Looking for tips on how others are backing up or managing versions of BIP reports.Content Our team is exploring the idea of using BitBucket or GitHub (or another… -
Our Client want to whitelist the URL https://*.fa.em2.oraclecloud.com/publicFinancialCommonErpIntegrSummary we are using the URL https://*.fa.em2.oraclecloud.com/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL to submit the Bulk Import for the Finanacial…
-
Change Order History on POSummary Status, Amount and Qty of POContent Hello, How and what fusion tables can I get the status, calculated amount and quantity of a change order? Basically get the l…
-
eText Template for Payment BatchContent Hi, In the delimited eText Template it works fine when payment is made for single invoice for a supplier. If invoice batch is submitted (which has more than one …
-
Policy Predicate ErrorSummary When querying some tables and views we are getting Policy Predicate ErrorContent Selecting data from per_person_names_f or hz_parties is giving a policy predicat…
-
Validation in eText TemplateContent Hi, I need to have validation on the payment date if the payment is made after 17 00 on Friday it should print Monday as payment date For example if the payment …
-
NUX - Newsfeed UX Layout mandatory change for FINANCE?Summary HCM clients are requested to move to NUX layout by 20B... how about FinanceContent Oracle HCM (in OOW19 and also via some HCM consultants) are mandating clients … -
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …
-
Which table stores 'Transaction Number' in Project CostsSummary Looking for backend table that stores 'Transaction Number' in Project CostsContent Hi All, I'm looking for backend table that stores 'Transaction Number' in Proj…
-
SQL Table to bring in Audited by from the AP module to a BI reportSummary SQL Table to bring in Audited by from the AP module to a BI reportContent I am searching for the SQL table to bring in Audited by from the AP module to a BI repo…
-
ORDSSummary Ad Hoc Question on Oracle REST Data ServicesContent Is ORDS free if you use Fusion SaaS? I went to a presentation on Oracle Rest Data Services at Open World and …
-
Quarterly Patching - TestingSummary Quarterly Patching - TestingContent Hi I was just wondering what other customers do around the quarterly patching for financials? We tend to read the notes for a…
-
Financial Reporting Studio will not work after installationSummary FRS installed, but error message says it is not installed.Content FRS was installed according to Doc ID 2051105.1, and computer shut down and rebooted. Get the f…
-
In Fusion Applications Update 19D, Oracle will discontinue the Direct Database QueryContent Dear , In Fusion Applications Update 19D, Oracle will discontinue the Direct Database Query. meaning you will no longer be able to create, modify or run these ty…
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Ability to Escalate a notification without it eventually expiringSummary Help with the setup of notifications and expirationsContent Good day, We have the notifications set up so that they expire after 14 days. And after the expiratio…
-
Barcode in ReportContent Hi, I have requirement to print barcode in the invoice report and let me know how to progress on this Barcode number in invoice report will be in the format of …
-
Checklist for Financial Cloud for acquisitionSummary Checklist for Financial Cloud for acquisitionContent hi All, I am looking for a checklist for financial cloud in case an existing company is acquired by another …User_2025-02-04-06-32-06-181 54 views 3 comments 0 points Most recent by User_2025-02-04-06-32-06-181
-
created_by or last_updated_by - how to find username on those fieldsSummary created_by or last_updated_by - how to find username on those fieldsContent in gl.created_by and gl.last_updated_by I get a number or email address. How do i get…
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…