SELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, fls.meaning note_type_meaning, jnt.notes notes FROM apps.hz_cust_accounts hca, apps.jtf_notes_b jnb, apps.jtf_notes_tl jnt, apps.fnd_lookups…
Read MoreSELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read MoreSyntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read MoreProblem: Adcfgclone got complete but at the end it failed for autoconfig with the below error. Error : WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during…
Read MoreCause: Unable to initialize state monitor. oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at “APPS.FND_CP_GSM_IPC”, line 499 ORA-06512: at line 1 at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233) at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)…
Read MoreCause: $ adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. Solution : Check adop log using $ADOP_LOG_HOME command $ cd…
Read MoreCause: BUILD FAILED /u01/app/122/fs1/EBSapps/comn/java/classes/oracle/apps/fnd/txk/util/txkISGConfigurator.xml:1756: ${patchContextFile} doesn’t exist ! The issue can be reproduced at will with the following steps: 1. “ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup -DforceStop=yes” There was a missing entry…
Read MoreIF YOU DON’T KNOW CURRENT PASSWORD ———————————– If you forget your administrative password and cannot start the server, the following procedure works for the default authenticator Note: This is not…
Read MoreWhen applying ADOP patch, we getting below error like “APPS.WF_EVENTS+” ORA-20002: Seed Data Table has not been prepared for patching ORA-06512: at “APPS.WF_EVENTS+”, line 1, ORA-04088: error during execution of…
Read MoreContainer Database (CDB) Architecture: With the Database 19c certification, EBS 12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture). As part of the upgrade to Database 19c,…
Read More