Receivables - EBS (MOSC)

MOSC Banner

ora-28115 policy with check option violation

edited Jan 19, 2014 5:13PM in Receivables - EBS (MOSC) 6 commentsAnswered
 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,

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