ORA-01720: grant option does not exist for '.' Error Assigning Role to Table in Non OFSA 4.5 Schema (Doc ID 432792.1)

Last updated on JUNE 13, 2016

Applies to:

Oracle Financial Data Manager - Version 4.5 to 4.5.40 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5

Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

On OFSA 4.5.36 when attempting to grant a role to a user defined table in a custom schema (not OFSA schema), the following error occurs:

ERROR
ORA-01720: grant option does not exist for '.'

The issue can be reproduced at will with the following steps:
1. Created new table in COKI schema:
create table coki.coki_mortgage as select * from ofsademo.mortgages;

2. Registered new table in FDM (Wizards -> Register -> Object)
==> automatically created 'COKI_MORTGAGE_V'

3. Classify table as 'User Defined' in FDM

4. Attempt to assign table to role:

a. Wizards -> Security -> Role Assignment
b. Choose Role to Database Object Privileges
c. Choose the 'OFDM_R_CLIENT_PROC' role
d. 'User Defined' table from filter by table Classification
e. Check the boxes for select, insert, update and delete for the 'COKI_MORTGAGE_V'.
f.  Hit Apply and the ORA-01720 error appears

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms