An error occurred while preparing and executing the “xxxxxxx” API. Cause: java.sql.SQLException: ORA-20001: APPLCORE–20001: Exception occurred creating session

Issue –>

Got the below error while invoking the custom package which is internally calling the oracle fusion apps procedure .

Error –> 

An error occurred while preparing and executing the “xxxxxxx” API. Cause: java.sql.SQLException: ORA-20001: APPLCORE–20001: Exception occurred creating session – \ ORA-02289: sequence does not exist ORA-06512: at
line 76 ORA-06512: at “FUSION.FND_SESSION_MGMT”, line 311 \ ORA-06512: at “xxxxxxx”, line 100 ORA-06512: at line 1 Check to ensure that the API is defined in the database and that the parameters match the signature of the API.

Cause –>

You will see this kind of errors if you are invoking the package from custom schema.

Solution –> 

For resolving this error you need to create the custom package in Fusion Apps master schema(Ex :- FUSION).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s