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 MoreSELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read MoreSyntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Read MoreSyntax: POWER(<base number>, <exponent number>) Query: select POWER(3,3) from dual; Output: This function return base number raised to the exponent’s power. 27
Read MoreSyntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read More1. As <ROOT_USER>, log in to Node 1 and cd to the “/tmp” directory. # cd /tmp 2. Use “vi” or editor of your choice, to create the “osw_capture” script…
Read MoreProblem : [ebsprd@myebstes01 ~]$ adop -status Enter the APPS password: *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Aug 27 03:42:33 2021 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS…
Read MoreADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution Problem: [ebsprd@myebstes01 ~]$ adop status *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Aug 27 03:31:33 2021 FUNCTION:…
Read MoreGather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP Cause: FDPSTP failed due to ORA-20005:…
Read More