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
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3.7K views 87 comments 10 points Most recent by ERP & EPM Cloud -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
Need Lease Accounting White Paper and DocumentationSummary: Hi Team, could you please share the latest Lease Accounting white paper for Oracle Fusion Cloud or guide me to the appropriate documentation? Your assistance wo…
-
BICC Extract job failing with Error write/upload fileSummary: BICC Extract job failing with below error FAILURE | oracle.obiacm.dataExtract.DataExtractException: FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtra…
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary :- Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting …
-
I want to group the date year wis in results file which excelFor one of my extractions in report code I am extracting date with code : Trunc(creation_date) CREATION_DATE and in excel layout I hv made the creadtion_date cell custom…
-
best practice to deliver reports by mailSummary: Best Practice to deliver reports and report output by mail notification Content (please ensure you mask any confidential information): Hello, What is best pract…
-
OTBI ANALYSIS PIVOT TABLE SUM TOTAL ON EACH ROW FOR SPECIFIC COLUMNSWe wish to identify how to create the columns in blue and green. I need to know what needs to be created on the Criteria (I assume a custom formula for each summary colu…
-
sql query to fetch bank account details that are linked to supplier addressSummary: Hi all, I would require an sql query to fetch bank account details that are linked to supplier address levle Content (please ensure you mask any confidential in…
-
bip excel template, while creating pivot table -"repeat all item" feature is not getting aplliedSummary: for bi publisher excel template, while creating pivot table -"repeat all item labels" feature is not getting applied while creating template. we have to do manu…
-
How can users receive email notifications in same language as in-app notifications (e.g., Arabic)?Summary: How can email notifications be aligned with the user's preferred in-app notification language? For instance, users who receive in-app notifications in Arabic sh…
-
How can we migrate FRS reports in MYFOLDERSummary: How can we migrate FRS reports in MYFOLDER from one user to Shared folders by other user? As user 1 does not have access to paste the FRS reports to Shared Fold…
-
Oracle Fusion Receivables – AutoMatch: Application Order for Multiple Transactions with Same MatchSummary: We need clarification on the transaction selection and application order used by the Apply Receipts Using AutoMatch process in Oracle Fusion Cloud Receivables w…
-
DeletedThis post has been deleted. Regards,
-
Report issue when running Carry Forward Purchase Order Budgetary Control Balances processSummary: Hello we are having issue where not all the reports generate when we kick off the Carry Forward Purchase Order Budgetary Control Balances process. We even tried…
-
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat…
-
ExternalReportWSSService and runReportHas anyone gotten ExternalReportWSSService working successfully to run a custom BI Publisher report in Fusion Service Cloud? Trying to confirm whether this is a known-wo…
-
R13.x FSCM BI Cloud Adapter BI View Object flex fields mapping sheetSummary: R13.x FSCM BI Cloud Adapter BI View Object flex fields mapping sheet Content (please ensure you mask any confidential information): flex fields pvo details Vers…
-
Validation of Retained Earnings Transfer Process for Portugal STAT LedgerSummary: We are working on "Create SAFT-PT Audit File for Portugal" We have configured Portugal Statutory Ledger and Data Conversion Level - Journals As part of Business…
-
eText Payment Format in BIP output appending question marksSummary: I have created a custom Disbursement Payment File format using eText, and placed in the Custom folder in BI Publisher to be used in a payment process profile. T…
-
Why Selected Accounting period is not showing start period and end periodSummary: We are developing an FRS report and are using a Range prompt for the Accounting Period parameter. We would like to display the selected accounting period range …
-
Why FRS Range Function with Relative Member Offset Not Returning Expected Period DataSummary: We are encountering an issue in Financial Reporting Studio (FRS) while using the Range function with the Relative Member function to display Current Year (CY) a…
-
custom AI agent to search ar invoices details.Summary: Has anyone Got a custom AI agent to do AR Transaction/invoice Search to work? I can get to work to a point but only brings back info from 2018 thru 2022. It doe…
-
Oracle Fusion Cloud 26C – Deprecated and New BICC View Objects ListSummary: Looking for the list of deprecated and newly introduced BICC View Objects for the Oracle Fusion Cloud 26C release. Content (please ensure you mask any confident…
-
What is the retention period for BIP reports & ESS Jobs in Oracle fusion applicationSummary: We wish to know the retention period of BIP reports & ESS Jobs in Oracle fusion application. Also needed any Oracle documentation that helps in understanding th…
-
CE_GL_AVAILABLE_TRX_VSummary: Historical changes in CE_GL_AVAILABLE_TRX_V definition across Oracle Fusion releases Content (please ensure you mask any confidential information): We are inves…
-
PVO FscmTopModelAM.GregorianCalendarAM.FndCalDay is unavailable on BICCSummary: PVO FscmTopModelAM.GregorianCalendarAM.FndCalDay is not found in BICC application Content (please ensure you mask any confidential information): PVO is missing …
-
Absence DashboardHi , we have created a custom Absence dashboard for our line managers , but they are unable to fetch any data , Currently they have a custom Line_Manager role and the BI…
-
Is there a way to correlate the Personal Payment Method ID and Bank Account ID to actual banksSummary: We can pull audit reports on personal payment methods which include a bank account ID. We would like to correlate that Bank Account ID to an actual bank account…
-
ESS-01035 Unable to determine a logical application name for new request running new jobset in UII am defining a jobset for the first time, to work in financials for Advanced Collections. I have identified how to create the jobset under Manage Enterprise Scheduler J…
-
How to Receive Bounce-Back Notifications for Invalid/Inactive Email Addres in BI Publisher BurstingHi Team, We have implemented a process in Oracle Fusion where BI Publisher bursting is used to send emails to customers. The recipient email addresses are retrieved from…
-
Method to retrieve history of BI Publisher scheduled reports for more than three monthSummary: Currently, we use 'Report Job History' to search user execution history of BIP report. However, the records can just be traced back in 3 months. Is there any wa…