Posts Tagged ‘ERP’

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

April 10th, 2018, posted in Linux OS, Oracle, Windows
Share

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA,TNS-01155,Incorrectly specified SID_LIST_LISTENER parameter,LISTENER.ORA,LISTENER ORA,errors,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,Oracle Apps,Apps DBA,ERP Application



Issue : While starting the listener we got the below error.


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...



Solution: 

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
)
Share

Validate Application Accounting Definitions

April 3rd, 2018, posted in Oracle
Share

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

Validate Application Accounting Definitions,How To Validate Application Accounting Definitions,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,Application Accounting Definitions,Validate ERP Application Accounting Definitions,Oracle Apps,Apps DBA

Validate Application Accounting Definitions,How To Validate Application Accounting Definitions,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,Application Accounting Definitions,Validate ERP Application Accounting Definitions,Oracle Apps,Apps DBA

Solution


To overcome this issue go to AR Resposibility and Run Concurrent Program “Validate Application Accounting Definitions“.

Validate Application Accounting Definitions,How To Validate Application Accounting Definitions,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,Application Accounting Definitions,Validate ERP Application Accounting Definitions,Oracle Apps,Apps DBA

You can identify that all the Application Accounting Definition Validated by checking the Out put file of the concurrent program.

Validate Application Accounting Definitions,How To Validate Application Accounting Definitions,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,Application Accounting Definitions,Validate ERP Application Accounting Definitions,Oracle Apps,Apps DBA

Go to AR Invoice and try to do create accounting. Now Create Accounting concurrent program gets Completes Normal.

Validate Application Accounting Definitions,How To Validate Application Accounting Definitions,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,Application Accounting Definitions,Validate ERP Application Accounting Definitions,Oracle Apps,Apps DBA

Share

How To Open Multiple Forms At A Time In Oracle ERP

March 28th, 2018, posted in Oracle
Share

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”.

How To Open Multiple Forms At A Time In Oracle ERP,How To Open Multiple Forms At A Time,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,How To Open Multiple Forms Oracle Application

 

Uncheck the check box

How To Open Multiple Forms At A Time In Oracle ERP,How To Open Multiple Forms At A Time,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,How To Open Multiple Forms Oracle Application

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.

How To Open Multiple Forms At A Time In Oracle ERP,How To Open Multiple Forms At A Time,Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,How To Open Multiple Forms Oracle Application

Share

Third Party Control Segment Qualifier its Options and Usage

March 22nd, 2018, posted in Oracle
Share

In General Ledger. When we define values in Natural Account. We assign segment qualifiers. Among Segment Qualifiers. “Third Party Control” Segment Qualifier is one of the Qualifier. Today i am sharing the information on Third Party Qualifier.

1. What is meant by “Third Party Control”?

Ans. When we assign or enable “Third Party Control Segment Qualifier”. Here assigning or enabling means select option as “Yes” or “Supplier” or “Customer”. By using that natural account if journal is created then journal should contain “Party Information”. Party Information will be available for a journal when it is created from Sub-Ledgers. Incase Party information is missing for that natural account then the Accounting Program completes in error stating ” Party Information missing”. Normally for manual journals party information will not be available.

2. Who are all parties?

Ans. In R12 as per TCA all the suppliers and customers are treated as Parties.

3. What all the options available in “Third Party Control Segment Qualifiers”?

Ans. Prior to R12.1.3 version there are 4 options. They are

a. No (Default Value)
b. Yes
c. Supplier
d. Customer

In R12.1.3 one additional option is included it is

e. Restrict Manual Journals.

4. What is the Importance of the options available in “Third Party Control Segment Qualifiers”?

Ans.

Value “NO”

If we select option “No” means we are not using Third Party Control Segment Qualifier.

Value “Yes”

If we select option as “Yes” it means that value can be used in AP Sub Ledger (Supplier information is Available) and as well as in AR (Customer Information is available)

Value “Supplier”

If we select option as “Supplier” it means we are going to use this value in AP (Where Supplier information is available)

Value “Customer”

If we select option as “Customer” it means we are going to use this value in AR (Where Customer information is available)

Value ” Restrict Manual Journals”

If we select option as ” Restrict Manual Journals” where we can use this value in sub-ledger (With or with out party information ). But we can not use this value in General Ledger for Manual Journals.

 

Oracle ERP,Oracle ,ERP,Oracle ERP Application,Oracle Application,Oracle DBA,Oracle Forms,racle Apps,Apps DBA,Create Accounting concurrent program,Create Accounting, concurrent program,Third Party Control Segment Qualifier its Options and Usage,Third Party Control Segment Qualifier ,Options and Usage

 

5. Why  in R12.1.3 version New Option “Restrict Manual Journals” Option introduced?

Ans. Before R12.1.3 if we enabling Third Party Control for the value (Unidentified Cash) and by using the same value if we book Unidentified Receipt. We face issue while performing Create Accounting with error message (party information missing). Which is a bug because we book unidentified receipt where party information is not available. To over come this issue Oracle introduced new value called “Restrict Manual Journals”. By enabling this option we can create journals from sub ledger with out party information but we cannot book manual journal from General Ledger (GL) for the same value.

6. What is the use of “Third Party Control Segment Qualifier”

Ans If we are not enabling or not using “Third Party Control Segment Qualifier” for Control Accounts then we face issues while performing Reconciliation from Sub ledger to GL. Normally we perform periodical reconciliation for control accounts from sub ledger to GL. Due to non enabling “Third Party Control Segment Qualifier” user may pass manual journal entries using control account which will cause difference from Sub ledger to GL. To over come these issue it is suggested to enable “Third Party Control Segment Qualifier” for control Accounts.

7. In which all sub ledgers we can use “Third Party Control Segment Qualifier” for control accounts?

Ans. Prior to R12.1.3 we can use “Third Party Control Segment Qualifier” for control accounts related to Accounts Payables (AP) and Accounts Receivables (AR). But after R12.1.3 due to new option “Restrict Manual Journals” option we can use in all sub ledgers.

Share