Global DB Sequence To Generate Primary Keys (Doc ID 2278240.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Java Cloud Service - SaaS Extension - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Goal

To generate the primary keys for all the custom tables created in DB CS, but fusion applications supports global DB Sequence instead of creating sequence for each and every table .

https://blogs.oracle.com/fadevrel/entry/fusion_concepts_unique_id_generation

It can generate id using the expression oracle.jbo.server.uniqueid.UniqueIdHelper.getUniqueId(); at entity attribute .

To provide the same fusion applications global db sequence feature in JCS as well.
 

Solution

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