Oracle Apps

Ship Confirm

Sample script for Ship confirm PROCEDURE xx_bdg_ship_confirm ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (2); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); p_api_version_number NUMBER := 1.0;…

Read More

Pick Release

Sample script for Pick Release PROCEDURE xx_bdg_sin_delv_picrelease ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (2); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); p_api_version_number NUMBER := 1.0;…

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

Oracle Apps(EBS) – AR Receipt Register Query with Bank statement Header and Line Details

Below query is useful when you required  Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELECT ACRA.RECEIPT_DATE ,( select…

Read More