Errors With FVXEVPTM (Payment Type Mapping) Form-FRM-40831;ORA-01406 (Doc ID 1909140.1)

Last updated on AUGUST 31, 2016

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Payables

Errors with FVXEVPTM (Payment Type Mapping) form

We are encountering multiple errors with the new FVXEVPTM (Payment Type Mapping) form.
ERROR
-----------------------
Issue 1: When entering new payment type mapping data, when populating the Operating Unit field, we receive error: FRM-40831: Truncation occurred: value too long for field OPERATING_UNIT

We can still save the records when receiving this issue, but wanted to report the issue since it is probably just a form field length value that could be updated.

Issue 2: After entering records in the form, we are unable to query them back up. We receive: ORA-01406: feteched column value was truncated

Issue 3: Header data is shown across SOBs (FV_PAYMENT_TYPE_MAP_HDR_ALL data) although the detail mapping data does seem to be  restricted by ledger.

Issue 4: 1) Payment types that we've previously created are no longer available.

2) The Payment Format LOV is showing no entries.

3) Pay Group LOV is not populating data that we have defined in PAY GROUP lookup.


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