Loading...

How easy it is to forget! On creating a view with a literal (alphanumeric) value, Oracle will use the CHAR datatype.   This is no problem, since the value is a constant. But what if we mix the datatypes? Oracle automagically changed the datatype to VARCHAR2. (This is also documented in the SQL Reference for […]

The post Create View and Datatypes appeared first on The Oracle Tales.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

To access eBS functionality through SQL clients or PL/SQL, it can be necessary to initialize an eBS session. For example when you need to reference eBS views, access API’s or start concurrent requests from outside eBS. To initialize an eBS session the API FND_GLOBAL.APPS_INITIALIZE can be used. It has 3 required parameters and 2 optional […]

The post FND_GLOBAL.APPS_INITIALIZE: Initialize eBS sessions in SQL and PL/SQL appeared first on The Oracle Tales.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Just a short note to say that I am proud to be selected as a speaker for UKOUG Apps 2017! I will even give 2 presentations. On Monday I will present ‘Customizing Autoconfig/RapidClone’. Then on Tuesday I will present ‘Auditing the Oracle eBusiness Suite’. The first presentation is about further optimizing the Autoconfig and RapidClone […]

The post UKOUG Apps 2017 appeared first on The Oracle Tales.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

CANONICAL VALUES   Since I have been working a lot on NUMBER and DATE conversions lately, it’s time to write a short note about canonicals. Oracle eBS Flexfields (and by extension concurrent program parameters) store all values in a VARCHAR2 column. In general it is a bad idea to store NUMBER and DATE in a […]

The post eBS Flexfields and Canonical values appeared first on The Oracle Tales.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Trying to write some information about the DATE datatype, I ran into the following problem: Also different varieties (B.C. , bc, AD, A.D.) with or without a space, with different seperators all gave the same ORA-1856: BC/B.C. or AD/A.D. required. Excuse me. That is what I just entered. What is going on here. Check the […]

The post NLS_DATE_LANGUAGE and ORA-1856 appeared first on The Oracle Tales.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Datatypes Introduction The first new blog entry on the site is about ‘Datatypes’. Or more precisely  about datatype (implicit)  conversions. It was triggered by the too-often-seen ORA-1722 Invalid Number. But the root cause is valid for numbers as well as dates (/timestamps). In this article I will investigate some of the causes for ORA-1722 in […]

The post Datatypes and ORA-1722 appeared first on The Oracle Tales.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview