Create Accounting Subledger Post Process Errors with Character String Buffer Too Small
Last updated on JUNE 27, 2016
Applies to:Oracle Fusion Assets Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Assets - Version 220.127.116.11.0 and later
Oracle Fusion General Ledger - Version 18.104.22.168.0 and later
Oracle Fusion General Ledger Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Create Accounting for Assets ran successfully, however, the journal did not post to the General Ledger
Create Accounting was processed with parameters of Final status with Transfer to GL = Yes.
GL Transfer end with errors. sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The issue can be reproduced at will with the following steps:
1. Navigate to Fixed Assets > Financial Transactions > Create Accounting
2. Select Asset Book, Period, Status = Final, Batch Name = Apr-16 Create Acctg Assets - Additions/Depreciation,
3. Process errors on Transfer to GL. Other Create Accounting Processes were successful.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms