Oracle EBS

Concurrent Manager Has Put The Concurrent Request On Hold all of Sudden

Introduction: In Oracle E-Business Suite 12.2, concurrent requests can occasionally be placed on hold due to various system behaviors and user actions. This blog will outline the key scenarios that…

Read More

TXK Delta 13 failed due to missing files

TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…

Read More

Adop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found

AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…

Read More

adcfgclone.pl error :RC-50014: Fatal: Execution of AutoConfig was failed in R12

While R12.2.5 cloning autoconfig failed with the below error AutoConfig is exiting with status 1 ERROR: RC-50014: Fatal: Execution of AutoConfig was failed Raised by oracle.apps.ad.clone.ApplyApplTop END: Executed runAutoConfig… ERROR:…

Read More

Oracle R12 Query To Find Customer Notes

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 More

Oracle R12 GL To AR Transaction Details

SELECT 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 More

Oracle R12 AR Lockbox Query

SELECT 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 More

Gather Schema Statistics fails with ORA-20005

Gather 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

Sometimes the Formsapp.ear deployment fails on Application startup after applying Patches

Error while executing the perl script txkChkFormsDeployment.pl We have determined that you need to redeploy Forms (using txkChkFormsDeployment.pl). But could not do it automatically for you, due to some issues.…

Read More

BI Publisher program failed due to opp

Error: “Post-processing of request 4667897 failed at 30-Apr-2021 15:54:50 with the error message: One or more post-processing actions failed. Consult the OPP service log for details.” … oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException”…

Read More