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
-
Display OTBI DashboardContent Hi, I have dashboard report called P2P OTBI Dashboard and to invoke from Procurement Tab I created new page from Page Integration and make it visible from Struct… -
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period … -
How to create lov field in fusion reportsContent Dear , We have some location so we need lov paramter on report so user select specific location but how i create lov in reports. I tried to create in manage list… -
BI Publisher domain whitelisting - creating exceptions to send out supplier communications?Content We've created a whitelist of Allowed Email Recipient Domains for BI Publisher which is working well for restricting communications and enforcing our Data Loss Pr… -
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR… -
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp… -
AFLOGSummary Value Changing AuditContent Hello everyone, In regards to this process, How To Enable Finest AFLOG Level (Doc ID 2525522.1), is there a business event or other f… -
Receiving - Purchase Receipts Real Time returns no data for ReceiptContent Hi, We have a requirement to create a report that provides details for Receipts. I'm trying to build the report using the Receiving - Purchase Receipts Real Time…
-
Manage Data AccessSummary Data Access controlContent We need to control users accessing all available business unit and it should be limited to a specific business unit. Scenario :- , Bot… -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21B
-
Oracle Fusion Cloud - SQL script logic to calculate Period to Date (PTD), Quarter to Date (QTD) andSummary We are working on Custom Trial Balance Report development and need logic to calculate PTD, QTD and YTD Balances into Oracle Fusion Cloud.Content Hi Team, We are …
-
Navigation : My Enterprise -> EnterpriseSummary My Enterprise -> EnterpriseContent Hi, I am trying to navigate to t My Enterprise -> Enterprise menu from the home page. Even if i have all the relevant applicat…
-
21b Upgrade causes Data Models to FailSummary 21b upgrade has failed testing because of failed to load servlet/dmvalidate errorContent We have had 21b on our 3 test environments and it caused an issue that i…
-
ERP Data Deletion/Data RetentionSummary Guidance on capability/ best practice for data retention within Cloud ERPContent Would like more information on the capabilities within cloud to purge/remove dat… -
Ability to export configuration in readable format (like OC Autoconfigurator)Summary Users want to export setup data to check the configuration, but currently only zip package export are supported, and the data is not the same as what we view on …
-
tables that stores the submission of BI Publisher reports which are not scheduledSummary tables that stores the submission of BI Publisher reports which are not scheduledContent Hello, Are there any tables that stores the submission of BI Publisher r… -
Finance Cross Validation RulesContent Other than the help guide are there any Best Practices for Cross-Validation Rules? Version 21A -
what is the difference between YTD AND QTD ?Content what is the difference between YTD AND QTD ? Special in first period.
-
How can i get two different BU BalancesContent Dear , I have one ledger but two Business units. For that i need balances for both Business units. So create a query from gl_balances table but issue is its show…
-
Help with OTBI Filter ErrorSummary Error when filtering for a date rangeContent Hello, I am having 2 issues. 1. I am trying to create a filter using Invoice Date where report would show all invoic…
-
how i get gl date in ar moduleContent i created a new report in ar ar module, i use table RA_CUSTOMER_TRX_ALL but i can't find gl date for invoice, how i get gl date ?
-
End date or disable a primary ledger in FusionSummary End date or disable a primary ledger in FusionContent Hi Team, There is a requirement from client to remove the not required ledgers from the system. Is there a …
-
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…
-
How to Drill down from Parent to child report in OTBI?Content Hello, For GL module, We need to drill down from summary to detail in OTBI subject areas. In summary report we have header_id, When we click header_id in summary…
-
What table does Configuration Owner field come from?Summary Receivable module - What table does Configuration Owner field come from?
-
FRS Reports - Suppression of Formula RowSummary In FRS Report tool, if I insert a Formula Row (multiple), is there a way to suppress this row if it is 0.00?Content I recently created an FRS report using the FR…
-
Expenses - Expense Transactions Real Time "The specified criteria didn't result in any data."Content Hi When I'm trying to build a simple report with the subject area Expenses - Expense Transactions Real Time I only get "The specified criteria didn't result in a…
-
ERP - Testing Automation ToolsContent We would like to know of any success stories of companies who have automated their testing in Oracle ERP (Financials or Procurement). I've been looking around, a…