Got the below error while invoking the custom package which is internally calling the oracle fusion apps procedure .
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.
You will see this kind of errors if you are invoking the package from custom schema.
For resolving this error you need to create the custom package in Fusion Apps master schema(Ex :- FUSION).