Wrapper Program Oracle Apps

Enabling Disabling Concurrent Program parameters. Enablingdisabling concurrent program parametersFind out how to enabledisable concurrent program parameters conditionallydynamically. Arun Sista. This. This article is for use of anyone who wishes to develop a. Background Overview. I. decided to write this based on some of my experience at Oracle where I. Image/5f51dde0a59b5b4164c96dbcacbb0027/gatherschemastatistics.jpg' alt='Wrapper Program Oracle Apps Interview' title='Wrapper Program Oracle Apps Interview' />This article contains a detailed explanation in text as well as an audio visual with a demo on the topic. Scenario Let us assume that we are trying to create a concurrent program. XCUSTOMTESTCONCPROGRAM that has 3 parameters. The. first parameter is called Requisition Type and the values are. POSRSREQUISITIONTYPE. The values in this parameter can be. INTERNALPURCHASE. E28280_01/integration.1111/e10537/img/adapter_6plpart2.gif' alt='Wrapper Program Oracle Apps' title='Wrapper Program Oracle Apps' />Oracle Corporation is the current owner of the official implementation of the Java SE platform, following their acquisition of Sun Microsystems on January 27, 2010. Oracle to PostgreSQL migration tool, automatically convert Oracle and MySQL database to PostgreSQL. Wrapper Program Oracle Apps ModulesThe. Inventory Organization and is dependent on. Requisition Type and would be enabled if the value in Requisition Type. HomeWebsocket/images/t30102.png' alt='Wrapper Program Oracle Apps Dba' title='Wrapper Program Oracle Apps Dba' />INTERNALThe. X-Plane Crj 200 Update there. Supplier and is dependent on Requisition Type. Requisition Type is PURCHASEStep 1 Preliminary SetupKnowledge. Wrapper Program Oracle Apps' title='Wrapper Program Oracle Apps' />View and Download Oracle Application 9i configuration manual online. Wireless Edition Release 1. Application 9i Server pdf manual download. Understanding. on creation of concurrent programs and concurrent program parameters. Concept We. would use dependent value sets to enable disable parameters. The idea. is simple and straight forward. You can have a value set A that drives a parameter. And another value set B that drives the second parameter. If I want to introduce a condition such that B does not get enabled till I enter a value in AI would have to make B as a dependent value set on A. There are two ways to do this. For table based value sets you need to put in a condition in the where clause that has a reference to the driving value set. B is a table based value set it would need to reference A in the where clause in the following manner and FLEX. A lt some value. This. B does not get initialized till the. A returns a value this in turn keeps the parameter for B. You can create a normal dependent value sets and define dependencies on other value sets. So how would we approach our problem where we want to enabledisable values based on another parameter. I would define a parameter that provides the driving valuethis creates the dependency. This is driven by value set Ab. I. would create a dummy parameter based on a value set that returns Y or. Null. I would default the value in this dummy parameter such that it. Y for the positive condition and null for the negative. I. would insert a clause such in its value set that it is dependent on. What happens because of this is thatthe dummy parameter returns Y. However if the condition fails the dummy parameter. Step 2 Create value sets. Create. value sets for all the parameters including the dummy parameters. In. our case we would create the following value sets in this given order to. POSRSREQUISITIONTYPE Value set for the Requisition type. XXCUSTOMENABLESUPPLIER Value set to enabledisable the Supplier parameter. Enter the possible values for the value set. XXCUSTOMENABLEINVORG Value set to control enablingdisabling the Inv org parameter. Enter the possible values for the value set. XXCUSTOMINVORGANIZATIONS Value set for the Inventory Organization parameter. XXCUSTOMVENDORLIST Value set for Vendor parameter. Step 3 We would define the concurrent program itself. And add parameters to it with default values. Create the concurrent program by the name XXCUSTOMTESTCONCPROGRAMDefine the concurrent program parameters Creat the parameter for Requisition Type and enter the Value Set as POSRSREQUISITIONTYPECreate a dummy parameter Inv Org enable with value set. XXCUSTOMENABLEINVORG. Set the default type to SQL Statement and set the default value toselect decode FLEX. POSRSREQUISITIONTYPE,INTERNAL,Y,NULL from dual. Set the displayed value to false by un checking the check box. Create a dummy parameter Supplier Enable with value set XXCUSTOMENABLESUPPLIER. Set the default type to SQLStatement and set the default value toselect decode FLEX. POSRSREQUISITIONTYPE,PURCHASE,Y,NULL from dual. Set the displayed value to false by un checking the check box. Create a parameter for Inventory Organization and assign the value set XXCUSTOMINVORGANIZATIONSCreate a parameter for Supplier and assign the value set XXCUSTOMENABLESUPPLIER. Add concurrent program to request group and run Switch to the sysadmin responsibility and add your concurrent program to the All Reports request group for purchasing. Navigate to Purchasing Responsibility and run the concurrent program and see the results for yourself. Video Demo. Video Demo.