R12: Attachments - Only One Block Entity Can Have Insert, Update And Delete Privileges (Doc ID 1273599.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Object Library - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
FNDATFUN, Block, Entity, Insert, Update, Delete, Privileges

Symptoms

On the Attachment Functions form FNDATFUN, when attempting to save a related entity, the following error occurs:

"Only one block entity can have insert, update and delete privileges."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

01. NAV: Application Developer / Attachments / Attachment Functions
02. Query for the existing Form function ARXTWMAI
03. Scroll to TGW_HEADER – Click Entities
04. Insert New Entity:
05. Entity: OM Order Header
06. Display Method: Related Entity
07. Include in Indicator: Enable (click OK to warning message)
08 Privileges:
09. Query: When condition True
10. Insert: Never
11. Update: Never
12. Delete: Never
13. Field: tgw_header.interface_header_context
14. Operator: =
15. Value 1: ORDER ENTRY

16. Primary Key Fields
Key 1: tgw_header.interface_header_attribute6

17. SQL Statement: None

Receive error

BUSINESS IMPACT
-----------------------
Unable to see OM attachments in AR transactions and vice versa

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