My Oracle Support Banner

E1: CFR11: Promoting UDC Between Two Pathcodes Which Have Auditing Enabled Fails with 'JDB9900775 - Fail to insert to table. This table (F0005) is audited and cannot be overriden to different datasource (<datasource>.) (Doc ID 3058967.1)

Last updated on NOVEMBER 18, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

In 9.2 tools release, when attempting to promote an UDC between two pathcodes both which are auditing enabled, the promotion fails with general error.
In the jde.log of the fat client the following error occurs.

JDB9900775 - Fail to insert to table. This table (F0005) is audited and cannot be overriden to different datasource (Control Tables - CRP.)


Steps

  1. Add an UDC to a project
  2. Promote the project between two pathcodes which are auditing enabled
  3. Check the results


This document is regarding UDC promotion failure between two pathcodes in which both have auditing enabled. If one of pathcodes does not have auditing enabled, failure is expected as per

E1: CFR11: Cannot Copy Data From an Audited Table to Non-Audited Table (Doc ID 645204.1)

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
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.