OBI Answers
Discussion List
-
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage … -
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…Nageshwaran1 98 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold… -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
Spend calculations - Procure-To-Pay Subject AreasSummary How is Spend value calculated in Procure-To-Pay Subject AreasContent Gurus, Looking at seeded 'Top 10 Spend by Category' OTBI report and see Spend column. Wonder…Manoj Acc 48 views 1 comment 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 254 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP
-
How to increase the query time out in Oracle fusion BIPContent Hi Team, One of report is getting error due to query time out. We want to increase the query time out for this report. Could you please do the needful. Version 2…Jayaprakash Mathakamalli 170 views 6 comments 0 points Most recent by Jayaprakash Mathakamalli Reporting and Analytics for ERP
-
Fixed Assets - Asset Balances Real TimeSummary Assets OTBI Report for CIP not showing balancesContent Hi FA Experts, We built an OTBI report with Fixed Assets - Balances Real Time Subject area to display bala…Muhammad Hamza Hanif 153 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
How to remove html tags from report outputContent Hi team, We built some Analysis based on Sourcing related subject area's Where we see some html texts in the resulting columns like below. How remove these sufix…Nishanth B Jain 138 views 5 comments 0 points Most recent by Anandakrishna Thamballa Reporting and Analytics for ERP -
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 63 views 3 comments 1 point Most recent by rajArun Reporting and Analytics for ERP
-
How to query all expensesSummary How to I set up the user of my analysis on a dashboard so that they can see all expenses? By default it seem my user can see only my own expenses and those of th… -
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…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
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…Nageshwaran1 707 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
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…OraFusionworld 55 views 0 comments 1 point Most recent by OraFusionworld Reporting and Analytics for ERP
-
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…Shlomo Elnekave 56 views 8 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
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…
-
Customer Balance ReportSummary Customer Balance Report show me balance for All customerContent Hello i need report show customer,Transaction Type(Invoice,Credit Memo,Debit Memo,Receipt),Debit,…Mahgoub S.Mohamed 113 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…Kamran Butt-161785 45 views 10 comments 2 points Most recent by Kamran Butt-161785 Reporting and Analytics for ERP
-
How do i put in multiple columns in the x axis of a rtf chart?Summary X axis contains values coming from a column and rtf does not allow multiple entries into the x axis label.Sumanth Kunimakki-21932 34 views 0 comments 1 point Most recent by Sumanth Kunimakki-21932 Reporting and Analytics for ERP
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 123 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …Pavan Kasetty-180278 53 views 5 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Instance details for BI Publisher Report Template - Fusion ERP/SCMSummary Water marking Instance details on BI Publisher Report and EmailingContent We have a requirement to display the Instance name as watermark in some of the BI Publi…Senthilrajan V 62 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
How to use Seniority Date in Analysis?Summary 19D release includes new Seniority Date fields which I can't figure out how to useContent Hi, According to the documentation for the 19D release, Seniority Date …User_CNUC9 88 views 5 comments 0 points Most recent by Marybeth Snodgrass Reporting and Analytics for ERP
-
Combing OTBI Output in one rowSummary Combing OTBI Output in one rowContent I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Li…Rajanikanth Mohanraju-181261 102 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BICS migration to OACSummary BICS migration to OACContent Hi All we have BICS on Paas which is not implemented yet and Oracle recommend to migrate to OAC. We need to know do we really need t…Mahgoub S.Mohamed 28 views 7 comments 1 point Most recent by Mark_Daynes Reporting and Analytics for ERP
-
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 89 views 0 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for ERP -
Deprecating BI Publisher connectivity to the Oracle Fusion TablesSummary Restricting access to Fusion Cloud database via BI Publisher Data ModelContent Heard that Oracle is planning is to restrict the access to Oracle Fusion cloud tab…Senthilrajan V 70 views 7 comments 3 points Most recent by Manish Pesswani Reporting and Analytics for ERP