OGL EPF: Updating Dimension Member Description and Attributes, users get PROTECTED_ATTR_ASSIGN error message in the ATTR_T table (Doc ID 438418.1)

Last updated on MAY 02, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 12.0.0
Information in this document applies to any platform.
FEM
OGL EPF Data Integration

Goal

Users are working with the Web ADI worksheet to update descriptions for particular dimension members. These members were sourced from Oracle General Ledger.  They enter existing member values and are looking to update these dimension members with new descriptions.

After running the process, they notice an error in the concurrent log:

1242 rows loaded successfully.
1242 rows failed to load successfully.

The Web ADI spreadsheet completes successfully with no error messages. The window states that all rows are successfully loaded and there are all green smiley faces.

However, when the users check the interface tables (for Example Line Item), they notice:

FEM_LN_ITEMS_B_T and FEM_LN_ITEMS_TL_T were clean but FEM_LN_ITEMS_ATTR_T has the error status "PROTECTED_ATTR_ASSIGN" for attributes like EXTENDED_ACCOUNT_TYPE, SOURCE_SYSTEM_CODE, and RECON_LEAF_NODE_FLAG on every loaded value. The users are wondering if this error can be ignored or if further action is required.

Solution

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