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
-
Is there a way to pass parameters to an Infolet?Summary Need to convert a report that passes a parameter into an infolet so I can easily share it with many users that are not familiar with running BI Publisher reports… -
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 … -
(CURRENT_DATE)-1 in OTBI Analysis Prompts SectionSummary (CURRENT_DATE)-1 in OTBI Analysis Prompts SectionContent Do you know how can this be used in Prompts. I have a Date Prompt and need to default the date as (CURRE… -
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…
-
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… -
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… -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…
-
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 … -
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…
-
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 …
-
Print Receivables TransactionContent Hi, I have three custom templates for Invoice each for different transaction type. When I submit Print Receivables Transaction ESS Job without entering any param… -
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.