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
-
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… -
Need to join customer and organization using SQL queryContent Hello Team, Does anyone have an idea about how to join the customer and organization(business unit) without including ra_customer_trx_all table? Please do the ne…
-
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…
-
AR_CUSTOMERS table from R12 to FusionSummary Suggest AR_CUSTOMERS table from R12 to FusionContent Please, can anyone suggest AR_CUSTOMERS table in Fusion Cloud -
How to extract OBIEE report output using webserviceSummary How to extract OBIEE report output using web serviceContent Hi All, We have requirement like to insert the OTM cloud report output into Oracle Database table. If…
-
Check In / Check Out Functionality in BIP/OTBI?Summary We are looking for a function that allows code to be 'locked' if checked out by another user.Content Does anyone have ideas on how to 'check out' a data model or… -
Power BI with Oracle CloudContent Hi, Has anyone worked on integrating Power BI with Oracle Cloud. Kindly share details if any Thanks -
What is the limitation for BIP output to SFTPSummary What is the limitation for BIP output to SFTPContent Hi Team, What is the file size limitation to send the BIP output file from BIP server to SFTP. Thanks in Adv…
-
How to send BIP output to SFTP in Zip formetSummary How to send BIP output to SFTP in Zip formetContent Hi Team, We have a requirement to Send the BIP report output in ZIP to SFTP. is there any way to achive this?…
-
Barcode in BI ReportsContent Hi, I have installed Code-128a font and made font mapping still I found I find junk characters for the tags What could be the other possible issues Thanks
-
Using parameter within data modelSummary Using parameter within data modelContent Hi, I am using the following parameter within a BI Publisher data model sql where clause : AND PARTY.PARTY_NAME IN DECOD…
-
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… -
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…
-
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…
-
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…
-
Monitor Process details using SQL - can't find Process 'Name'Summary Reports & Analytics - Process RequestsContent Hi Have scripted the process requests to include all parameter details into an audit report but am unable to a link…
-
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…
-
Table and Field to show date role was added to a userSummary Table and Field to show date role was added to a userContent looking for the sql table and field to show the date a role was added to a user. thanks. -
Webservice for Fusion Data ModelContent Hi, Is there any Web API (SOAP or REST) to access Fusion Database objects as read only mode Thanks
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…
-
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…
-
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… -
Web API for Financials/SCM ReportsContent Hi, Is there any webservices SOAP/REST available to access seeded ERP Financial reports Thanks
-
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 44 views 0 comments 0 points Most recent by Pradvin Heggar Prabhakar-147626
-
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…
-
Scheduling Cash to GL Recon BI Publisher ReportSummary Has anyone had any success with scheduling the Cash to GL Reconciliation BI Publisher Report?Content We have a request from business users to schedule this repor…
-
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, -
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…
-
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