如上图
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch.Patch.ATG 12.0.5 ( will be release in may/june 2008 )
The issue is resolved by upgrading to file AFNLMSGB.pls and version 120.4.12000000.5 or higher.
As a workaround before patch released
1. In TEST env , modify $FND_TOP/patch/115/sql/AFNLMSGB.pls
2.Modified l_char_after variable declaration from VARCHAR2(1) to NVARCHAR2(1).
3. run AFNLMSGB.pls in SQLPLUS
4. retest the issue
5. Migrate the solution as appropriate to other environments.