Policy with check option violation?

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
turbo
Posts: 62
Joined: Mon Apr 14, 2008 9:12 am
Location: Vietnam

Policy with check option violation?

Post by turbo »

Hello All,
I load data from excel to Customer interface tables( RA_CUSTOMERS_INTERFACE, RA_CUSTOMER_PROFILES_INT, RA_CUST_CONTACT_PHONES_ALL)

But i can't load into Customer interface tables.
It's error : "Policy with check option violation"

Really I don't know which policy.
Would you please help me!.

Thanks a lot.
admin
Posts: 2065
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl always provide the required info like,

1- Version
2- Steps you are performing in detail.
3- Users you are using for these activities.
4- Your Operating System.

Thanks
turbo
Posts: 62
Joined: Mon Apr 14, 2008 9:12 am
Location: Vietnam

Post by turbo »

Hello Admin,
- I use EBS R12
- I upload by Excel file (Excel File include required columns and necessary columns) and use Sql*Loader to Upload.
- User: apps

I can ask one more question:
I also upload the same method for Supplier(AP_SUPPLIERS_INT, AP_SUP_SITE_INT, AP_SUPPLIER_SITES_INT) and Successful.
But when I Run Request Supplier Open Interface but import = 0 and Reject = 0.

Can You help me, Please!

Thanks a lot!
admin
Posts: 2065
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Check the following metalink note it may help you,

Subject: INSERT Behaviors on a Table with an OLS Policy Applied with a SQL PREDICATE and READ_CONTROL, WRITE_CONTROL, CHECK_CONTROL options
Doc ID: Note:433806.1 Type: BULLETIN
Last Revision Date: 11-FEB-2008 Status: REVIEWED
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest