1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

APP-SQLAP-10000: User-Defined Exception occurred while validating invoice

Discussion in 'Oracle Financials' started by durgareddygade, Oct 4, 2012.

  1. durgareddygade

    durgareddygade Active Member

    Messages:
    32
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Dear all,

    While Validating Invoice in AP , Exception is coming.
    Please find the attached document.
    Please guide me..

    Thanks
    Durga
     

    Attached Files:

  2. yingsras

    yingsras Forum Advisor

    Messages:
    149
    Likes Received:
    15
    Trophy Points:
    280
    Location:
    Bangkok, Thailand
    I found this error on this document id 750043.1
    Please check if the solution below can solve your problem.


    Symptoms

    -- Problem Statement:
    When trying to validate a Payable Invoice with India Localization TDS(Tax Deducted at Source) Tax Id
    the below error occurs :-

    ERROR
    ---------------
    APP-SQLAP-10000 : User Defined Exception occured in
    Error from trigger JAI_AP_IDA_BRIUD_T1
    with parameters (&PARAMETERS)
    while performing the following operation:
    Error - ja_ap_aida_before_trg on
    ap_invoice_distributions_all :
    Vendor PAN Number must be specified as threshold group identifier is
    null(jai_ap_tds_generation_pkg.maintain_thhold_grps)
    Cause

    The error message signifies that the Vendor PAN Number is not available at Site Level record.
    As per the Standard Functionality, the PAN Number details get defaulted from Null Site record to
    Site Level record.The issue is caused when the Vendor Additional Information for Site level is
    created before the Null Site level. In such cases, the Site level record will not have a PAN Number.

    This can be verified be running the below select statement which shows the Site level as well as
    the Null Site level records along with the creation date and time.
    select * from jai_ap_tds_vendor_hdrs where vendor_id = &vendor_id

    Solution

    -- To implement the solution, please execute the following steps::
    1. Navigate to the responsibility: India Local Payables.

    2. Navigate to Oracle Payables -> Supplier

    3. Inactivate the Vendor by providing an end date.

    4. Create a fresh Vendor.

    5. Create Supplier Additional Information for the New Vendor (first Null Site and then Site Level)

    6. Retest the issue for the New Vendor created.

    7. Migrate the solution as appropriate to other environments.
     
  3. erp.narendrag

    erp.narendrag Forum Expert

    Messages:
    103
    Likes Received:
    16
    Trophy Points:
    655
    Location:
    Kadapa
    You can have one more option also
    Update PAN to null site or Site wherever PAN not available
    It is possible through program called India - Pan number Update also