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
-
Roles that can create and update, or only view Financial Reporting reports connected to GL EssbaseThis concerns roles that can create and update, or only view Financial Reporting reports connected to GL Essbase. We need to understand two types of roles: one that only… -
where can we find the PDF document OTBI_Cross_Subject_Area_Reporting_Guidelines ?Summary: this document is mentioned in few conversations but the link is broken ; Please provide a valid link to the PDF Content (please ensure you mask any confidential…
-
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…
-
Prune Time for Hourly BICC ExtractsSummary: We have BICC Extracts running hourly and prune time set to 60. But the downstream applications have issues with the number of duplicates generated in every run.…
-
Custom template is not reflected in ap invoice approval notificationSummary: Custom template is not reflected in ap invoice approval notification Content (please ensure you mask any confidential information): We've customized the AP invo…
-
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens…
-
Can you please investigate why we cannot use the permissions against folders in OTBI ?Summary Why we cannot use the permissions against folders in OTBI ? what happens now is: when we got enough access, we can set up a specific permission at a certain leve…
-
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work… -
SQL Query or table for User CategorySummary SQL Query or table for User CategoryContent I need to create a query that extracts the information of the user and the user category it's under
-
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…
-
Training Suppliers Details OTBI report not providing all the data in the UIHi, I have created the Training Supplier Details OTBI report from Workforce Learning - Learning Management real time subject area. However the records retrieved through …
-
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…
-
Which FUSION tables OTHER than per_email_addresses per_ldap_users hz_parties store user emailSummary: I need to find the table(s) where user email addresses exist in Fusion. I've checked per_email_addresses,per_ldap_users and hz_parties tables but none of them c…
-
How to customise Requisition Approval E-Mail ReportSummary: We customized the “Requisition Approval E-Mail Report” to display the supplier name in the purchase requisition approval email and in the notification content. … -
Is there a not equal operator for Query By Example?Summary: Is there a not equal to operator for query by example? Content (please ensure you mask any confidential information): We've had a few users request a not equal … -
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…
-
E-Signature BPM Rule for Miscellaneous TransactionsSummary: We have a requirement to configure an Approval BPM rule for Miscellaneous Transactions. Our requirement is as follows: If the transaction type is selected as Mi…
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
Why Relative to Prompt for AccountingPeriod offset by -11 is working fine to get Previous year?Summary: FRS report - Doubt on Relative to Prompt for AccountingPeriod offset by -11 Content (please ensure you mask any confidential information): I am running a report…
-
General Ledger - Balance Real Time measures are nullSummary when using General Ledger - Balance Real Time OTBI subject area all the measures come back nullContent I have users that are trying to create new OTBI reports fr… -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are… -
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in…
-
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…
-
How to fetch a comma separated string into separate columns in Oracle fusionSummary: We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK". When we have multiple approvers for a transaction and those will appear in the "Ap…
-
Default person name using SQL query for DFFHi Team, We have a requirement to default the person name on DFF filed using SQL query. By default the DFF value should be the person name who is logged in currently. We…
-
"View History" section doesn't work when update bank account number through Personal Payment MethodsSummary: Hi, We are developing a BI Publisher report to monitor changes in various system attributes, including the Bank Account Number. Enabling auditing was a necessar…
-
Merging 12 Business Units into 6 new Business Units. What is the correct setups and proceduresSummary: We have 12 business units that need to be merged into 6 new business units. We are currently utilising AR,AP, GL, CM, EPM and need to understand what is the pro…
-
How to schedule BIP report in application composer ?Summary: I would like to use the application composer to schedule a BIP report I have defined the (https://****/xmlpserver/services/ScheduleReportWSSService?WSDL ) webse…
-
Not able to create a custoemr with Jan 1900 as starting date in PROD environmentSummary: When we create a customer in TEST and other non‑production environments, we’re able to use 01.01.1900 as the start date at party, Account and site level, withou…