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
-
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 41 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 33 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
-
Search not working for LOV in BI Publisher ReportSummary Search not working for LOV in BI Publisher ReportContent Hi Team, I have created LOV through SQL in BI Publisher Report. If i am using value without transforming…
-
NEW Analytics for ERP - 20ASummary NEW Analytics for ERP - 20AContent Hi, We have now 20A, but Oracle new buit in Analytics for ERP is not available, any idea on ERP analytics. Regards,Farooq Syed, CPA, PMP, CISA, TOGAF 87 views 3 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF -
Export FRS reports as *.DES extension fileSummary Export FRS reports in 19D as *.DES extension fileContent Hi, Does anyone know how to export FRS reports as *.DES extension file ? Thnx Version R13 - 19D updates
-
How to Add notifications to already scheduled ESS jobsSummary is it possible to edit the scheduled ess job to add the notifications ?Content Hello Guru's is it possible to edit the scheduled ess job to add the notifications… -
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…
-
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
OTBI Action Link not passing parameter when complex logical query is usedSummary OTBI Action Link not passing parameter to another BI Content when complex logical query is usedContent In general, if we create OTBI analysis from a single subje…