Oracle ERP Professionals

FUNCTION GET_BALANCE_VALUE (p_assignment_id    IN NUMBER,
                               p_balance_name     IN VARCHAR2,
                               p_dimension_name   IN VARCHAR2,
                               p_date             IN DATE)
      RETURN NUMBER
   IS
      v_bg_id            per_business_groups.business_group_id%TYPE;
      v_leg_code         per_business_groups.legislation_code%TYPE;
      v_defined_bal_id   pay_defined_balances.defined_balance_id%TYPE;
      v_bal_value        NUMBER;
   --
   BEGIN
      --
      SELECT paaf.business_group_id, pbg.legislation_code
        INTO v_bg_id, v_leg_code
        FROM apps.per_business_groups pbg, apps.per_all_assignments_f paaf
       WHERE     paaf.business_group_id = pbg.business_group_id
             AND paaf.assignment_id = p_assignment_id
             AND paaf.primary_flag = 'Y'
             AND paaf.assignment_type = 'E'
             AND TRUNC (p_date) BETWEEN paaf.effective_start_date
                                    AND  paaf.effective_end_date;

      --
      v_defined_bal_id :=
         get_defined_balance_id (v_bg_id,
                                 p_balance_name,
                                 p_dimension_name,
                                 v_leg_code);
      --
      v_bal_value :=
         get_balance_value_on_date (p_assignment_id,
                                    v_defined_bal_id,
                                    p_date);
      RETURN v_bal_value;
   --
   EXCEPTION
      WHEN OTHERS
      THEN
         RETURN 0;
   END GET_BALANCE_VALUE;

Deployment Steps for OA Framework on R 12.2.x or R 12.2.4

Steps to deploy custom OA Framework page on R 12.2.4

1) Copy class files on server
2) Create ZIP file
3) Make Jar file from the ZIP file created before
4) Bounce the services

1) Copy class files on server
==================================
Copy files to custom folder path on server.

2) To Make .ZIP file
==================================
A) Create a temporary custom.zip file which contains all the custom application's directories/files at non-standard location. Please follow the following steps:

    1) cd $JAVA_TOP

    2) zip -r customprod.zip. Where the list of all directory paths are present, relative to $JAVA_TOP, for custom application's java files at non-standard location.

    Command: zip -r xxtest.zip xxtest

    3) Generate & sign customprod.jar file.

    Command: adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

3) To Make .JAR file
==================================
example : adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/customprod.zip -outputFile $JAVA_TOP/customprod.jar -jar $CONTEXT_NAME 1 CUST jarsigner -storePass -keyPass

Command:     adjava oracle.apps.ad.jri.adjmx -areas $JAVA_TOP/xxtest.zip -outputFile $JAVA_TOP/xxtest.jar -jar $CONTEXT_NAME 1 CUST jarsigner 


4) Bounce the Apache and mid-tier service by using the following commands.
==================================
adapcctl.sh stop

adapcctl.sh start

admanagedsrvctl.sh stop oacore_server1

EnterWeblogic Password:

admanagedsrvctl.sh start oacore_server1

EnterWeblogic Password: