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
-
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…
-
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …
-
Can we add Custom P_LANGUAGE Parameter for template translations in fusionSummary: Hi Team, Can we add customer language parameter to select templates and translations based on xliff loaded using language paramter in Oracle BIP. Its working wi…
-
Procurement Procure to Pay real time subject area no data showing on purchase order measurements colProcurement Procure to Pay real time subject area no data showing on purchase order measurements Ordered Amount, Delivered Amount and Open Ordered Amounts User has AP ro…
-
Query to fetch manage person contribution transaction dataSummary: Need a sql query to fetch transaction details of a ICP plan containing details of plan name, its input values, status of the transaction and the level of approv…
-
Why does the Oracle ISO20022SEPAV7_0 not convert characters that are not allowed by SEPA?Summary: Why does the Oracle ISO20022SEPAV7_0 seeded payment format not convert characters that are not allowed by SEPA? -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
Is it possible to edit and add column in Manage Invoice report on Fusion screen?Summary: Is it possible to edit and add column in Manage Invoice report on Fusion screen? User want to add one column in the output report from Manage Invoice. Content (…
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…
-
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b… -
Income Statement and Balance Sheet reportsSummary Are there a Balance Sheet and/or Income Statement reports available in ERP Cloud?Content I'm surprised there isn't an out of the box version for an Income Statem…
-
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…
-
How to count the number of pages per supplier in a report using RTF.Content (please ensure you mask any confidential information): I am creating reports using BIP (BI Publisher), and I use RTF templates for the layout. The report outputs…
-
OTBI results in errors saying "The specified criteria didn't result in any data."Summary: OTBI results in errors below Error Message : The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps t…
-
How to create custom popupSummary: Hi All, Is it possible to create a custom popup that triggers based on specific conditions? For example, on the AR invoice and credit memo pages, we have DFF (D…
-
bi publisher with xml parameterSummary: Hello community, I have the following requirement: From OIC, I need to send data to a BI publisher so that it can return a PDF file containing the data I send. … -
Hide column/s of an FRS ReportSummary: When FRS Report parameters are entered and report is run, I need column/s which give all blank values to be hidden. How can this be done? Content (please ensure…
-
BIP report Pivot filter not functioning as expectedSummary: Running an online layout for a pivot date from a data model doesn't properly filter null dates Content (please ensure you mask any confidential information): Fo…
-
bip report to get the approval history and status and also future approversSummary: Hi Experts bip report to get the approval history and status and also future approvers if the task is in progress. Any sample report sql query can you please sh…
-
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…
-
How to migrate extended lookup code in bulk from one instance to anotherSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
Auto Refresh InfotilesSummary: Client would like an invoice “dashboard” experience in Oracle Fusion Cloud that updates in near real time (or auto-refreshes on a set interval) without users ma…