Sample Reports
Discussion List
-
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 119 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
Need A SQL query to get the supplier contact address detailsSummary Need A SQL query to get the supplier contact address detailsContent Need A SQL query to get the supplier contact address details Here I have attached the screens…Koteswararao Yenikepalli 351 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM -
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 197 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP -
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…User720640-Oracle 152 views 8 comments 2 points Most recent by Becki Willard Reporting & Analytics for Sales -
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …Tony Roff 52 views 5 comments 0 points Most recent by User_2025-02-01-08-03-13-309 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 57 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…Tony Roff 47 views 4 comments 0 points Most recent by Koteswararao Yenikepalli 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…User_2025-02-05-23-22-49-102 108 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
R13 Avaliable Cloud Reports in ExcelSummary Avaliable Cloud Reports in ExcelContent Hello : I was wondering if you can share with me the avaliable Cloud Reports in Excel. Thanks for your help Best Regardsgabriel kinovisques-163562 62 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to Incur Accruals for Indirect ProjectsSummary Expense Accruals for indirect Projects Content Hello : We have a business requirement : The company provide one benefit to the employee called Mobile Phone for M…gabriel kinovisques-163562 57 views 1 comment 0 points Most recent by Shifa Nazumudeen Project Management
-
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19CTony Roff 47 views 1 comment 1 point Most recent by User_2025-02-06-00-59-55-679 Reporting and Analytics for ERP
-
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat…
-
Policy Predicate ErrorSummary When querying some tables and views we are getting Policy Predicate ErrorContent Selecting data from per_person_names_f or hz_parties is giving a policy predicat…User_2025-02-05-18-28-58-388 36 views 12 comments 1 point Most recent by Nathan CCC 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…User_2025-01-29-01-36-29-977 142 views 4 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
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… -
Provide access to Review Project Performance WorkareaSummary Provide access to Review Project Performance Workarea for Project administratorContent Hello, Using Project portfolio management cloud - Project financial manage…User_2025-02-04-13-08-33-519 67 views 1 comment 1 point Most recent by Dustin Grabowski-Oracle Project Management
-
Error while customizing BI Publisher ReportSummary We are trying to customize the Account Analysis Report (ESS Job Name - Account Analysis Report) but getting error while trying to modify the data modelContent Hi…Sudha KOVURU 131 views 10 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
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…User_2025-02-01-07-43-15-700 59 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…User_2025-02-05-07-46-04-895 123 views 3 comments 2 points Most recent by Rasu P 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 586 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
BI Cloud Connector (BICC) White paper or DocumentsSummary Looking for Information on How to create Extract using BICCContent Hi, I need to send incremental feed of Data such as Customer , Supplier, GRN and POs to anothe…Prateek Parasar - GTUK, ACE Pro 240 views 6 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro 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…
-
rtf template - display constant text on every pageContent Hi All, I have a rtf template which contains nothing but a (row*column) table. I need to display a constant text like "Hello" at the bottom of every page, other …Rinku Gautam 95 views 12 comments 1 point Most recent by Sudha KOVURU Reporting and Analytics for ERP
-
Subledger Distributions to General LedgerSummary Subledger Distributions to General LedgerContent All-> Need to show the amounts of Invoice distributions/Matched/not matched POs related to Payables payments/rec…
-
Security In Data ModelSummary How to restrict user by not getting data of other BU in BIP ReportContent Hi Champs, Let's say my user 'A' has access to only 'X' Business Unit. How should BIP d…Manish Pesswani 124 views 2 comments 2 points Most recent by Mrigank Sharma Reporting and Analytics for SCM -
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…