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
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO … -
Financial Reporting Excel Export Splitting into Multiple Worksheets Instead of a Single WorksheetHi Everyone, We're experiencing an issue where Financial Reports exported from Open Workspace for Financial Reports are now split into multiple Excel worksheets based on…
-
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…
-
How to create a From-To Account prompt with "Code - Description" list in GL Balances Tree Report?Summary:Need a From-To dropdown prompt showing "Code - Description" sorted by numeric code for a KFF tree report. Content (please ensure you mask any confidential inform…
-
Uploaded Daily Rates QuerySummary: Need to create a report for the uploaded conversion daily rate in the GL. Content (please ensure you mask any confidential information): Hello, We have a requir…
-
Is there a way to get a pop box with a statement on clicking on Save on Create Payables InvoiceSummary: While Creating an Payables Invoice in Classic UI, there are fields like Invoice Currency and Payment currency, so when user enters the same currencies in both t…
-
FRS default previewSummary: FRS reports are opening in HTML view by default when "Default Preview Mode" in preferences set to PDF Content (please ensure you mask any confidential informati…
-
Clarification on Oracle AI Vector Search support within Fusion OTBI, FR and BI Publisher reportsWe are seeking clarification on the use of Oracle AI Vector Search (Vector Database capabilities) within Oracle Fusion reporting solutions. Specifically, we would like t…
-
Approach to accurately identify active reports in Oracle Fusion CloudWe are trying to build an accurate inventory of all custom reports used in Oracle Fusion SaaS, including BI Publisher (BIP), OTBI, and Financial Reporting Center (FRC) r…
-
unable to find the ESS Job while creating Request setSummary: Hello, We are creating a request set for an ESS Job. But while creating the request set the ESS Job name is not able to see. Kindly suggest on this for possible…
-
poz_supp_site_requests not having an entry for Supplier Site pending approvalSummary: we have a need to create a BI Report and list all supplier and it's sites that are pending approval on profile changes or any other changes. we try to display p…
-
OTBI Subledger Reconciliation Report with GL - ReportSummary: OTBI Subledger Reconciliation Report with GL - Report Content (please ensure you mask any confidential information): Hello The Company have the below subledgers…
-
Mailto links not workingSummary: I am trying to embed a mailto: action link in a report to create an email to a requester where they need to take action, for example where they have an invoice …
-
If a client discontinues HCM but using Finance and SCM, how will user and employee records managed.Summary: Our client is currently using Oracle Fusion applications, including HCM, Finance, and Supply Chain Management (SCM). They are now planning to discontinue Oracle…
-
How to report when a pay batch was approved in Incentive CompensationSummary: I need to create a report for a weekly integration that only will pass data for pay batches that were approved during current week. "Last updated date" is too u…
-
AGIS tables PVO's doesnot existsSummary: Hi Team, The below AGIS tables PVO's does not exists in BICC. Can you please advice to me. FUN_BAL_INTER_RULES FUN_BAL_INTER_ACCOUNTS_ADDL Thanks Content (pleas…
-
Query to audit delegation for requisitionsSummary: Query to audit delegation for requisitions Content (please ensure you mask any confidential information):Hello, I want to prepare an Audit report for Delegation…
-
in the account analysis report when the category payroll the line description is blankedSummary: in the account analysis report when the category payroll the line description is blanked, from where we can fill the data for Line description Content (please e…
-
How to search/ filter two columns with single Table Prompt in OTBI analysisProblem: There is a business requirement to search Bank Account Number (which can be set up either at Customer Account level or Customer Site level) using single Table P… -
OTBI - Retired Fixed Asset with Source Line DetailSummary: In Asset Transactions Real Time we would like analyze retired assets with the source line details (project number, invoice number,etc.). The source line detail …
-
how get query manage locationsCan someone help me with the query to obtain the information shown in the "manage locations" option? Basic details name status code Main address Main address usage type …
-
How can I access the list of EU countries?I have a query; SELECT * FROM hz_geographies WHERE geography_type IN ('ECONOMIC REGIONS') I want to question the countries within the EU. However, when I run the query, …
-
Latest Invoice Date by Supplier - OTBISummary: I need a report that shows the latest supplier activity by either invoice date or po creation date, in aggregate form Content (please ensure you mask any confid… -
Issue Fetching Accounting Period in FRS Report HeaderSummary: Hello, While attempting to use the MemberName function in the header of an FRS report to display the Accounting Period selected in the grid, I am encountering t… -
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…
-
Documents about multiple reporting tools in Fusion and their usesSummary: There are several reporting tools available in Fusion (OTBI, BIP, FRS, FDI etc.). Is there any document available from Oracle which helps explain when these too… -
Requirement to have 7 buckets in Customer Statement reportSummary: Client requires 7 buckets in Customer Statement Report. We have defined a statement aging method to have 7 buckets but only 5 buckets are visible in the report …
-
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
LUHN check digitHI All We use LUHN check digit part of the check numbers and transaction numbers extract from ERP to the client payment systems. This is a common requirements in the pay… -
Joint Venture Setup and Contributions AnalysisSummary: It seems there is only an OTBI subject area for the Joint Venture module Transactions and Distributions details. There does not seem to be a way to report on an…