My Oracle Support Banner

ADS For Banks: Bring over the generated SQL OR process to automatically call to generate the generated SQL definitions (Doc ID 1682992.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
Bring over the generated SQL OR is there a process we can automatically call to generate the generated SQL definitions?

Goal

Created an ADS for banks. When we create new banks we first set them up in TEST and validate processed work with the new bank. We then Migrate over bank tables into the next environment.

This does NOT bring over the generated SQL.

Is there a safe way via ADS to bring over the generated SQL OR is there a process we can automatically call to generate the generated SQL definitions?

NOTE: This is useful for Payables and Receivables
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.