R12: Customized Journal Category / Source Has Been Upgraded Incorrectly In R12, Why? (Doc ID 964572.1)

Last updated on SEPTEMBER 16, 2015

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Form: Journal Categories: GLXSTCAT
Form: Journal Sources: GLXSTSRC
***Checked for relevance on 16-Sep-2015***

Goal

Upgraded from 11i to Release 12 of the applications.
Running this query:

You noticed there are two relevant fields: JE_CATEGORY_NAME and USER_JE_CATEGORY_NAME.
While the first field is migrated correctly, the second one is changed during the upgrade process and it does not reflect user's entered data anymore.

Example:
11i:
JE_CATEGORY_NAME / USER_JE_CATEGORY_NAME
Treasury Customer Treasury
R12:
JE_CATEGORY_NAME / USER_JE_CATEGORY_NAME
Treasury Treasury

Similar case, note category name has changed from 'Public Sector Budget' to 'HR Budget'

Why?

Solution

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