12.2 E-Business Suite Applications Technology Stack OID SSO Integration Profile Script Fails With Error 'ORA-20002: Seed Data Table FND_PROFILE_OPTION_VALUES has not been prepared for patching' (Doc ID 2304593.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications Technology Stack, OID SSO Technologies related issues

 

 

 

While following OID/OAM document for integration with EBS 12.2, users are requested to set profile option values via the following script:

DECLARE
stat BOOLEAN;
begin
stat := FND_PROFILE.SAVE('APPS_SSO', 'SSWA_SSO', 'SITE');
IF stat THEN
dbms_output.put_line( 'Profile APPS_SSO updated with SSWA_SSO' );
ELSE
dbms_output.put_line( 'Profile APPS_SSO could NOT be updated with
SSWA_SSO' );
commit;
END IF;
end;
/

This script fails with the following error:

DECLARE
*
ERROR at line 1:
ORA-20002: Seed Data Table FND_PROFILE_OPTION_VALUES has not been prepared for
patching
ORA-06512: at "APPS.FND_PROFILE_OPTION_VALUES+", line 1
ORA-04088: error during execution of trigger 'APPS.FND_PROFILE_OPTION_VALUES+'
ORA-06512: at "APPS.FND_PROFILE_OPTION_VALUES_PKG", line 330
ORA-06512: at "APPS.FND_PROFILE", line 2339
ORA-06512: at line 4

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