E1: 17: P90CG503 - Does Not See Historic Work Orders Related Actions AFTER UPGRADING

(Doc ID 2403706.1)

Last updated on MAY 25, 2018

Applies to:

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

Symptoms

P90CG503 - Does Not See Historic Work Orders Related Actions AFTER UPGRADING from 9.0 to
9.2 on (Existing) Records that existed in 9.0. There needs to be a New Conversion Program to address this issue.

HOW IT LINKS CASES TO SERVICE WORK ORDERS)
9.0 Functionality for the P90CG503

Case Entry for Creating Related Order for SO, RMA
the system writes records to the F90CG503

However, when Creating Related Service Work Orders it Does NOT write records to the F90CG503.
What it does for Work Orders - it ONLY writes to the F4801 table to create the Association...
It populates the F4801 PTWO (Peg to WO) Field with the Related Case Number.

-----------------------------

9.2 Functionality for the P90CG503

For release 9.2 the P90CG503 application, the Code was changed.. Now to Link
Cases to Service work orders using the P90CG503, it writes record for
Service Orders in F90CG503 table to Associated Service Work Order Records.

This Create a problem when upgrading to view Historical Records because the
New Functionality Looks at the F90CG503 for Service Work Orders and prior
Releases stored the Association in the F4801.

Need to Create a Conversion Program for this

STEPS TO REPRODUCE
==================
1. Client has existing Related Service in 9.0 Release
2. Client Upgrades to 9.2 Release
3. Client goes into the P90CG503
4. Non of the Historical Service Work Order Records Show up
5. This is because the association was done in the F4801 (PTWO Peg to WO)

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms