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 format an OTBI report to see the total amount spent in a specific account by month?Summary: Within the expense reporting template, I am trying to create a report that will show the amount spent in a specific account by month. For example, the amount sp… -
FinancialsCommonEntities failedSummary: I am using rapid implementation template to load FinancialsCommonEntities. after loading i am getting error message for address Legal locations import failed. o… -
Invoice Payment Report with Journal InformationSummary: Invoice Payment Report with Journal Information Content (required): We are looking for a report that contains invoice details (number, amount, date, etc.), the … -
How to create dependent parameter using table valueset for ESS Job?Summary: How to create dependent parameters using a table value set for ESS Job? Content (required): Hi All, How to create dependent parameters using a table value set f…
-
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. …
-
How to create ESS for custom report in multiple languages?Summary: Suppose a custom report whose layout is already available in multiple languages (multiple xlf files). First I logged in EN language, went to the Manage Enterpri… -
How to join multiple subject areas into one analysisSummary: Requirement to join multiple subject areas in one analysis Content (required): I need to successfully join the following three subject areas: Receivables - Tran…
-
Is it somehow possible to work dynamically with BIP reports directly in Excel?Content (required): Hi all, Is it somehow possible to work dynamically with BIP reports directly in Excel? Hence, have the layout of the BIP reports with the same parame…Daniel Lundsteen Minke 42 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle -
OTBI Access and SQL Query ViewHi For OTBI Report Creation - the access is incomplete. Please observe the Create --> Published Reporting and Actionable Intelligence - only two options What all are the…
-
FRS report not showing Budget ScenarioSummary: Content (required): Hi, The "Budget" scenario is not visible in Financial Reporting Studio report creation. We have uploaded all required control budgets and ha…
-
OAC Essbase Add-In for Google SheetSummary: Are we able to use smart view in Google sheet? We have heard about OAC Essbase Add-in, Will it replace Smart View for Google sheet? Also, while adding the plug-…
-
How to get the GL Segments Flex value set IDs for seeded and custom segments from EBS R12 DBSummary: EBS R12 SQL or base tables to fetch GL Segments Flex value set IDs for seeded and custom segments. Content (required): There is a need to fetch GL Segments Flex…
-
View the SQL statementSummary View the SQL StatementContent Hi all, In the previous version I mean eBIS R12, I can see the sql statement from the form (Tools > System > select "Last Query"), …
-
Error in join subject area Purchasing Real Time and Requisition real TimeSummary: Hi Team, We are trying to join the subject area Purchasing Real-time and Requisition Real-time, but getting error as below- Error Codes: OPR4ONWY:U9IM8TAC:U9IM8…
-
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… -
Is it possible to generate csv file with column labels of child records even when they don't exist?Summary: Standard BI Publisher behavior is that column labels are not generated for columns of child records when they don't exist. Example: Data Model queries: Data Set…User_2025-02-11-06-12-35-024 31 views 4 comments 0 points Most recent by User_2025-02-11-06-12-35-024
-
Customise standard report - new layoutSummary: Standard report which only runs inside Fusion ERP. How to use sample data xml export in Fusion BI Publisher? Content (required): So I have a standard report whi…
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…
-
How to create a Cross-Tab reporting using BIP Excel TemplateSummary: How to create a Cross-Tab reporting using BIP Excel Template Content (required): Hi, We have a complex report layout and we have to develop it using BIP Excel T…
-
ERP – Workflow Transaction Console, 1 April 2020, 9 a.m. PT - Submit QuestionsContent Submit your questions for the ERP – Workflow Transaction Console session to have them answered during the live event. Post your questions by posting a new commen…
-
How to restrict custom folder created in dashboardSummary: How to restrict custom folder created in dashboard Content (required): Hi Experts, We have created one custom folder and included all the custom reports in the …
-
Invoice Approval Workflow - Pending with which approverHi, Business Scenario: In AP Invoice Approval Workflow - if an invoice shall be going through five approvers in all during BPM Workflow Business would like to generate t…
-
GL/SLA Account Analysis Report - Custom Spreadsheet Output FormatSummary Custom BIP template for the Account Analysis Report that displays GL/SLA journal line output in a spreadsheet format for easier searching and filteringContent * …
-
Moved: BPM Workflow Invoice Approval - Standard ReportThis discussion has been moved. -
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …
-
Give us your feedback - OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…
-
Report definition not found:/Custom/Financials/Payables/Invoices/****.xdoSummary: I keep getting the Report definition not found:/Custom/Financials/Payables/Invoices/****.xdo error Content (required): I keep getting the Report definition not …
-
DFF are not visible in Payables Payments - Disbursements Real TimeSummary: Hi All, We have created global DFF on AP_CHECKS (table) and made it BI enabled, but it's not visible in "Payables Payments - Disbursements Real Time" subject ar…
-
Calculated measure questionSummary: Building multiple columns based on aging Content (required): I have defined a report that gives me the amount due on an invoice and it's related aging value. I …