Data Models
Discussion List
-
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Execute…maria.stanciu 51 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 31 views 2 comments 0 points Most recent by maria.stanciu General Transactional Reporting (OTBI)
-
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 21 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash K - Deloitte USI 11 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI General Transactional Reporting (OTBI)
-
View/Table details for Data SecuritySummary: Hi Everyone, We have built some custom pages and are looking to apply Fusion security on those pages. In order to do so, we require the Secure View/ Table detai…Maruvada Sanat Kumar-Oracle 11 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 11 views 3 comments 0 points Most recent by Mike Burnett General Transactional Reporting (OTBI)
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 17 views 2 comments 4 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
How to fix an RTF report related error in OBIEESummary In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the errorContent Hello Oracle Team, In OBIEE, w…Jonathan Chan gmg 20 views 3 comments 2 points Most recent by Arghyo Banerjee -Oracle General Transactional Reporting (OTBI)
-
Table Documentation - Data Source: AuditViewDBContent Hi all - I cannot find documentation for the data source AuditViewDB. I have the documentation for the data source ApplicationDB_HCM (https://docs.oracle.com/en/…Prudence K 23 views 5 comments 0 points Most recent by Anil Kola-Oracle General Transactional Reporting (OTBI)
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parametersContent Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe…
-
Row Count - Auditor RequestContent Hi all - is it possible to add a row count to our reports, so we know how many rows are expected in the final output? If I am understanding the tool correctly, t…Prudence K 13 views 2 comments 2 points Most recent by Prudence K General Transactional Reporting (OTBI)
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite…
-
OAC - SaaS Data Replication Functionality CapacityContent Hi Team, is there any limitation to row count to be extracted via OAC - SAAS Data replication functionality. We are planning to bring data from Oracle SaaS Fin, …AnkitR Gupta 19 views 2 comments 1 point Most recent by AnkitR Gupta General Transactional Reporting (OTBI)
-
AR Aging Bucket (Fusion OTBI)Content I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket but there is no subject that is called aging I tri…Maram Abuzaid 73 views 1 comment 0 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI)
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errorsContent Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here I…Dhanuka Chamal 26 views 3 comments 3 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI)
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 47 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
Wrap Text in MHTML formatSummary Wrap Text in MHTML formatContent Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wan…VAIDIA 12 views 1 comment 1 point Most recent by SantoshKumarBhairi General Transactional Reporting (OTBI)
-
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t…MaartenDIF 67 views 16 comments 11 points Most recent by MaartenDIF General Transactional Reporting (OTBI)
-
Meaning of Oracle table name with and without "_" at its end?Summary What is the difference between Oracle tables named with and without "_" at the end?Content Hello Oracle Community, 1) What's the difference between Oracle tables…Jonathan Chan gmg 22 views 2 comments 3 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to correctly script the "OR" function in Group Filter section in Data Model in OBIEE?Summary In OBIEE, an error was prompted when I was scripting the "OR" function in Group Filter section of the Data Model interface.Content Hello Oracle community, In OBI…Jonathan Chan gmg 10 views 4 comments 2 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to pick mulitple fields into table box when buidling report using data model?Summary How to pick mulitple fields into table box when buidling report using data model?Content Hello Oracle Community, When building report using data model, in the "C…Jonathan Chan gmg 11 views 14 comments 2 points Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
Custom PO Print - Text Attachment Content on BI Publisher ReportSummary We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Docu…Rahul L 25 views 2 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi PublisherContent Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shoul…Alberto Romani-Oracle 24 views 3 comments 2 points Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
Pivot table in rtf bi publisher 12cSummary Edit for-each to fetch on another for-each-groupContent Hello developers, In pivot table, it fetch all empcode with respective to the cross table but in my case…Osama Fawzy 22 views 1 comment 1 point Most recent by Osama Fawzy General Transactional Reporting (OTBI)
-
Can data model data be called out by infolets on Oracle Cloud/Fusion?Summary In addition to analysis data, can data model information be added to infolet on Oracle Cloud/Fusion?Content Hello Oracle Community, Is there anyway to post data …Jonathan Chan gmg 15 views 6 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent Hi, We need to fetch the pending transaction Transfer details like New Loc…Nirmal Kumar L 23 views 1 comment 1 point Most recent by User_OWH0W General Transactional Reporting (OTBI)
-
Scheduled Report JobsSummary Deails of Scheduled Report JobsContent Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI or…Charan Kollipara 54 views 8 comments 1 point Most recent by Akshay Aiyer General Transactional Reporting (OTBI)
-
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of useContent Hi All, I am looking for ways to monitor the performance of OTBI Reports in fussi…Fongang 54 views 6 comments 1 point Most recent by AshishERPCloud General Transactional Reporting (OTBI)
-
Report on SocialSummary Need to create a report on Application SocialContent Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select fr…