EGL: On Using PS_KK_TRANS_LOG.STATISTIC_CODE as Reference in Allocation (Doc ID 2156665.1)

Last updated on JULY 12, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Issue
--------
Per Customer, in their Allocation setup, they use PS_KK_TRANS_LOG as our Pool record for Allocation.

Since PS_KK_ACTIVITY_LOG and PS_KK_TRANS_LOG stores same information but KK_ACTIVITY_LOG does not have Statistic Code field while KK_TRANS_LOG has it.

Hence, they use PS_KK_TRANS_LOG to use Statistic code to differentiate Expenditure (STATISTIC_CODE = 'EXP') and Encumbrance (STATISTIC_CODE = 'ENC') Allocation


Environment
-------------------
FSCM 9.1 Maintenance Pack 12 / Bundle 26

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