OBIEE Answers
Discussion List
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…Austin Cox-148352 100 views 3 comments 2 points Most recent by Andrew_Schmitz 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
-
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…Jon Sulcer 208 views 3 comments 5 points Most recent by Bryan Holland-181285 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
-
OTBI bar graph formatting for gradient not workingContent I've created a dashboard and saved the supporting analyses and prompts in My Folders. When I copied it to a shared custom folder, no one in my company could view…Mike Burnett 23 views 5 comments 0 points Most recent by Senthilrajan V 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
-
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 -
Displaying the PO MATCHED DATE from the Procurement Subject areaSummary Displaying the PO MATCHED DATE in PO Details report.Content I want to display PO Matched Date and PO receipt date in my PO Details report. for the receipt date i…Dharmendra Jha-160968 36 views 1 comment 0 points Most recent by Marybeth Snodgrass Reporting and Analytics for ERP
-
OBIEE 12c / Financial Reporting Studio usage with Oracle Fusion Financial CloudSummary Financial Reporting Studio for Customized Reporting needContent Hi, With earlier releases of on premise ERP products from Oracle we used OBIA for any seeded / cu…
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Reports based on SaaS extensions built in PaaSSummary How to created reports consolidating data from JCS-SX and ERP CloudContent Does any one have a documentation or experience on what's is the best way to achive th… -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…Balaji Paripati-112966 59 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Receiving Error When Prompting Values from Field Created from a Case StatementSummary Cannot function ship the following expression: EVALUATE. (HY000)Content I have created a Dashboard Analysis and Prompt from the following subject area: Subledger…Kamran Butt-161785 24 views 0 comments 1 point Most recent by Kamran Butt-161785 Reporting and Analytics for ERP
-
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t…Thiru Vedantham 284 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…Kamran Butt-161785 55 views 4 comments 0 points Most recent by Kamran Butt-161785 Reporting and Analytics for ERP
-
XML file for Disbursement Payment FormatsSummary XML file for Disbursement Payment FormatsContent All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need…
-
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…Kamran Butt-161785 87 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
What is the Data Model that runs the 'General Ledger and Subledger Account Analysis' Report?Content Hi All, There is a report run via a scheduled process called 'General Ledger and Subledger Account Analysis'. The report is extremely useful and we would like to…Aaron Leggett 186 views 10 comments 2 points Most recent by Bharath Dondapati Reporting and Analytics for ERP -
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line…
-
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…Elliot Hall-Walker 43 views 3 comments 0 points Most recent by Elliot Hall-Walker Reporting and Analytics for ERP
-
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,
-
Permissions or custom roles to view only OTBI or BIP reportsSummary I need to enable a SCM roles users to just display custom financial reports which created by using BI publisher or OTBI.Content I need to enable a SCM roles user…Mohamed Mahmoud-157904 72 views 9 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…Avesh Ganodwala-57885 203 views 0 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
Invoice Approval and Notification InformationSummary Cannot find the table name for Invoice Approval and Notification InformationContent We want to extract details of Invoice Approval and Notification Information b…Dave Dengate 64 views 3 comments 0 points Most recent by Izharul Haq-163043 Reporting and Analytics for ERP
-
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…Praveen Kumar-156819 93 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP