E-ORA: PT 8.48/Apps 9 PSSTATUS.DATABASE_OPTIONS values (Doc ID 657665.1)

Last updated on JULY 15, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.48 and later
Information in this document applies to any platform.
SPECIFIC TO:  
Enterprise, Oracle database, PeopleTools 8.48, Release 9 Applications and above

This document was previously published as Customer Connection Solution 201052818



"""""Checked for relevance on Oct 2011"""""
*** Currency checked May 7, 2013 ***


Symptoms

 The DATABASE_OPTIONS field in PSSTATUS is set to 2 by default to use the new Oracle datatypes (as outlined in the PT 8.48 release notes) for a new install with PeopleTools 8.48 and Release 9 Enterprise applications. Is it alright to change the above value to 0 (to use the old data type)? Are there are any implications to the system/application?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms