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
-
Subledger Details resulting in Duplicate LinesContent I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a piv… -
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.… -
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… -
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
-
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… -
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…
-
create data model using web serviceContent i need an example for creating data model using web service i need to create a report using data model using web service , how i create a data model and report ?…
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh… -
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …
-
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… -
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… -
LedgerSummary All transaction detailContent Hi experts, I need a report of all single detail of all transactions. Is there any report at "Scheduled Process"? Muhammad Amir Ver… -
Location of the Standard Account Analysis ReportContent Hi all, Are there any direct way to find the location of the standard report ( Account Analysis Report ) in the report and analytics section. Current it shows ma…
-
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…
-
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 … -
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 … -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei… -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an… -
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co…
-
How can I get to the person number from the workflow tables?Summary We need to report out the comments on terminated employees and while I can get to the comments there is no separate column for person number to get to the other …
-
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
Expense Report AnalysisSummary We are trying to improve our reporting on expense reports and add additional fields in our reportsContent We are trying to improve our analysis on expense report…
-
Required-Oracle Fusion financials workshop PPT documentsSummary Required-Oracle Fusion financials workshop PPT documentsContent Required-Oracle Fusion financials workshop PPT documents -
BI Parameter IssueSummary ORA-01795: maximum number of expressions in a list is 1000Content I have a BI Publisher report with a parameter that gets its list of values from a sql query. If…
-
Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsSummary Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsContent Hi, I have business requirement to inactivate a person user account, but not re…
-
Delivered Balance Sheet ReportsSummary Is there a delivered Balance Sheet ReportContent Is there a delivered Balance Sheet Report in Oracle Cloud ERP? Version 21A
-
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
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…
-
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…
-
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…