PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Generated By Application Designer For Alter By Table Rename SYNTAX Command

edited Dec 18, 2019 4:05AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 13 commentsAnswered

Hi All,

We are always facing issues with RENAME SYNTAX command getting auto-generated in PSBUILD.SQL while BUILD with ALTER table option via application designer. Please refer attached video file for your reference.

Example :

RENAME TABLENAME TO PS_AP_EXTRACT_LINE

will be

ALTER TABLENAME RENAME TO PS_AP_EXTRACT_LINE

Please check and assists on this quickly?

While BUILD and execute Alter via application designer doesn't have an issue with RENAME, issues with only BUILD script (PSBUILD.SQL) generates via application designer it includes the extra command "RENAME" and running in PL SQL backend DB.

Always DBA team was edit RENAME in the place of an actual table name ( refer above example ) and running it. it's very difficult always for them to do it.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center