Monday, 28 March 2011

Custom QA Check for Service Contracts

Here is new post on how to add Custom QA Check for Service Contracts.

Below are the steps to be followed:


1. Create a Custom PL/SQL package with the necessary procedure for each of the checks to be performed.
    Say for example, QA Check to perform the maximum invoice

    Package :  XX_CUSTOM_QA_PKG
    Procedure : XX_QA_MAX

2. Compile the PL/SQL package.

3. Login to Oracle EBS

4. Navigate to responsibility : US Service Contracts Manager

5. Click on Setup -> Contract

6. Click on 'Process Definition'

7. Create a New record with the following parameters values :
           Name                   :   Custom QA Check   
           Description           :    New Custom QA Check   
           Purpose                :    Quality Assurance   
           Effective Dates      :  28-MAR-2011
          Type                      :  PLSQL
          Package                 :  XX_CUSTOM_QA_PKG
          Procedure              :  XX_QA_MAX

8.  Click on 'Validate Name' button.

9. Save the Record

10. Now Navigate to Setup -> Contract -> Quality Assurance.

11. Do F11 and Query, Name : Custom QA CheckList

12. Add a new Run Sequence, with the following details :

        Run Sequence     10
        Name                 Custom QA Check
        Description         New Custom QA Check
        Active                 Yes
        Severity              Warn
        Access Level      User
        Start Date           28-MAR-2011
        End Date    [ ]
13. Save the Record.

14. Now Custom QA Check is ready, this can be used while validating the Service Contracts.

1 comment:

  1. Any normal Package will do or Thers is some special syntax in that the procedure wil be defined

    ReplyDelete