Oracle Apps R12

Mobile First strategy with Oracle CX Mobile App

Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…

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

Make single column excel output to excel row output in XML Publisher

Requirement Single Excel column output with multiple data separated by comma need to make row-wise data, eg Name Marks Peter 50,70,30 Need to change with this Name Marks Peter 50…

Read More

How to disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form Oracle Apps R12.

Overview In order to disable New Record Button, Clear Button and Delete Button, Please follow below step Write the code in the Form Level Trigger (WHEN-NEW-BLOCK-INSTANCE) IF :XXBEX_PRO_BUDGET_HEADER_V.PROJECT_STATUS IN (‘PROJECT…

Read More

Disable Descriptive Flex field (DFF) at form level through CUSTOM.pll

Sometimes, We have a requirement to disable the DFF at form level. Either have to do disable the DFF as well or Read-Only of the attribute of the DFF. So,…

Read More

Find Concurrent Manager status from Backend

select decode(CONCURRENT_QUEUE_NAME, ‘FNDICM’,’Internal Manager’, ‘FNDCRM’,’Conflict Resolution Manager’, ‘AMSDMIN’,’Marketing Data Mining Manager’, ‘C_AQCT_SVC’,’C AQCART Service’, ‘FFTM’,’FastFormula Transaction Manager’, ‘FNDCPOPP’,’Output Post Processor’, ‘FNDSCH’,’Scheduler/Prereleaser Manager’, ‘FNDSM_AQHERP’,’Service Manager: AQHERP’, ‘FTE_TXN_MANAGER’,’Transportation Manager’, ‘IEU_SH_CS’,’Session History Cleanup’,…

Read More

To check scheduled concurrent request in R12

SELECT cr.request_id, DECODE (cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’ || cr.description, cp.user_concurrent_program_name ) NAME, argument_text, cr.resubmit_interval, NVL2 (cr.resubmit_interval, ‘PERIODICALLY’, NVL2 (cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’) ) schedule_type, DECODE (NVL2 (cr.resubmit_interval, ‘PERIODICALLY’,…

Read More

ADOP – Applications DBA Online Patching Tool

ADOP: Oracle E-Business R12.2 introduced new patching mechanism that allow the application of patches while your environment is up and running which is called as Online patch. The online patching cycle…

Read More

ORA-01804: failure to initialize timezone information – issue while running AutoConfig during Upgrade Oracle Apps (EBS) to 12.2 ?

issue “ORA-01804: failure to initialize timezone information” in Post Database upgrade 11.2.0.4  step while running AutoConfig. 1. Running Autoconfig on Database tier as $ORACLE_HOME>/appsutil/bin/adconfig.sh ERROR: ORA-01804: failure to initialize timezone…

Read More