My Oracle Support Banner

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

Last updated on JANUARY 10, 2020

Applies to:

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


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

PROJ_TRANS_TYPE contains an invalid value (13120,5013)

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




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.