E-Business Suite Application Object Library System Administrator FND_PROFILE.VALUE ('ORG_ID') returns -1 When Changing Responsibility And Organization Context (Doc ID 1235274.1)

Last updated on APRIL 03, 2024

Applies to:

Symptoms

E-Business Suite Application Object Library, Basic System Administration Functions and Maintenance related issues

A Responsibility context change initiates an Organization context change depending on the value of the profile 'MO: Operating Unit'.

Once a Responsibility context change occurs in alternate times, i.e.

- 1st resp context sets org context correctly
- 2nd resp context resets org context incorrectly
- 3rd resp context sets org context correctly
- 4th resp context resets org context incorrectly

the organization context is reset to -1.

The organization context should always be set to the proper value given a valid responsibility context change that is associated to a valid operating unit.

Steps to Reproduce:
1. Set valid profile values for MO: Operating Unit for the System Administrator Responsibility and Application Developer Responsibility.
2. Execute the following query:
set serverout on
begin
fnd_global.apps_initialize(0,20420,1);
dbms_output.PUT_LINE (FND_PROFILE.VALUE('FND_INIT_SQL'));
dbms_output.PUT_LINE (FND_PROFILE.VALUE('ORG_ID'));
dbms_output.PUT_LINE (FND_GLOBAL.ORG_ID);
fnd_global.apps_initialize(0,20419,0);
dbms_output.PUT_LINE (FND_PROFILE.VALUE('ORG_ID'));
dbms_output.PUT_LINE (FND_GLOBAL.ORG_ID);
end;

Changes

Cause

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