Tracking ESUs changes to DD items

[johndanter]

Hi folks,

I know there many tables behind the scenes (F9671 /72, F96400 the list goes on) plus the impact analysis tables but nowhere for the life of me can I find where changes made to DD items via an ESU are stored.

I had an issue last week in that I cheery picked an ESU for P3112 and it was fine all the way until it hit PD. PD has it's own DD library.
The error was with alias OPCN. This must have come in in a lower environment ESU, updated non prods DD library but not yet made it to PD.

So, can anyone help me here? As we all need to be able to track DD changes and as well as base objects.

Thanks

John

 

[jdelisths]

Take a look at these two tables:

F9755 : Change Table - Data Item Master
F9757 : Change Table - Data Item Alpha Description


Usually, these tables are mapped to the DD data source. Inconsistent OCM mappings for these (and other tables) in the planner environment may explain why the DD change did not make it to PD.

 

[johndanter]

Hi,

Thanks for the reply but it doesn't really help. There are no dates nor are there any references back to the ESU they may or may not have been introduced in.

 

[jdelisths]

John,

There are no dates, but there are referenced back to the ESU:

SELECT * FROM DD900.F9755 WHERE ( D$RLSF = 'E900' AND D$RLS = 'YourESU' )

SELECT * FROM DD900.F9757 WHERE ( D$RLSF = 'E900' AND D$RLS = 'YourESU' )

(Assuming you are on E900).


Also look at F92* xml files in your planner folder on the deployment server:

<Drive>:\JDEdwards\E900\Planner\data\YourESU

 

[johndanter]

Ok great thanks. I'll take another look