CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

CFR11 column "ISDELETE" does not indicate deleted records?

edited Feb 24, 2017 4:00AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

Hi all,

I am turning off the cfr11 audit on table CRPDTA.F1201 in Oracle database with the document below:

E1: CFR11: How to Delete an Audit Table from the System (Doc ID 1492517.1)

In the task, I found that column ISDELETE had two values, blank and N.

> SELECT FAISDELETE,COUNT(*) FROM CRPDTA.F1201_ADT GROUP BY FAISDELETE ORDER BY 1;

>     48008

> N   29484

Does it indicate whether the records is deleted?

If so, I think that I should delete blank records or "N" records. Is it correct?

If not, what do the column and values indicate?

Any information is appreciated.

Regards,

Koichi

JD Edwards EnterpriseOne 9.1, tools 9.1.4.7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center