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

in Oracle E-Business Suite & Oracle Fusion Applications; Dear all, While Validating Invoice in AP , Exception is coming. Please find the attached document. Please guide me.. Thanks ...
+ Post Reply + Post New Topic
Results 1 to 3 of 3
  1. #1
    Join Date
    20 Aug 2012
    Location
    Guntur,Andhra Pradesh
    Posts
    31
    Points
    1,040

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

    Dear all,

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

    Thanks
    Durga
    Attached Images
    Last edited by durgareddygade; 10-04-2012 at 09:18 AM.


  2. #2
    yingsras is offline Forum Advisor
    Points: 3,670, Level: 38
    Join Date
    03 Aug 2011
    Location
    Bangkok, Thailand
    Posts
    138
    Points
    3,670

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

    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_grp s)
    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. #3
    erp.narendrag's Avatar
    erp.narendrag is offline Forum Advisor
    Points: 2,780, Level: 32
    Join Date
    02 Oct 2012
    Posts
    72
    Points
    2,780

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

    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

Other Solutions
  1. Replies: 2
    Last Post: 01-05-2012, 03:49 AM
  2. Replies: 0
    Last Post: 01-28-2011, 04:55 AM
  3. App-sqlap-10006
    By Syed Shahed Ali in forum Oracle Financials
    Replies: 6
    Last Post: 07-18-2009, 01:48 PM
  4. user defined types in oracle
    By krithika@2001 in forum SQL PL/SQL
    Replies: 2
    Last Post: 06-24-2009, 04:04 AM