In Automatic Receipts Creation Program And AP/AR Netting Process the Org Context is Lost and this Generates Error ORA-28115: Policy With Check Option Violation (Doc ID 1912026.1)

Last updated on AUGUST 24, 2016

Applies to:

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

Symptoms

1. Automatic Receipts Creation Program (API) ends with error if MO: Operating Unit profile option value is different at responsibility level than org_id of transaction.

Error: APP-00001:Unable to find message: AUTORECERR 1Application failure. You need to nullify the SELECTED FOR RECEIPT BATCH ID on the invoice when the invoice is fixed. Then apply the invoice manually to the receipt with receipt id: 216994, created by automatic receipts for that invoice APP-00001: Unable to find message: AUTORECERR 2APPLY : ORA-28115: policy with check option violation

2. Settle Netting Batch log displays the following error: APPLY : ORA-28115: policy with check option violation ORA-28115: policy with check option violation in Package AR_RECEIPT_API_PUB Procedure Apply An error occurred while applying AR transactions to Receipts.

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