SQL
Discussion List
-
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 11 views 1 comment 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) -
Adapting Previously Used SQLSummary: Amending a BIP Report we have that's not pulling the correct results back Content (required): Hi all, Apologies if this is the wrong place to ask. I've been ask…
-
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 33 views 8 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
SQL/report to get the list of consultants (not having Person ID)We are looking for a user/role report that list users firstname/lastname/email and roles. The report we have only lists if they are linked to a person record. We have co…Vijay Ramani VJ 11 views 4 comments 0 points Most recent by Vijay Ramani VJ 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) -
Where do I find DFF's in subject area Workforce Management - Documents of Record Real TimeSummary: I am attempting to build a report using the Workforce Management - Documents of Record Real Time I have managed to get to the Document Type Vacation Carryover A…PamS 21 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…Scott McAnally 12 views 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 11 views 10 comments 0 points Most recent by Matthew Voss General Transactional Reporting (OTBI) -
Is there a way to find what reports/anaylsis are set up for Bursting?Summary Is there a way to find what reports/anaylsis are set up for Bursting?Content Hello I need to find out what reports/analysis have been created and set to burst ou…Helen Thomas-53877 48 views 6 comments 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
Help with an OTBI or SQL query to produce a list of all job codes with Grade informationSummary: Hi All, I am hoping someone can help me - I have been struggling with a report request for a while now and I didn't think it was going to be this hard Our busin…PamS 21 views 16 comments 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
Approval date not extractedSummary: Content (required): Hello everybody, In editing a report concerning various information about a job requisition. We needed to extract the "Approval Date" of a j…Gerardo Peluso 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle 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 18 views 2 comments 4 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
Something off in SQL expression for criteriaSummary Trying to capture last month's dataContent The report functions with the expressions below; however, It doesn't seem to actually capture the last day of the prev…Cassandra Kurth 41 views 2 comments 1 point Most recent by User_UEHCK General Transactional Reporting (OTBI)
-
OTBI Analysis showing Filter values in Excel OutputSummary OTBI Analysis excel output showing filter values along with data and scheduler ran twice, while it was set to run once every weekContent Hello Everyone, Our OTBI…GauravGupta39 23 views 4 comments 0 points Most recent by SantoshKumarB 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 63 views 1 comment 0 points Most recent by Sahil Makhiza 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) -
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then I…Brenda Jacks-49721 83 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
MD5 encryption in RTF templateSummary In BI Report output using RTF template, need to to include a URL string which is formed using multiple flex field values and need to encrypt that particular URL …Murugappan Murugappan 12 views 0 comments 1 point Started by Murugappan Murugappan General Transactional Reporting (OTBI)
-
Report on BIP Catalog Folders detailsSummary Report on BIP Catalog Folders details like Roles and Permission etc.Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission etc…Karthik_ks 78 views 9 comments 2 points Most recent by User_DDGZ5 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) -
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 34 views 4 comments 2 points Most recent by Pavel Buynitsky-Oracle 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 23 views 2 comments 3 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
How to add row number (fixed order) in analysis?Summary How to add row number (fixed order) in analysis?Content Hello Oracle Team, Is there a way to add row numbers in analysis? When I used RCOUNT(1), the row number w…Jonathan Chan gmg 16 views 4 comments 3 points 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)
-
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date dataContent Hello Oracle Community…Jonathan Chan gmg 8 views 2 comments 1 point Most recent by Jonathan Chan gmg 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) -
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure"Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how can…Jonathan Chan gmg 18 views 8 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)