Apply 2nd Credit Memo in Different OU - error - ORA-28115: Check Option Violation Occurred In AR_IREC_APPLY_CREDITS.apply_credits (Doc ID 1999758.1)

Last updated on APRIL 15, 2015

Applies to:

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

Symptoms

When an internal iReceivables and applying credits for an operating unit (US) and then applying another credit to a different Operating Unit, the following error occurs in the 2nd Operating unit
 
ORA-28115: policy with check option violation occurred in AR_IREC_APPLY_CREDITS.apply_credits_on_credit_memo while performing the following task: Apply credit memo against the debit transaction

Steps to Reproduce

Create Invoice and Credit Memo for a Customer in an Operating Unit
Create Invoice and Credit Memo for a Customer in a different Operating Unit

Using iReceivables 2.0 Internal responsibility
Query 1st Customer
Select All Locations
Select Operating Unit
Click on Account Balance
Click the Credit Memo
Click the Invoice
Click Apply Credit
Change the amount to $1 on the invoice
Click Recalculate
Click Next
Change the amount to $1 on the Credit memo (so you can use it again if needed)
Click Recalculate
Click Next
Click Apply

go back to Customer Search and search for 2nd customer

Select All Locations
Select Operating Unit
Click on Account Balance
Click the Credit Memo
Click the Invoice
Click Apply Credit
Change the amount to $1 on the invoice
Click Recalculate
Click Next
Change the amount to $1 on the Credit memo (so you can use it again if needed)
Click Recalculate
Click Next
Click Apply
The error occurs here

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