My Oracle Support Banner

Package Compilation Fails When Using Forall In Remote Tables (Ie. Aso_cc_encrypt_conc_req_pvt) (Doc ID 1269151.1)

Last updated on AUGUST 17, 2020

Applies to:

Oracle Quoting - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


On : 11.5.10.2 version, FC Core

After relocating the IBY_SECURITY_SEGMENTS table to a separate database with a synonym from local database
to remote table, several packages fail to compile.

The following error occurs.

ERROR
-----------------------
PLS-00739: FORALL INSERT/UPDATE/DELETE not supported on remote tables


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

1. Follow steps from documentation (Oracle Applications Credit Card Encryption - Doc ID 338756.1)
to relocate the IBY_SECURITY_SEGMENTS table to a separate database with a synonym from local database to remote table.

2. Compile Database objects.

3. Several packages fail to compile with: PLS-00739: FORALL INSERT/UPDATE/DELETE not supported on remote tables, such as ASO_CC_ENCRYPT_CONC_REQ_PVT.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.