Running Concurrent Program via CONCSUB

For a concurrent program defined via “Define Concurrent Program” form but submitted via CONCSUB, the following parameters can be used by CONCSUB :

PRINTER=<printer name>
NUMBER_OF_COPIES=<number of reports to be printed>
PRINT_STYLE=<printer style to be used>    
LANGUAGE=<language to be used>

Sample:

CONCSUB apps/apps SYSADMIN “System Administrator” SYSADMIN \
WAIT=Y CONCURRENT FND FNDSCARU LANGUAGE=FRENCH \
PRINTER=hplj4l NUMBER_OF_COPIES=1 \
PRINT_STYLE=LANDSCAPE
   

Note: The others parameters which can be used with CONCSUB
are described in the “System Administration User Guide” as follow :

$ CONCSUB <APPS username>/<APPS password> \
<responsibility application short name> \
<responsibility name> \
<username> \
[WAIT=N|Y|<n seconds>] \
CONCURRENT \
<program application short name> \
<program name> \
[PROGRAM_NAME=<description>] \
[REPEAT_TIME=<resubmission time>] \
[REPEAT_INTERVAL= <number>] \
[REPEAT_INTERVAL_UNIT=< resubmission unit>] \
[REPEAT_INTERVAL_TYPE=< resubmission type>] \
[REPEAT_END=<resubmission end date and time>] \
[START=<date>] \
[IMPLICIT=< type of concurrent request> \
[<parameter 1> … <parameter n>]

For parameters that follow the CONCURRENT parameter and include
spaces, enclose the parameter argument in double quotes, then again in
single quotes.

Change Title On The Apps Main Window using CUSTOM.PLL

Oracle Applications includes a plsql library file called CUSTOM.PLL. This
library may be used to customize various events of Applications Forms.

CUSTOM.PLL is present in the directory:

$AU_TOP\resource\plsql

Modify the CUSTOM.pll to include the following in procedure ‘event’:

IF (event_name = ‘WHEN-NEW-FORM-INSTANCE’) THEN

  Set_Window_Property(FORMS_MDI_WINDOW, TITLE, ‘<customized title>’)

END IF;

   Continue reading

Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions

Subject: Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions.

Section 1: Pre-Update Tasks 

The tasks in this section are required. They can be performed at any time prior to the application of this maintenance pack. Complete them in the order listed. 

1. Determine Required Steps (Optional)

Run TUMS-MP by applying patch 4238286 and following the instructions in the associated readme file. Apply the patch on the administration server node. The Upgrade Manual Script for the Maintenance Pack (TUMS-MP) examines your current configuration and creates a report detailing which of the steps in these instructions you must complete and which steps you can ignore. 

2. Apply the AD Minipack

Apply AD Minipack I.2 (4337683The most recent replacement for this patch is 4712852) on all application tier server nodes. You must have implemented AutoConfig to apply this patch. 

3. Update AutoConfig technology stack template by applying patch 4104924 (Superseded by 3480000- ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK).

Continue reading

PL/SQL Enhancements in Oracle Database 10g

Oracle 10g includes many PL/SQL enhancements including:

Calculating month-wise total days between two dates

This script returns the month-wise total number of days between dates given in parameters.

DECLARE

   dt1            DATE;

   dt2            DATE;

   dt             DATE;

   days           NUMBER := 0;

   no_of_months   NUMBER;

BEGIN

   SELECT CEIL (  MONTHS_BETWEEN (TO_DATE (   ’01-‘

                                           || TO_CHAR (TO_DATE (:date1),

                                                       ‘MON-RRRR’

                                                      )

                                          ),

                                  LAST_DAY (TO_DATE (:date2))

                                 )

                * (-1)

               )

     INTO no_of_months

     FROM DUAL;

 

   SELECT TO_DATE (:date1), TO_DATE (:date2)

     INTO dt1, dt2

     FROM DUAL;

 

   dt := dt1;

   DBMS_OUTPUT.put_line (‘—————————-‘);

 

   FOR dy IN 1 .. no_of_months

   LOOP

      IF dy = 1

      THEN

         days := LAST_DAY (dt1) – dt1 + 1;

      ELSIF dy = no_of_months

      THEN

         days := dt2 – TO_DATE (’01-‘ || TO_CHAR (dt2, ‘MON-RRRR’));

      ELSE

         days := TO_NUMBER (TO_CHAR (LAST_DAY (TO_DATE (dt)), ‘DD’));

      END IF;

 

      DBMS_OUTPUT.put_line (TO_CHAR (dt, ‘MON-RR’) || ‘ Days: ‘ || days);

      dt := ADD_MONTHS (dt, 1);

   END LOOP;

 

   DBMS_OUTPUT.put_line (‘—————————-‘);

END;

Calculating years, months and days between two dates

This script returns the number of years, months and days between dates given in parameters.

SELECT    TRUNC (MONTHS_BETWEEN (:end_date, :start_date) / 12)

       || ‘ YEARS ‘

       || MOD (TRUNC (MONTHS_BETWEEN (:end_date, :start_date)), 12)

       || ‘ MONTHS ‘

       || (  TO_DATE (:end_date)

           – ADD_MONTHS (:start_date,

                         TRUNC (MONTHS_BETWEEN (:end_date, :start_date))

                        )

          )

       || ‘ DAYS’

  FROM DUAL;

By Ankur Bhatia Posted in Oracle

Oracle Database 10g Release 2: New Feature Highlights

Released in January 2004, Oracle Database 10g is the first relational database designed for Grid comp uting, delivering information with the highest quality of service, for the lowest possible cost. Only Oracle Database 10g delivers the clustering, workload management, and data center automation required for enterprise grid computing
as well as the ease of use required for small businesses. With Release 2, Oracle’s focus on improving efficiencies and reducing the cost of information management continues. This data sheet highlights some of the new features in Oracle Database 10g Release 2.

For more information, visit…

New Features in Oracle 10g for SQL*Plus and iSQL*Plus
By
James Koopmann

Don’t wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features that will make a few of your everyday tasks a bit more bearable.

Continue reading