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
-
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… -
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
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…
-
Issue during passing a parameter to OTBI analysis in Page Composer doesn't workIssue during passing a parameter to OTBI analysis in Page Composer doesn't work Description : I am trying to do page customization using the page composer for the "BPA C…
-
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and… -
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
-
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…
-
Is it possible to generate a list of Oracle Fusion users and the method they use for authenticationSummary: Is it possible to generate a list of Oracle Fusion users and the method they use for authentication (SSO or Local authentication)? Content (required): Is there …
-
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…
-
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 …
-
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…
-
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS report
-
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 …
-
Unmask Bank Account number in BI Reports only based in certain user roleSummary Unmask bank accounts in reports based on user rolesContent Hi , I have been able to generate a simple report to show some Suppliers details with bank accounts fo…
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …
-
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…
-
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…
-
Table to get user password expiration dateSummary: Table to get user password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a report. …
-
campaign emails are still not being delivered to employeesSummary: Hi Team, I am facing an issue with HCM Communicate campaign email delivery in our DEV environment. I created and activated the campaign successfully, scheduled … -
How to include invoice attachments from UCM on bursted email outputI have created a custom email notification for invoices requiring receipts. I am using an RTF template for the email body and would like to include manually uploaded inv…
-
Query to fetch the report columns name in oracle fusion.Is there any query to find the Report columns Name , Report Path, Report Name Oracle fusion. There are various kinds of report present in the instance such as BI report …
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, Nishanth -
ESS.REQUEST_HISTORY table state column meaningin which oracle fusion financials, Fusion_ORA_ESS.REQUEST_HISTORY there is a columns named 'State' which shows 12,11,10 values. What is meaning of it. It seems that ESS …
-
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 …
-
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…
-
Rest API or SOAP service to list down user folders under /users folders of fusion BIPSummary: We have a requirement to get all user folders and objects under /users (my folders). Is there any way to extract the user folder list. Content (please ensure yo…
-
Where can I get OTBI sample seeded financial reports?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How does "Generate Revenue" determine what accounting date to assign to ProjectsSummary: How does "Generate Revenue" determine what accounting date to assign to Projects Content (please ensure you mask any confidential information): I am trying to u…