WS: 30/32/33/34/37/38/40/41/42/43/45/49: Listing of All Files that are NOT Updated by Effective Thru Date or Expiration Date (P4028) in Manufacturing & Distribution (Doc ID 2302729.1)

Last updated on JANUARY 02, 2025

Applies to:

JD Edwards World Agreement Management (ECS) - Version A7.3 cume 4 and later
JD Edwards World Inventory/OP Base - Version A7.3 cume 4 and later
JD Edwards World Inventory Management - Version A7.3 cume 4 and later
JD Edwards World Procurement - Version A7.3 cume 4 and later
JD Edwards World Advanced Pricing - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Symptoms

We require a list of all Data Dictionary names where either an Expiration Date or a Thru Date are held in all Manufacturing and Distribution files. Currently, many of our dates default to 12/31/20 and records in these files cannot stop being used on 01/01/2021. We are aware of the Update Effective Thru Dates (P4028) but this conversion program does not include all of the data files effected.

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

Files used by Manufacturing & Distribution are listed by Data Dictionary item as follows:

Files that use CDTE - Contract Completion Date are:

Files that use CXPJ - Expiration Date are:

Files that use EFFT - Effective Thru Date:

Files that use EFTU - Effective Thru are:

Files that use EXDJ - Expired Date are:

Files that use MMEJ - Lot Expiration Date are:

Files that use TEXD - Temperature Expiration Date are:

Files not updated by Update Effective Thru Dates (P4028) are listed by Data Dictionary item as follows:

Files not updated by P4028 for Data Dictionary item CDTE - Contract Completion Date are:

Files not updated by P4028 for Data Dictionary item CXPJ - Expiration Date are:

Files not updated by P4028 for Data Dictionary item EFFT - Effective Thru Date

Files not updated by P4028 for Data Dictionary item EFTU - Effective Thru are:

Files not updated by P4028 for Data Dictionary item EXDJ - Expired Date are:

Files not updated by P4028 for Data Dictionary item MMEJ - Lot Expiration Date are:

Files not updated by P4028 for Data Dictionary item TEXD - Temperature Expiration Date are:

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