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 More1. Overview This document talks about how to remove the options from the interactive grid action menus. 2. Technologies and Tools Used The following technologies have been used to achieve…
Read More1. Overview When using Interactive grid, sometimes user don’t want to go with add row button for a new row generation. On those cases, this document shows, how to generate…
Read MoreDescription: The oracle OS user does not have the appropriate privileges on the OS directory, or if the path specified in the database does not match to an actual path,…
Read MoreDescription: Scheduler jobs are the automated process handled by the database scheduler in oracle. It will run the scheduler jobs in a specific server time intervals like daily , weekly…
Read More1. Overview Responsive Reports can be created in Oracle Apex Classic Reports. Standard Oracle APEX which shows the tabular format of the dataset doesn’t support the responsiveness as the device…
Read MoreThe Idle Time Resource Usage setting limits the maximum idle time allowed in a session. Idle time is a continuous inactive period during a session, expressed in minutes. Long-running queries…
Read More1.Overview A popup menu can be created in the application by using Lists and associating a button with the menu. To create a popup menu in the application, first have…
Read MoreError:- While the RMAN Active Duplicate is initiated, the rman job failed with the below errors, RMAN-03009: failure of backup command on C1 channel ORA-17628: Oracle error 19505 returned by…
Read MoreERROR:- SQL> create spfile from pfile; create spfile from pfile * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-32003: error occured processing parameter ‘utl_file_dir’ LRM-00101: unknown parameter…
Read More