Posts by Venkatesh Kumar T

APP-SQLAP-10771: Could not reserve record.

Error: APP-SQLAP-10771: Could not reserve record. Unable to pay the AP invoice in full, Got above error while performing the action –> pay in full Solution: Database lock from another…

Read More

Some useful scripts – V1

Some useful fnd scripts which available in $FND_TOP/sql directory FNDATPRG.sql  Purge audit trail tables before a given date FNDCPDC2.sql  Delete a concurrent program and SRS definition if needed, calls FNDCPDCP.sql…

Read More

Workflow related useful scripts – $FND_TOP/sql

wfbkg.sql    WorkFlow BacKGround engine, starts the background engine, running for the indicated number of minutes. wfbkgchk.sql WorkFlow Background Check. It displays a status report on background work waiting to…

Read More

EBS R12.2 ADOP phases and parameters

EBS R12.2 ADOP phases and parameters 1) Prepare  – Starts a new patching cycle. Syntax:  adop phase=prepare 2) Apply – Used to apply a patch to the patch file system…

Read More

To recover Concurrent Manager – Concurrent Manager recovery Wizard – EBS 11i/R12

Concurrent Manager Recovery Wizard – Oracle Applications Manager Troubleshooting and Diagnostics Follow the below steps to use the Concurrent Manager Recovery Wizard: 1. To access the Concurrent Manager Recovery Wizard, use…

Read More

How To Clear BNE Cache in EBS 11i/R12

GOAL: To clear BNE cache in EBS environment Solution: To Clear BNE cache: A. Releases prior to 12.2.7 Using System Administrator responsibility: Login to the application as a user with…

Read More