R12: PAAPIMP - PRC: Interface Expense Reports From Payables Errors ORA-012899 (Doc ID 2125087.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running PRC: Interface Expense Reports from Payables, the following error is encountered in the log:

Value of G_TRANS_DFF_AP:Y

calling bulk_update_trx_intf within transfer_inv_to_pa

Before bulk update of prepayment invoices

calling bulk_insert_trx_intf within transfer_inv_to_pa

Before bulk insert of supplier invoices

Failed during bulk insert for invoice processing

Error Code is -12899

ORA-12899: value too large for column "PA"."PA_TRANSACTION_INTERFACE_ALL"."ATTRIBUTE_CATEGORY" (actual: 40, maximum: 30)

Error occured in stage: calling bulk_insert_trx_intf within transfer_inv_to_pa, PAAPIMP aborted!

ORA-12899: value too large for column "PA"."PA_TRANSACTION_INTERFACE_ALL"."ATTRIBUTE_CATEGORY" (actual: 40, maximum: 30)

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