Current Position:Home > APP-SQLAP-97038

APP-SQLAP-97038

Update:11-30Source: network consolidation
Advertisement
hello,
We have a PO 108 that was partially matched to an invoice in an organization to it's chart of accounts. The PO was moved to a new organization according to requirements of new set of books and new charts of accounts to be created. A new invoice was created in the new set of books and matched to PO 108. After the attempt of changing the distribution account, the invoice was held by the system with hold name: "Dist Acct Invalid", with hold reason:"Distribution account is invalid".The invoice staus was changed to "Needs Revalidation".
The user tried to unrelease the hold but the following error shows up :
APP-SQLAP-97038:This invoice has at least one hold that you cannot manually release. For holds you cannot manualy release, you need to resolve the exception that caused the hold to be applied and then resubmit Validation to release hold.
How can I check what caused the problem and how to solve it?
The user have enterd 2 new invoices later and matched it to po 108, with the same distribution account .One of them is validated and the other one is never validated by the system.
Any ideas will be very helpful...

The Best Answer

Advertisement
am trying to create a standard invoice in Oracle AP , upon validation of the said invoice there is an error message appeared like as " APP-SQLAP-1000 ORA 01403. No data found occurred in with parameters (Terms id= Sequence Num=1) while performing the following operation: and debug Info."
The consequence would be the invoice cannot be validated.
  • APP-SQLAP-97038 Update:11-30

    hello, We have a PO 108 that was partially matched to an invoice in an organization to it's chart of accounts. The PO was moved to a new organization according to requirements of new set of books and new charts of accounts to be created. A new invoic

  • APP-SQLAP-10710: Online Accounting could not be created Update:10-11

    Hi, The following error occurs when trying to run the "Create Accounting" procedure for an invoice: "APP-SQLAP-10710: Online Accounting could not be created. Please submit the Payables Accounting Process instead to create accounting entries

  • Create accounting error :APP-SQLAP-100000,  ora-00000 Update:11-30

    afer validate the AP credit memo. create accounting occured the error as below the first form 'NOTE :create accounting successfully' the secone form 'ERROR APP-SQLAP-10000:.........(x_rowid=AAAAHTUAAXAABIDYAA,X_invoice_id= 34345 ,ap_in:normal, succes

  • APP-SQLAP-10252: You cannot Confirm a payment batch Update:11-30

    Dear all: IN ORACLE EBS 11.5.9 , When I click the button "Action 1" in "Payment --> Entry --> Payment Batch" and choose the "Confirm the payment Batch" will show the error: *"APP-SQLAP-10252: You cannot Confirm a p

  • Cash Management / Payables: APP-SQLAP-10786 error when unreconciling Update:11-30

    Hi, We are trying to unreconcile a payment in Cash Management but Oracle gives us an error: APP-SQLAP-10786: No payments were found to reconcile. (DEBUG_INFO=checkrun is null, recon flag is Y, before select) Can anyone assist? This transaction was en

  • APP-SQLAP-10380: You cannot select this payment document Update:11-30

    User did a quick payment. When the check failed to print user voided the check and tried to reprint. Now when the user is trying to reissue the check they are getting the following: APP-SQLAP-10380: You cannot select this payment document because it

  • Error APP-SQLAP-10132 during invoice saving Update:11-30

    Hello Attempting to save an invoice I see the error message "APP-SQLAP-10132 The invoice is already selected for Payment in a payment Batch and cannot be adjusted and delted." It is the first time I see this message during 3 years. We use applic

  • Oracle Payable - Payment Batches error " APP-SQLAP -10380" Update:11-30

    Hi, I still trying to get my head around this module but i get this error message - APP- SQLAP-10380 When trying to create a batch payment on 11i, i got "You cannot select this payment because it is in use by another payment batch. I have gone to Act

  • AP-Validating Invoice gets APP-SQLAP-99734 error message for line 32 becaus Update:11-30

    Hi All, We got an AP Invoice that we zero out the lines, and we have validated but when we go to do the accounting, we get the following error message: APP-SQLAP-99734: The system cannot generate distributions for line 32 because: &TOKEN2 The distrib

  • Invoice Validation Error ORA-06512: at "APPS.AP_APPROVAL_PKG", line 111124 Update:10-11

    All, I am getting below error message from log file after Invoice Validation program error out, please advise. I could not search on "ORA-06512: at "APPS.AP_APPROVAL_PKG", line 11124" search, but found other errors and able to see we a