the errors seen above are encountered because the NLS_LENGTH_SEMANTICS initialisation parameter has been set to CHAR. This is not a supported setting for this parameter in an Oracle Fusion Middle ware installation. This is documented in the Release Notes for each platform.
To remove the ORA-01450 errors when creating the MDS and SOAINFRA components ensure that the requirement for NLS_LENGTH_SEMANTICS=BYTE is met.
To check the current setting of NLS_LENGTH_SEMANTICS, login to the target database as SYSDBA and issue the following command:
SQL> show parameter NLS_LENGTH_SEMANTICS
NAME TYPE VALUE
———————— ———– ——-
nls_length_semantics string CHAR
SQL> alter system set nls_length_semantics=BYTE;
System altered.
SQL> show parameter NLS_LENGTH_SEMANTICS
NAME TYPE VALUE
———————— ———– ——-
nls_length_semantics string BYTE
After resetting the parameter you should restart your database for the change to take effect.
linux01(oracle:orcl1)/home/oracle: lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-SEP-2015 03:43:02 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /opt/oracle/product/11.2.0.4.RAC/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /opt/oracle/product/11.2.0.4.RAC/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/linux01/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00303: syntax error in NV string Listener failed to start. See the error message(s) above...
In the listener.ora file there were blank lines under the section SID_LIST_LISTENER. We removed the blank line entries and brought up the listener. (please note that this may be one of the scenarios)
Erroneous listener.ora file excerpts below:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL1) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL1) ) <<<<< blank line (SID_DESC = (GLOBAL_DBNAME = ORCL2) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL2) ) <<<<< blank line )
After setting up of Accounts Receivable (AR) Module. Create Accounting some times completes with warning message “The application accounting definition Multi-Fund Account Receivables Accrual – Balancing Method owned by Oracle is not validated. Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Encumbrance Accrual.”
This warning message we can find in Log file of the concurrent program
To overcome this issue go to AR Resposibility and Run Concurrent Program “Validate Application Accounting Definitions“.
You can identify that all the Application Accounting Definition Validated by checking the Out put file of the concurrent program.
Go to AR Invoice and try to do create accounting. Now Create Accounting concurrent program gets Completes Normal.
Here I am going to discuss about how we can open multiple forms at a time. Here is a requirement that i want to open journal entry form as well as currency definition form at a time. Normally we can open one form at a time but by doing below changes we can get this functionality.
After accessing to the application go to Tools, You can observe that their is a check box checked against “Close Other Forms”.
Uncheck the check box
After unchecking the check box i am trying to open the journal entry form and currency definition form. You can observe that both forms open parallel. for opening both forms click on respective navigation separately.
