Bravery Family

Tag: eBusiness

  • eBusiness Autoconfig Customisation

    Why customise? Autoconfig Customisation has the potential to make life much easier for an Oracle Applications DBA. In short, it enables the creation of controlled templates that can make all of the things that have to be done after running autoconfig go away. For example, generally after you run adautocfg.sh you then have to remember…

  • Oracle eBusiness Submit Job – PL/SQL

    Again, a simple piece of code: This also runs Active User concurrent program: declare  v_request_id number := -1;begin  –fnd_global.apps_initialize(user_id, resp_id, appl_resp_id)  fnd_global.apps_initialize(0, 20420, 1); –So sysadmin using responsibility System Administrator in application System Administration  –v_request_id : fnd_request.submit_request(application short name,concurrent program short name,argument1 =>,  argument2 =>))  v_request_id := fnd_request.submit_request(application=>’FND’,program=>’FNDSCURS’);  commit;  if v_request_id > 0  then    dbms_output.put_line(‘Successfully…

  • Oracle eBusiness Submit Job – Command line

    The below code is the simplest way of doing a job submission for a concurrent program in eBusiness Suite: CONCSUB <db user>/<db password> <user> <role> <application group> WAIT=<Y|N> CONCURRENT <application> <application short name> PROGRAM_NAME=”<long name>” So, as an example take the following command: CONCSUB apps/<password> SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURS PROGRAM_NAME='”Active Users”‘…