ar_receipt_api_pub.REVERSE API returns error ORA-28115:policy with check option violation in package
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