My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, 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 a vibrant support community of peers and Oracle experts.