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
-
Issue with finds captures authorization custom layoutSummary Length() not returning correct value when used with sum()Content Hi Experts, We are in oracle fusion 19D. We are using Oracle Business Intelligence 11.1.1.9.0 I …User_2025-01-30-00-35-05-558 18 views 0 comments 0 points Most recent by User_2025-01-30-00-35-05-558 -
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to … -
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…
-
Creating a Batch in FRS (Oracle Cloud ERP)Summary Creating a Batch in FRS (Oracle Cloud ERP)Content Navigate to Work space for financial Reports I am trying to Schedule a Batch. I believe I need to create a batc… -
Sync COA valuesSummary keep the COA’s in all reporting cubes in syncContent Is there some way to keep the COA’s in all reporting cubes in sync? We have had issued where SMartview does … -
OTBI Dashboard Prompts are not visible in Google Chrome BrowserSummary OTBI Dashboard Prompts are not visible in Google Chrome BrowserContent Hi All, When we open OTBI dashboards in google chrome ( Version: 80.0.3987.149), the dashb… -
Disabl Primary Ledger status is In ProcessSummary Disabl Primary Ledger status is In ProcessContent Hello During create new primary ledger i mistake on ledger name , i create a another one and is work fine but m… -
Limit IT support users to use OTBI within their folder onlySummary Limit IT support users to use OTBI within their folder onlyContent Hi all, is there any way to limit those IT support users to access his/her folder only? Not ab…
-
Open Prepayment OTBI ReportSummary Open Prepayment OTBI Report with Validation status of Available that can be back dated to the prior month.Content I have an Open Prepayment report in OTBI from s…
-
plz clear whether vendor_id in ap_invoices_all and party_id in hz_parties results the sameSummary have a doubt whether vendor_id in ap_invoices_all and party_id in hz_parties should have same valueContent Can we join vendor_id in ap_invoices_all and party_id … -
Sourcing data for BI Publisher Reports from External Data sources including Oracle DBCS/DBAASSummary Building a BI Publisher report in Oracle Fusion Cloud ERP that shall source data from Fusion cloud database and some external data.Content We need to build a BI … -
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie… -
Table "ALL_TABLES" - does not include all tables?Content Hi, When I run a query in BI Publisher Enterprise, I can for example, get results from this query: SELECT DISTINCT UPPER(table_name), num_rowsFROM all_tablesWHER…
-
Oracle ERP Cloud certification for PortugalSummary Cloud certification for PortugalContent Hi, We do business in Portugal and as per the local laws, Portuguese entities and foreign entities established in Portuga… -
Scheduled Report Attachment ProblemSummary Scheduled Report Attachment ProblemContent Hello, We have 2 agents which generate excel format files. One of them attaches excel file correctly. The other one ad…User_2025-02-06-13-32-07-115 19 views 2 comments 0 points Most recent by User_2025-02-06-13-32-07-115
-
Is there any way to run a BIP Data model / Report thru a web service and get the output as a responsSummary Is there any way to run a BIP Data model / Report thru a web service and get the output as a responseContent Hi Friends, Is there any way to run a BIP Data model… -
Can the parent of an account be added to a row in Financial Reporting?Summary Trying to add the parent of the account in a row to a report in Financial ReportingContent I have used member name to add the name of the account to an individua…User_2025-02-06-10-37-19-523 34 views 4 comments 0 points Most recent by User_2025-02-06-10-37-19-523
-
Smart View Install / Uninstall FailuresSummary Admin intervention necessary when deploying latest SV 11.1.2.5.910Content We are trying to get all enterprise users onto the same version of Smart View. We curre…
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…
-
BI Publisher - looking for project status tableContent Hi, Does anyone know where I can find a table that holds the history data for a Project Change status? On the front end the popup appears on our Manage Financial…
-
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…
-
Finance: Can we get Grand Totals from two separate groups in matrix reportSummary Finance: Can we get Grand Totals from two separate groups in matrix reportContent We have developed a custom report in two separate groups in matrix report. In f…
-
Bug 28478515 : AUTOPOST JOURNALS PROCESS FOR MULTIPLE DATA ACCESS SETSummary Unable to perform batch posting by "Batch ID" due to data access set designContent Is there is update or ETA for fixing of this bug? Bug 28478515 : AUTOPOST JOUR…
-
Period 13 and Financial Reporting Prior PeriodSummary How do I bring in December as Prior Period when a report period selection is January of a given yearContent Report works correctly as long as the user is looking…
-
Calculation Between two Presentation Analysis ReportSummary Calculation Between two Presentation Analysis ReportContent Hello i have two analysis report in BI Publisher one for Revenue and other for Cost of good sold i ne…
-
Report completed in errorsSummary OTBI report completed in errorsContent Hi all, I have custom a OTBI report with data model and layout. Also, I have defined the ESS job in SaaS for user to submi…
-
How to extract all project parties via a report?Summary Looking for a way to extract all project parties information via an analytics or bi publisher report.Content In the Project Financial Management web page, throug… -
how to get xml data for process Create Settlement Batches in AR Collections?Summary how to get xml data for process Create Settlement Batches in AR Collections?Content Hi Experts, I'm modifying template for Create Settlement batches program whic…Pradvin Heggar Prabhakar-147626 43 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626
-
SmartView/FRS Alias names for Financial StatementsSummary SmartView/FRS Alias names for Financial StatementsContent We are a fairly new cloud customer and have some questions about how everyone is handling creation of s…User_2025-02-04-18-03-15-131 32 views 0 comments 0 points Most recent by User_2025-02-04-18-03-15-131
-
SmartView Performance/LimitationsSummary SmartView Performance/LimitationsContent We are a fairly new Oracle fusion customer and I'm curious if anyone can explain if there are limitations to SmartView t…User_2025-02-04-18-03-15-131 54 views 4 comments 0 points Most recent by User_2025-02-04-18-03-15-131