BI Publisher Data Models
Discussion List
-
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… -
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEEContent Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Objec…edpalomo 12 views 2 comments 0 points Most recent by edpalomo General Transactional Reporting (OTBI)
-
Extracting Goal SuccessCriteriaText from hrc_txn_data that is greater than 4000 Characters using OraSummary Extracting SuccessCriteriaText for Performance Goals in Draft or Pending Approval from hrc_txn_data using SQL when SuccessCriteriaText is having more than 4000 C…Ravindra Paidiparthi 10 views 0 comments 0 points Started by Ravindra Paidiparthi 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 - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…
-
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)
-
BI Published Report Date VariablesSummary Date variable for previous monthContent Hello, I was on this site: https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.h…Stephanie Gott 19 views 3 comments 0 points Most recent by Sahil Makhiza 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 SantoshKumarB 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 66 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)
-
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog?Content In our PROD pod, we have several folders under the custom folder location that inclu…User_VR8E0 39 views 4 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)
-
BIP compress output prior deliverySummary Compress output prior deliveryContent To divide the large data set in multiple data set in OTBI we have option to use bursting. By using bursting we have written…Niketa Ashwini 23 views 9 comments 1 point 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) -
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) -
call a procedure on oracle bi publisher 12cSummary oracle bi publisher add Global-Level Element by PL/SQLContent Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data mode…Osama Fawzy 39 views 2 comments 2 points Most recent by Osama Fawzy 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…
-
What is catalog folder Extension?Summary Does anyone know the purpose of the empty shared folder Extension in the catalog?Content The folder is empty. A duty role exists for it, BI_EXT_REPORTING_DUTY, b… -
Java.sql.SQLException: Invalid column indexSummary Errors out with the mesaageContent Hello There, We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution it…
-
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …Visu 64 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 General Transactional Reporting (OTBI)
-
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspa…User_AEMC1 18 views 2 comments 3 points Most recent by user650055 General Transactional Reporting (OTBI) -
how to connect to Bi publisher administer console in fusion 19C?Summary How to access the bi publisher administer console in fusion 19c?Content I have added some roles to my fusion account. But, I cannot see the bi publisher administ…Geetha Devi 15 views 11 comments 1 point Most recent by Geetha Devi General Transactional Reporting (OTBI)
-
Security Console TablesContent Hi Everyone Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the rig…Aaron Leggett 127 views 5 comments 0 points Most recent by Karthik Vinodkumar General Transactional Reporting (OTBI) -
Get privilege to issue logical SQL in OTBISummary As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log …Nathan CCC 23 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Audit History to access changes made in BIP Data ModelSummary Require table or methods to find out changes done in BIP Data ModelContent Hi, We have encountered an issue recently where the data model query were updated by s…User_O1YC5 36 views 2 comments 0 points Most recent by Joel Acha General Transactional Reporting (OTBI)