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 can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific users -
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display… -
Can we call Lookup value in OTBI analysis?Summary Calling up Lookup value in OTBI analsyisContent We are setting up an OTBI analysis using 'Subledger Accounting- Journals real time'. We want to call look up valu… -
Passing comma seperated parameter values through SOAP requestSummary Passing comma seperated parameter values through SOAP requestContent I running a BI Publisher report through SOAP request. the BI Publisher data model contain th… -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ… -
"Procurement - Requsition real time" x "Workforce Profiles - Model profiles real time"Summary Relate procurement with workforce to get department nameContent Hi, We are trying to relate the procurement requisition real time subject area with the workforce… -
Remaining Life of an Asset in Fixed AssetsContent What is the query to calculate the remaining life of an asset year and months wise in oracle fixed assets.? -
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have… -
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 17 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557 -
BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f… -
can i create report from subject area ?Content as i create report from data model. can i create report from OTBI subject area ? -
create analysis include onhand quantity and available to reserveContent in inventory i want to use otbi to create analysis include onhand quantity and available to reserve -
Cross subject area - on which facts are they joined?Content Hi there I have joined two subject areas - Expenses - Expense Transaction details real time - Workforce Management - Work Relationship Real time to get level 2 d… -
How to add more descriptive flexfields in Business UnitsSummary How to add more descriptive flexfields in Business UnitsContent Hi We would like to ask if there is a way to add more descriptive flexfields in Business Units? T…User_2025-02-11-12-30-38-982 37 views 1 comment 0 points Most recent by Vaishnavi Aryasomayajula-Oracle -
SQL STATEMENT FOA FIXED ASSET DETAILSContent I NEED A SQL STATEMENT FOA FIXED ASSET DETAILS. -
Cancelling other users scheduled processesContent Hello: We have been looked at documents 1467664 & 1980772 for viewing other Users' scheduled processes, but what our IT has tried, is not enabling a User to open… -
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem… -
i need a query to get available to reserve to item at subinventory levelContent i need a query to get available to reserve to item at subinventory level -
Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Summary Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Content Is it possible to run BI Publisher reports from excel ( Oracle ERP Cloud SAAS ) ? if so then… -
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking … -
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve… -
Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR AgContent Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR Aging report from scratch but lot of logic is hidden in stored … -
create if condition in bi in add element by expressionContent i need to create element by expression and use if condition . how i create if condition in add element by expression ? (with example please) -
Fusion Applications - Task - Manage Set Assignments for Set Determinant Type - What is the Purpose??Summary For a specific Reference Group Name what is the purpose of associating Determinant Value and Set Name ?Content While exploring the Reference Data Set aspects hav… -
Knowledge Foundation SOAP connections are no longer availableSummary Knowledge Foundation SOAP connections are no longer availableContent Knowledge Foundation SOAP connections are no longer available https:///cgi-bin/.cfg/services…User_2025-02-03-22-06-34-432 15 views 0 comments 0 points Most recent by User_2025-02-03-22-06-34-432 -
Query to find instance refresh /clone date in FusionContent Hi All, Like we used to have below query in EBS to get instance clone date , what table is used in fusion. SELECT resetlogs_time FROM v$database; Any help is rea… -
Beginning and Ending balance in Subject Area "Fixed Assets - Asset Balances Real Time" not showing cContent Hi all I'm trying to build a Fixed assets balance, based on the Subject Area "Fixed Assets - Asset Balances Real Time". For some reason it shows the wrong deprec… -
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi… -
Table to get Task Details from Strategy assigned to customerSummary Table to get Task Details from Strategy assigned to customerContent Hello, We are unable to find the table to get Task Details from Strategy assigned to customer… -
Need the mapping of Job Application Names EarHcmEss and FscmSummary Need the mapping of Job Application Names EarHcmEss and FscmContent We have a requirement to create a custom report of the ESS Job Execution details. We want to …