When trying to startup [nomount] an instance in 12.2.0.1.0 from sqlplus by using a pfile, (startup nomount pfile=’my_pfile’) the following messages are displayed: ORA-39510: CRS error performing start on instance ‘TESTDB’…
Read MoreIntroduction: This script will used to extract the AR partial credit memo’s with reference invoice details. select c.trx_number CM_Number, c.trx_date CM_DATE, (select a1.account_number from hz_cust_accounts_all a1 where a1.cust_account_id=c.bill_to_customer_id)CM_Customer_Number, d.line_type CM_LINE_TYPE,…
Read MoreGST Tax Category Setup: I.USER SETUP 1. Create a new GST Responsibility – ( Oracle India Financial) Navigator:- Navigator:- System Administrator > Security > User Define -> Oracle India Financial Assign…
Read MoreISSUE: User was unable to view the responsibilities when logged in. SOLUTION: 1.Check the responsibilities of the user. 2.If the responsibilities are not end dated, end date the user(not the…
Read More12.2 ADOP Prepare Phase Fails with below error message, Error: Validating configuration on node: [apps]. Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps [UNEXPECTED]Error occurred running “perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs2/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps -promptmsg=hide” [UNEXPECTED]Error 1 occurred…
Read MoreOverview Incremental search is the search option, Using this option user will get the searching information as soon as the user starts typing in the input search field. To create this feature in the oracle apex we are going to create a text field item and interactive report. Also, We can create this using the classic report. Technologies and Tools Used The following technology has been used to achieve the expected output. JavaScript Use Case In oracle apex search option in the reports will work only when the user enters the enter key or…
Read MoreCause : Query the below parameter in db context file. grep s_patch_service entry $CONTEXT_FILE (This is was not present in my context file, thus the error was tripping) Soultion :…
Read More$adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. Solution : $cd /oracle/PROD/apps/fs_ne/EBSapps/log/adop/13/fs_clone_<time_cloe>/SID_hostname $vi ADOPValidations_detailed.log look for the ERROR: in the…
Read MoreMany of us would have come across the word “Multitenant Architecture” in Oracle world. By the time, we read this, some of us feel boring to go in detail and…
Read MoreSetting JAVA_HOME path 1.Open the .bash_profile using vi editor for the root user 2.Add the following environment variable in the file. The following is the code snippet of .bash_profile. The…
Read More