Receivables - EBS (MOSC)

MOSC Banner

ar_receipt_api_pub.REVERSE API returns error ORA-28115:policy with check option violation in package

edited Mar 8, 2016 4:02AM in Receivables - EBS (MOSC) 1 commentAnswered

I have a procedure xxtkg_rcpt_reverse_data in package. This procedure determines which receipt will reverse from a custom table. Then, it calls another procedure xxtkg_rcpt_reverse for reverse ar_receipt_api_pub.REVERSE API.

The problem is, when multi org receipt reverse data pass to ar_receipt_api_pub.REVERSE API, it returns error ORA-28115:policy with check option violation in package ar_receipt_api_pub procedure create_cash.

My two procedures:

PROCEDURE xxtkg_rcpt_reverse_data (p_ou_id           NUMBER,

                                      p_header_id       NUMBER,

                                      p_line_id         NUMBER,

                                      v_out_msg     OUT VARCHAR2)

   IS

      CURSOR dist_data  IS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center