Creating a Manual Bank Occurrence in Trade Notes Form (JLBRRIOB) Raises Error: APP-SQLAP-10000 ORA-28115 Policy with check option violation

(Doc ID 1590485.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to create a manual bank occurrences, such as Write Off Requisition, in the forms Occurrences > Trade Notes > Occurences Localization raises the following error:

APP-SQLAP-10000: ORA-28115: policy with check option violation occurred in
JL_BR_AR_OCCURRENCE_DOCS_PKG.INSERT_ROW<-JLBRRIOB with parameters
(DOCUMENT_ID = 1083)
while performing the following operation:
Insert into JL_BR_AR_OCCURRENCE_DOCS

Forms JLBRRIOB Version 12.0.19.12010000.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