Skip to main content

Error: When Creating Netting Agreement: ORA-28115: policy with check option violation (Doc ID 2678752.1)

 

Copyright (c) 2022, Oracle. All rights reserved. Oracle Confidential.
Click to add to FavoritesTo BottomTo Bottom

In this Document

Symptoms
Changes
Cause
Solution
References


APPLIES TO:

Oracle Fusion Receivables Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Payables Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

SYMPTOMS

Trying to create an AP/AR netting agreement for a new setup, below error popped up when submitting it.

ERROR
-----------------------
ORA-28115: policy with check option violation

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payments > Manage Netting Agreements
2. Create Netting Agreements > provide the required information
3. Save the record

CHANGES

 

CAUSE

The issue is caused by the incomplete setup steps for the custom role set for Netting
> The LDAP process was not run
 

SOLUTION

To implement the solution, please execute the following steps:

1) Within Security Console > search for the custom role
2) In the Data Security Policies step please Grant on Netting Agreements > ORA_JE_NETTING_AGREEMENTS
3) In the Role Hierarchy and add the Customer and Supplier Balance Netting roles: ORA_JE_CUSTOMER_AND_SUPPLIER_BALANCE_NETTING_DUTY
4) Assign the custom role to your user
5) Please run Ess Jobs: 'Import User and Role Application Security Data' and 'Retrieve Latest LDAP Changes'.
6) Sign out and Sign in again to the application.
7) Retest the initial issue

Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more