ora-28115 policy with check option violation
Hi Everyone,
I'm currently writing custom scripts that would interface transactions from external source to A/R receipts using "ar_receipt_api_pub" public api, everythings fine from creating receipts to applying a/r transaction. But I'm having trouble on calling "ar_receipt_api_pub.reverse" that yield to "ora-28115 policy with check option violation" error. The "ar_receipt_api_pub.reverse" procedure was called and executed on different schema. Below the snippet of the code:
procedure ar_receipts_reverse(p_receipt_id in number,
p_reversal_category_code in varchar2,
p_reversal_reason_code in varchar2,
p_reversal_date in date,
0