New article on Descriptive Flexfields
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
2y ago
I just published the second part of the article series on Flexfields. This part is about Descriptive Flexfields. It is available from: http://www.stijf.com/joomla/flexfields/flexfields-in-oracle-ebs-descriptive-flexfields The next part will follow shortly, and will discuss the flexfield datamodel. The post New article on Descriptive Flexfields appeared first on The Oracle Tales ..read more
Visit website
New article on eBS (Key) Flexfields
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
2y ago
Just a short note to point to a new article that I published on the new site:  http://www.stijf.com/joomla/index.php/flexfield-articles/49-flexfields-and-flexfield-structures.html It is the first part of a multi-part article. This part explains Key Flexfields in eBS. The next parts will discuss Descriptive Flexfields, the datamodel and special features.  The post New article on eBS (Key) Flexfields appeared first on The Oracle Tales ..read more
Visit website
Create View and Datatypes
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
3y ago
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 more
Visit website
FND_GLOBAL.APPS_INITIALIZE: Initialize eBS sessions in SQL and PL/SQL
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
3y ago
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 more
Visit website
UKOUG Apps 2017
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
3y ago
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 more
Visit website
EBS Flexfields and Canonical values
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
3y ago
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 more
Visit website
NLS_DATE_LANGUAGE and ORA-1856
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
3y ago
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? Enter the […] The post NLS_DATE_LANGUAGE and ORA-1856 appeared first on The Oracle Tales ..read more
Visit website
Datatypes and ORA-1722
The Oracle Tales: Source for Oracle (eBS) professionals
by Arian Stijf
3y ago
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 more
Visit website

Follow The Oracle Tales: Source for Oracle (eBS) professionals on FeedSpot

Continue with Google
Continue with Apple
OR