The code changed the length of warehouse_name to 240 from 60. Navigation- Transaction Form - Open invoice - Lines Items - Error showing:: FRM-40831: Truncation occurred: value too long for field WAREHOUSE_NAME. The issue can be reproduced at will with the following steps: This issue is only with the warehouses defined in Russian, because the special characters are using more Bytes than usual. The warehouse name length defined in Inventory, was higher than the length accepted in Receivables, due to this the error was showing. This note provides a brief overview of REW: FRM-40831: TRUNCATION OCCURRED: VALUE TOO LONG FOR FIELD WAREHOUSE_NAME Information in this document applies to any platform. Oracle Receivables - Version 12.1.3 to 12.2.6 For more information about Oracle (NYSE:ORCL), visit -40831: Truncation occurred: value too long for field WAREHOUSE_NAME Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! It does not happen in SQL*Plus, SQL Developer or other versions of Toad. When attempting to connect via Toad 11.6 to an Oracle 12c database (using any user account), the connection may fail with:Īfter clicking 'OK' in Toad, it still seems to connect to the database but the error is received anytime that one tries to browse within the Toad Schema browser. Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later

Oracle Database Cloud Schema Service - Version N/A and later Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 ORA-01031 When Connecting To A 12c Database With Toad

Toad for oracle 12.1