My Oracle Support Banner

Error while trying to prepare and execute the LACLS.LACLS_EC_CR_SEQUENCE_PKG.GET_SEQUENCE API: ORA-01031: insufficient privileges (Doc ID 2989208.1)

Last updated on DECEMBER 04, 2023

Applies to:

Latin America Cloud Local Solution (LACLS) - Version 11 to 13 [Release 11 to 13]
Information in this document applies to any platform.

Symptoms

The LACLS OIC integrations 'LACLS_EC_WITHHOLDING_GEN_SEQUENCE' and 'LACLS_EC_SETTLEMENT_GEN_SEQUENCE' show the error: 

Error while trying to prepare and execute the LACLS.LACLS_EC_CR_SEQUENCE_PKG.GET_SEQUENCE API. An error occurred while preparing and executing the LACLS.LACLS_EC_CR_SEQUENCE_PKG.GET_SEQUENCE API. Cause: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges ORA-06512: at "LACLS.LACLS_EC_CR_SEQUENCE_PKG"io, line 35 ORA-01403: no data found ORA-06512: at "LACLS.LACLS_EC_CR_SEQUENCE_PKG", line 29

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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