Posts Tagged ‘Oracle’

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

Query To Check Oracle Apps Modules Licensed Or Not

February 12th, 2018, posted in Oracle Queries
Share

Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 490735648 bytes Database Buffers 335544320 bytes Redo Buffers 6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.The following is a Query to check if Oracle Apps Modules Licensed or not :

 

SELECT fat.application_name
      ,fa.application_id
      ,fpi.patch_level
      ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
  FROM fnd_product_installations fpi
      ,fnd_application fa
      ,fnd_application_tl fat
 WHERE fpi.application_id = fa.application_id
   AND fat.application_id = fa.application_id
   AND fat.LANGUAGE = 'US';
Share

adcfgclone.pl dbTechStack – RC-50004 Error occurred in CloneContext Target System Domain Name

February 4th, 2018, posted in Oracle, Solaris
Share

RC-50004: Error occurred in CloneContext – Target System Domain Name in

adcfgclone.pl dbTechStack :

Error:

Target System Domain Name : worths.co.za
RC-50004: Error occurred in CloneContext: 
null
Check Clone Context logfile
/ebsdbprd_app/oracle/product/ebsdbprd/db/tech_st/11.2.0/appsutil/clone/bin/CloneContext_0418120037.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_4849738.err if present.


adcfgclone.pl,oracle apps,oracle dba,oracle apps dba,oracle,dba,oracle error,ora error,oracle errors,adcfgclone.pl dbTechStack RC-50004 Error occurred in CloneContext Target System Domain Name,Target System Domain Name,adcfgclone.pl dbTechStack,RC-50004 Error,RC-50004,Error,clone error,oracle clone error,apps error,database error,oracle database,database oracle error,database,APPS-domain-50004,APPS domain 50004,RC 50004,RC 50004 Error

 

Solution :
Ensure that your hostname is fully populated in the /etc/hosts file

Not like this:

3 $ grep ebsdbprdp7 /etc/hosts
19.36.148.157   ebsdbprdp7
w@ebsdbprdp7:/
4 $

Should look like this

3 $ grep ebsdbprdp7 /etc/hosts
19.36.148.157   ebsdbprdp7.domain.co.za  ebsdbprdp7
w@ebsdbprdp7:/
4 $
Share