Transaction Adjustment Puts Adjustment Rows In Error - PROJ_TRANS_TYPE contains an invalid value (13120,5013) (Doc ID 1926550.1)

Last updated on DECEMBER 07, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9 version, Third Party Integration

After applying Bundles 36 - 45, When attempting to do transaction adjustment, the transaction stays in the Interface table (INTFC_PROJ_RES) with the following message


ERROR
-----------------------
PROJ_TRANS_TYPE contains an invalid value (13120,5013)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Make sure the system does not have a value 'ADJ' for Project Transaction Types - (Navigation : Set up Financial Supply Chain > Product Related > Project Costing > General Options > Transaction Types)
2. Commitment control Turned off in the installation options
3. Find a transaction that can be adjusted using Project Costing > Transaction Definitions > Transaction Adjustment page.
4. Adjust any the transaction chartfield and Save

The transactions stay in the interface table with the error message as shown above instead creating the adjustment transactions in PROJ_RESOURCE


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