R12: PA: PAXPAELM Pay Element Distribution Rules Errors With FRM-40831: Truncation Occurred

(Doc ID 2173405.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Foundation - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Miscellaneous Issues

PAXPAELM Pay Element Distribution Rules errors with the following:

ERROR
-----------------------
FRM-40831: Truncation occurred value too long for field: OPERATING_UNIT.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to application, launch responsibility Projects Implementation Super User
2. Navigation:  Setup > Costing > Labor > Pay Element Distribution Rules
3. Error received on the operating unit (on opening the form)
4. At this point user is not able to select the desired operating unit due to this error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Causing the wrong OU to be assigned to the distribution rules.
Value truncates and then the rule is assigned to a different OU with a similar name - unable to select correct OU at all.

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