Script to OE_ORDER_PUB.PROCESS_ORDER ( Sample Script Create Sales Order ) Script PROCEDURE xx_bdg_so_interface ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) IS v_api_version_number NUMBER := 1; v_return_status VARCHAR2…
Read MoreThis error occurred in OAF when I added the new export button to table layout region. For this error just right click on our VO (View Object) and select Edit.…
Read MoreEnterprise 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 MoreConcurrent 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 MoreGOAL: 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 MoreRequirement 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 MoreOverview 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 MoreSometimes, 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 Moreselect 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 MoreSELECT 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