AP发票验证 APP-SQLAP-10000 ORA-01400 AP_ETAX_SERVICES_PKG AP_ETAX_PKG

纵横四海

设置了AP后，作的第一张发票，然后验证报错，可能是那个地方没有设置好；


"APP-SQLAP-10000: ORA-01400: cannot insert
NULL into (""ZX"".""ZX_ERRORS_GT"".""TRX_ID"")
ORA-06510: PL/SQL: unhandled user-defined exception occurred in
AP_ETAX_SERVICES_PKG.Calculate<-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXINWKB
with parameters ( P_Invoice_Id = 10000 P_Calling_Mode =CALCULATE P_Error_Code = P_Calling_Sequence = AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXINWKB)
while performing the following operation:
Call calculate_tax service"

纵横四海

在Google上发现一点线索，先粘贴出来参考

Hi badry,
We were getting the same issue but it was solved not by applying a patch but by defining correctly the taxes in eBtax. The issue we had with the eBTax was that it could not default the tax that should apply for the invoice.
Regards.

Chinaab

是的,我也经常遇到这个Issue

纵横四海

R12: Master Note: Payables Invoice Validation Errors with APP-SQLAP-10000 [ID 1304880.1]

	Presentation	Cause	Fix	More Information
1	When trying to validate invoice, the following error occurs: APP-SQLAP-10000: Summary Tax Line Deleted by EBTax. This would cause orphan distributions occurred in AP_ETAX_UTILITY_PKG.Return_Tax_lines<-AP_ETAX_SERVICES_PKG.Update_AP <-AP_ETAX_SERVICES_PKG.calculate<-AP_ETAX_PKG.Calling_eTax <-AP_APPROVAL_PKG.Approval <-APXINWKB with parameters (P_Invoice_id = X P_Error_code = P_Calling_sequence = AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG..Calculate <-AP_ETAX_PKG..Calling _eTax<-AP_APPROVAL_PKG.Approval <-APXINWKB) while performing the following operation: summary Tax Line ID for this line:Y	Bug 9281264 - RCA: GSI : TAX NOT CALCULATING ON EXPENSE INVS THOUGH BULK VALIDATION and was fixed with the following versions: For R12.0.x: apetxsrb.pls version 120.81.12000000.99 and higher. For R12.1.x: apetxsrb.pls version 120.115.12010000.53 and higher.	For R12.0.x: Patch 10353554:R12.AP.A - LOGGED THIS BUG TO CREATE REPLACEMENT FOR PATCH 10140354 to deliver apetxsrb.pls version 120.81.12000000.131 For R12.1.x: Patch 10353568:R12.AP.B - LOGGED THIS BUG TO CREATE REPLACEMENT FOR PATCH 10261626 to deliver apetxsrb.pls version 120.115.12010000.83	Note 1059427.1
2	When trying to validate invoice via the concurrent request (APPRVL), the following error occurs: REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. ORA-1: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated occurred in Insert_Tax_Distributions <-AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax <-with parameters ( P_Invoice_Id = X P_Calling_Sequence = AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax <-) while performing the following operation: Step 11: Insert new distributions including variances ORA-20001: APP-SQLAP-10000: ORA-1: unique constraint (AP.AP_INVOICE_DISTRIBUTIONS_U1) violated occurred in Insert_Tax_Distributions <-AP_ETAX_UTILITY_PKG.Return_Tax_Distributions<-AP_ETAX_SERVICES_PKG.Update_AP <-AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax <- with parameters ( P_Invoice_Id = X P_Calling_Sequence = AP_ETAX_UTILITY_PKG.Return_Tax_Distributions<-AP_ETAX_SERVICES_PKG.Update_AP<- AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-) while performing the following op	Bug 7371971 - INVOICE VALIDATION COMPLETED WITH ERROR and was fixed with the following versions: For R12.0.x: apaprvlb.pls version 120.94.12000000.53 and higher. For R12.1.x: apaprvlb.pls version 120.140.12010000.17 and higher.	For R12.0.x: Patch 7371971:R12.AP.A - APXINWKB - DIST VARIANCE HOLD INCORRECTLY RELEASED to deliver apaprvlb.pls version 120.94.12000000.53 For R12.1.x: Patch 8596348:R12.AP.B - INVOICE VALIDATION (APXAPRVL.RDF) NO LONGER WORKS AFTER R12 UPGRADE to deliver apaprvlb.pls version 120.140.12010000.42	Note 741393.1
3	Unable to validate PO Matched Invoices due to the following error: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks <-AP_APPROVAL_PKG.Generate_Distributions <-with parameters (Invoice_id = X, Sys Xrate Gain Ccid = , Sys Xrate Loss Ccid = ) while performing the following operation:	Low version of aprmtchb.pls	For R12.0.x: Patch 10327622:R12.AP.A - FINAL MATCHING HOLD PLACED ON AN INVOICE EVEN NO FINALLY MATCHED INVOICES EXISTS to deliver For R12.0.x: aprmtchb.pls version 120.42.12000000.41 For R12.1.x: Patch 10327622:R12.AP.B - FINAL MATCHING HOLD PLACED ON AN INVOICE EVEN NO FINALLY MATCHED INVOICES EXISTS to deliver aprmtchb.pls version 120.43.12010000.31	Note 758062.1
4	Unable to validate matched invoice, receiving the following error: APP-SQLAP-10000: User-Defined Exception occurred in CHECK_AVERAGE_PRICE <- AP_APPROVAL_MATCHED_PKG.Execute_Matched_Checks <-AP_APPROVAL_PKG.Approval <-APXINWKB with parameters (Invoice_id = X, Line_Location_id = X, Inv_Currency_Code= X, PO_Unit_Price = X, Price_Tolerance = X) while performing the following operation: Check_Average_Price - get qty ratio match to RInvoice Validation did not process Invoice Number: X	UOM used on the PO has been disabled	Determine the UOM on the PO and enable it.	Note 1067441.1
5	Invoice Validation (APPRVL) errors with: MSG-00101: Error occured in BATCH_APPROVAL() MSG-00102: Error Code : -20001 MSG-00103: Error Message : ORA-20001: ORA-6512: at "APPS.APP_EXCEPTION", line 72 ORA-6512: at "APPS.AP_APPROVAL_PKG", line 9022 MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. REP-69: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00101: Error occured in BATCH_APPROVAL() MSG-00102: Error Code : -20001 MSG-00103: Error Message : ORA-20001: ORA-6512: at "APPS.APP_EXCEPTION", line 72 ORA-6512: at "APPS.AP_APPROVAL_PKG", line 9022 MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. ORA-20001: APP-SQLAP-10000: User-Defined Exception occurred in AP_FUNDS_CONTROL_PKG.Funds_Reserve<-AP_APPROVAL_PKG.Approval <-APXAPRVL with parameters (invoice_id = X) while performing the following operation: The funds check process failed	Bug 9483091 - VALIDATION ORA-20001 APP-SQLAP-10000 FUNDS CHECK PROCESS FAILED and Bug 10390268 - UNABLE TO VALIDATE INVOICE DUE TO FUNDS CHECK HOLD AND UNABLE TO CHECK FUNDS DUE. In these bugs development confirmed that for matched invoices that are project related, the profile option "PA: Default Expenditure Item Date for Supplier Costs" is checked and if this is not set, the expenditure item date could not default correctly onto the invoice causing this error when the invoice is validated.	Navigate to System Administrator > System > Profile Set the profile option PA: Default Expenditure Item Date for Supplier Costs which will allow the expenditure item date to default correctly to the invoice when the invoice is matched.	Note 1077826.1
6	Invoice Validation (APPRVL) errors with: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. ORA-20001: APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax <- with parameters ( P_Invoice_Id = X P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-) while performing the following operation: Step 6: Get tax distributions for insert Program exited with status 1 Or Invoice Validation (APPRVL) errors with : APP-SQLAP-10000: ORA-6502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-Line_Sum_Control_Button2.Distributions with parameters ( P_Invoice_Id = X P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-Line_Sum_Control_Button2.Distributions) while performing the following operation: Step 6: Get tax distributions for insert	Bug 7016751 APAC:PEN:R12: APXINWKB - TAX DISTRIBUTION GIVES ERROR Bug 7129328 - ADS12.0.4 :FIN: ETAX: INVOICE VALIDATION FAILING FOR GST which had base Bug 7201627 - R12 RUP3 INVOICE VALIDATION FAILED DUE TO ETAX DIST ERROR ORA-06502 . Bug 7131530 - CA EXPENSE REPORTS INVOICE VALIDATION PROCESS FINISH WITH ERROR - which had base Bug 7136704 All these were fixed by upgrading as follows: apsatdreg.ldt version 120.5.12000000.2 apsinreg.ldt version 120.26.12000000.6 apsatd.odf version 120.5.12000000.2 apsin.odf version 120.46.12000000.8 apetxutb.pls version120.66.12000000.32	For R12.0.x: Patch 7201627:R12.AP.A - R12 RUP3 INVOICE VALIDATION FAILED DUE TO ETAX DIST ERROR ORA-06502 to deliver apsatdreg.ldt version 120.5.12000000.2 apsinreg.ldt version 120.26.12000000.6 apsatd.odf version 120.5.12000000.2 apsin.odf version 120.46.12000000.8 apetxutb.pls version120.66.12000000.32	Note 742514.1
7	Unable to validate an invoice due to the following error: APP-SQLAP-10000: ORA-01400: cannot insert NULL into (""ZX"".""ZX_ERRORS_GT"".""TRX_ID"") ORA-06510: PL/SQL: unhandled user-defined exception occurred in AP_ETAX_SERVICES_PKG.Calculate<-AP_ETAX_PKG.Calling_eTax <-AP_APPROVAL_PKG.Approval<-APXINWKB with parameters ( P_Invoice_Id = X P_Calling_Mode =CALCULATE P_Error_Code = P_Calling_Sequence = AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval <-APXINWKB) while performing the following operation: Call calculate_tax service or APP-SQLAP-10000: ORA-01400 cannot insert NULL into ZX.ZX_ERRORS_GT.TRX_ID Error can also occur when Calculating Tax or when entering Tax Details on a new AP Invoice or when cancelling an invoice.	Bug 7452878 - R12:7335614/7391041:CAN'T CALC TAX ON INV NEEDS RE-VALAFTUP Bug 9362839 - ERROR ON AP INVOICE VALIDATION In both of these, the error was related to the fact that a location for the organization is not a mandatory field during setup but location_id is a required parameter that needs to be passed to the package and hence the error is raised.	Oracle Payables > Setup > Organizations (PERWSDOR) Query the organization Populate a location using the LOV Save	Note 810813.1 - if the error persists apply validation patch(es) to deliver better error messages.
8	Unable to validate invoice where the item line has a withholding tax group due to: APP-SQLAP-10000: ORA-01403: no data found occurred in with parameters (Term id = Sequence num = 1) while performing the following operation: &DEBUG_INFO the following error occurs. System is set to create withholding tax invoices at validation. FND Debug log contains the following:- AP_CREATE_PAY_SCHEDS_PKG.Calc_Due_Date Invoice Type is AWT Terms type is Slab AP_CREATE_PAY_SCHEDS_PKG.Calc_Due_Date(+) Check if p_calendar is null p_calendar is There is no calendar associated with the term line	This error is caused because when the invoice is validated the system tries to create the automatic withholding invoice yet there is no Payment Term associated with the Supplier (Tax Authority) site. Since the invoice could not be created without this, the validation fails.	1. Navigate to Supplier form Payables > Suppliers > Entry 2. Query the Supplier/Tax Authority linked to the withholding group on the problematic invoice Click Update Select the Key Payment Setup tab 3. Scroll to the Payment terms section and add a Payment Term to the Tax Authority for that Vendor Site. 4. Retest the issue	Note 1140213.1
9	Unable to validate an invoice due to the following error: APP-SQLAP-10000 ORA-01403 no data found occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval <-APXINWKB With parameters(P_invoice_id = X P_Error_code = P_calling_sequence = AP_ETAX_SERVICES_PKG.Update_AP <-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax <- AP_APPROVAL_PKG.approval <-APXINWKB) while performing the following operation: PO: Setting non-rec tax account same as its parent An alternative error stack has been seen: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval <-APXINWKB With parameters(P_invoice_id = X P_Error_code = P_calling_sequence = AP_ETAX_SERVICES_PKG.Update_AP <-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax <- AP_APPROVAL_PKG.approval <-APXINWKB) while performing the following operation: Tax distributions to insert: 2 Appears to occur where the original distributions and reversals are created at the same time.	System is trying to insert both the original and reversal distributions at the same time. The reversal distributions are getting picked up first and the application looks for the ccid on the original distribution which isn't there as it hasn't yet been created yet which causes the error to occur. This was reported as BUG 9666759 - RCA : NO DATA FOUND ERROR IN TAX WHEN VALIDATING INVOICE and was fixed with For R12.0.x- patch/115/sql apetxutb.pls 120.66.12000000.88 For R12.1.x- patch/115/sql apetxutb.pls 120.102.12010000.49	For R12.0.x- Patch 9666759:R12.AP.A - RCA : NO DATA FOUND ERROR IN TAX WHEN VALIDATING INVOICE to deliver apetxutb.pls version 120.66.12000000.88 For R12.1.x- Patch 9666759:R12.AP.B - RCA : NO DATA FOUND ERROR IN TAX WHEN VALIDATING INVOICE to deliver apetxutb.pls version 120.102.12010000.49	Note 1109723.1
10	Unable to validate or cancel an invoice due to the following error: APP-SQLAP-10000: User Defined Exception occurred in AP_APPROVAL_MATCHED_PKG.Execute_Matched_Checks <-AP_APPROVAL_PKG.Approval <-AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE <-APXINWKB with parameters (Invoice_id=X, Dist_line_num=, Packet_id=,Fundscheck mode=,Partial_reserv_flag=,Max QTY REC Tol =) while performing the following operation: Get receipt quantities for X	The item UOM conversion has been end dated and leading to the issue. This issue has been fixed by re-activating the item UOM conversion. This is explained in Bug 8796739 UNABLE TO CANCEL THE INVOICE, DUE TO APP-SQLAP-10000:USER DEFINED	1. Navigate to Inventory responsibility and ensure that UOM is active. 2. Retest the issue.	Note 1120433.1
11	When attempting to validate an invoice, the following error occurs. APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in AP_WITHHOLDING_PKG.Create_AWT_distributions <-AP_WITHHOLDING_PKG.AP_DO_Withholding with parameters ( Invoice_id = X , Calling Module = AUTOAPPROVAL, Create dists = APPROVAL, Payment Num = , Currency code = X) while performing the following operation: Insert INTO ap_invoice_lines_all	This error was discussed on Bug 9379567: INVOICE VALIDATION ERROR -APP-SQLAP-10000: ORA-06502 IN AP_WITHHOLDING_PKG and Bug 8647373: R12.E.QA.WHTER.ERROR DISPLAY ON CALCULATING WITHHOLDING TAX AT TIME OF PAYMENT and was fixed in apdoawtb.pls version 120.30.12000000.24 and higher.	For R12.0.x: Patch 11720134 - R12.AP.AUNABLE TO COMPLETE FORMAT PAYMENT INSTRUCTION ERROR: ORA-01422 to deliver apdoawtb.pls version 120.30.12000000.47	Note 1065022.1
12	Unable to validate or account invoices where invoice lines have been discarded due to the following error: APP-SQLAP-10000: ORA-0000 normal successful completion occurred in AP_INVOICE_PKG.UPDATE_ROW <-APXINWKB with parameter invoice_id = X) while performing following operation: after calling AP_ETAX_SERVICES_PKG.synchronize_for_doc_seq() Occurs if the discarded item lines have never had tax calculated. If the user validates or calculates tax prior to discarding then the error no longer occurs. Debug log shows additional errors: ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-) x_return_status: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(-) ORA-1403: no data found RETURN_STATUS = U ZX_API_PUB: VALIDATE_DOCUMENT_FOR_TAX: ZX_VALID_INIT_PARAMS_PKG.validate_document_for_tax returned errors Error also occurs if user tries to reverse the invoice line	Invoices with discarded item lines, for which tax has never been calculated, errored out during validation. This was reported in Bug 8519184 TAX CALCULATION ERROR MESSAGE OCCURING DURING INVOICE VALIDATION and was fixed in the following file versions: For R12.0.x: zxmigtrxflyapb.pls version 120.19.12000000.11 For R12.1.x: zxmigtrxflyapb.pls version 120.23.12010000.4	For R12.0.x: Patch 9370802:R12.ZX.A - OFFSET_TAX_RATE_CODE IS INCORRECTLY UPGRADED AS NULL ALWAYS to deliver zxmigtrxflyapb.pls version 120.19.12000000.15 For R12.1.x: Patch 9947835:R12.ZX.B - TRX_LINE_DIST_ID IS INCORRECTLY UPGRADED FOR TAX ONLY LINE DISTRIBUTIONS to deliver zxmigtrxflyapb.pls version 120.23.12010000.10	Note 949058.1
13	Unable to validate invoice that was matched to PO, discarded and rematched and then had the defaulted tax rate changed. The invoice is placed on a Dist Variance hold and even after correcting the variance the following error is seen when the invoice is re-validated: APP-SQLAP-10000: ORA-1403: no data found occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions <-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-AP_ETAX_SERVICES_PKG.Override_Tax <-AP_ETAX_PKG.Calling_eTax<-APXINWKB-> apxinwkb_etax_utils.override_tax_lines_dists with parameters ( P_Invoice_Id = X P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval <-APXINWKB) while performing the following operation: Insert REC/NONREC distributions.	There was a problem in the tax code that meant if a user matched an invoice then discarded the line and rematched to the same PO this time changing the tax rate, validation would fail with the above error. This was reported as Bug 6687031 R12:CHANGE TAX RATE IN INVOICE WILL CAUSE INVOICE VALIDATION ERROR and was fixed with apetxutb.pls version 120.66.12000000.16 and higher.	For R12.0.x: Patch 8481532:R12.AP.A - R12 NEGATIVE NONREC-TAX DISTRIBUTION CREATED AFTER DISCARD A MATCHED LINE to deliver apetxutb.pls version 120.66.12000000.61	Note 473375.1
14	Receiving the following error when trying to perform online validation of a payables invoice due to the following error in the Invoice Workbench: APP-SQLAP-10000: User Defined Exception occured in Error from trigger JAI_AP_IDA_BRIUD_T1 with parameters (&PARAMETERS) while performing the following operation: Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 Error on ap_invoice_distributions_all: ORA-06508: PL/SQL: Could not find program unit being called.	A similar issue is described in Bug 8686147 - Not Able To Compile JAI_AP_TDS_GENERATION_PKG and Bug 8647857 - INVALID OBJECTS FOUND BY AUTOBUILD. The problem was that as part of bug 8234569 a new parameter P_TRANSACTION_NUM was introduced in the function ap_approval_pkg.batch_approval by base payables. Code in India Localization package JAI_AP_TDS_GENERATION_PKG calls this function to approve TDS invoices generated in the system. Due to the mismatch of parameters the compilation is failing. This was resolved by upgrading the following files: For R12.0.x: apaprvlb.pls version 120.94.12000000.89 apaprvls.pls version 120.12.12000000.12 For R12.1.x: apaprvlb.pls version 120.140.12010000.50 apaprvls.pls version 120.16.12010000.8	For R12.0.x: Patch 10052153:R12.AP.A - LINE ITEM ALLOCATION WINDOW SHOW NO ROWS RETURNED WHEN ALLOCATION WINDOW IS USED to deliver apaprvlb.pls version 120.94.12000000.126 apaprvls.pls version 120.12.12000000.13 For R12.1.x: Patch 10052153:R12.AP.B - LINE ITEM ALLOCATION WINDOW SHOW NO ROWS RETURNED WHEN ALLOCATION WINDOW IS USED to deliver apaprvlb.pls version 120.140.12010000.88 apaprvls.pls version 120.16.12010000.10	Note 867727.1
15	Unable to validate invoice due to the following error: APP-SQLAP-10000: ORA-01400: cannot insert NULL into (""AP"".""AP_PAYMENT_HISTORY_ALL"".""PMT_CURRENCY_CODE"") occurred in AP_RECONCILIATION_PKG.insert_payment_history <-AP_APPROVAL_PKG.Generate_Account_Event<-AP_APPROVAL_PKG.Approval <-APXINWKB -> AP_ACCOUNTING_EVENTS_PKG.CREATE_EVENTS -> AP_ACCOUNTING_EVENTS_PKG.DERIVE_INVOICE_EVENTS -> AP_ACCOUNTING_EVENTS_PKG.DERIVE_CASCADE_EVENTS with parameters (X_check_id = X ......) while performing the following operation: Inserting into AP_Payment_History	There was a problem in the Invoice Validation code when trying to a Insert Payment Maturity Adjustments event because AP_RECONCILIATION_PKG.insert_payment_history was not fetching the currency code. This is explained in BUG 10114700 - RCA:ERROR WHILE INSERTING MATURITY ADJUSTED EVENT IN PAYMENT HISTORY TABLE and was fixed with the following file versions: For R12.0.x: apeventb.pls version 120.45.12000000.64 For R12.1.x: apeventb.pls version 120.54.12010000.46	For R12.0.x: Patch 11721100:R12.AP.A - R12: 95359 ERROR WHEN ACCOUNTING FOR VOID 11I INV AND INTEREST PYM to deliver apeventb.pls version 120.45.12000000.72 For R12.1.x: Patch 11777929:R12.AP.B - 1OFF:11721100:12.1.2:12.1.2:R12: POST-11681786 ACCOUNTING FAILING FOR PAY CANCEL to deliver apeventb.pls version 120.54.12010000.54	Note 1235013.1
16	Unable to validate foreign currency invoice with a manual withholding line when Amount and Exchange Rate together have more than 37 characters due to error: APP-SQLAP-10000: ORA-0000: normal, successful completion occurred in AP_APPROVAL_PKG.Execute_Dist_Generation_Check	Invoice Validation was ending in error for foreign currency invoices if Manual Withholding is used and Amount and Exchange Rate together exceeded 37 characters. This was reported in Bug 9880548 - CAN NOT ENTER MANUAL WITHHOLDING TAX LINE which had unpublished base Bug 8725625 - INVOICE WITH MANUAL WITHHOLDING TAX NOT GETTING VALIDATED. This was fixed with the following file versions: For R12.0.x: apiindib.pls version 120.59.12000000.23 For R12.1.x: apiindib.pls version 120.68.12010000.16	For R12.0.x: Patch 10353554:R12.AP.A - LOGGED THIS BUG TO CREATE REPLACEMENT FOR PATCH 10140354 to deliver apiindib.pls version 120.59.12000000.47 For R12.1.x: Patch 10241241:R12.AP.B - STAT AMOUNT NOT POPULATED IN DISTRIBUTIONS EVEN IT IS PRESENT IN LINES to deliver apiindib.pls version 120.68.12010000.41	Note 1148502.1
17	Unable to validate invoices using the concurrent request APPRVL due to the following error: APP-SQLAP-10000: Summary Tax Line Deleted by EBTax. This would cause orphan distributions Occurs if the invoice selection criteria selects invoices where tax will be calculated.	The validation code was not handing the situation when some invoices had exceptions and the validation program errored and did not continue to process the non-problematic invoices. This was reported in Bug 9395593 - VALIDATION PROGRAM ERROR OUR FOR APP-SQLAP-10000: SUMMARY TAX LINE DELETED and was fixed in the following file versions: For R12.0.x: apetxutb.pls version 120.66.12000000.79 or higher For R12.1.x: apetxutb.pls version 120.102.12010000.40 or higher	For R12.0.x: Patch 10350068:R12.AP.A - NULL BASE AMT ON TAX DISTRIBUTION OF FOREIGN CURRENCY INVOICE WHEN XRATE IS LOW to deliver apetxutb.pls to version 120.66.12000000.100 For R12.1.x: Patch 10350068:R12.AP.B - NULL BASE AMT ON TAX DISTRIBUTION OF FOREIGN CURRENCY INVOICE WHEN XRATE IS LOW to deliver apetxutb.pls version 120.102.12010000.61	Note 1093025.1
18	Unable to validate invoice due to the following error: ORA-20001: APP-SQLAP-10000: Frozen Tax Distribution Deleted by EBTax. This would cause orphan events occurred in AP_ETAX_UTILITY_PKG.Return_Tax_Distributions<-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXINWKB with parameters ( P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute <-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXINWKB) while performing the following operation: Summary Tax Line ID for this Dist:X	Tax Distributions missing in ZX tables, but present in AP tables as orphan tax distributions More information can be found in Bug 9503738, Bug 10029190 and Bug 10125294	Code Fix: For R12.0.x: Patch 8736358:R12.ZX.A, Patch 9436262:R12.ZX.A, Patch 9979377:R12.ZX.A For R12.1.x: Patch 8877828:R12.ZX.B, Patch 9436262:R12.ZX.B, Patch 9979377:R12.ZX.B Data Fix: For R12.0.x: Patch 10029190:R12.ZX.A - GENERIC DATA-FIX : FROZEN TAX DISTRIBUTIONS DELETED BY EBTAX For R12.1.x: Patch 10029190:R12.ZX.B - GENERIC DATA-FIX : FROZEN TAX DISTRIBUTIONS DELETED BY EBTAX	Note 1275449.1 Note 1152029.1contains the GDF instructions
19	Unable to validate and invoice with multiple lines/multiple distributions due to the following error: REP-69: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. ORA-20001: APP-SQLAP-10000: ORA-1422: exact fetch returns more than requested number of rows occurred in with parameters ( P_Invoice_Id = 12660 P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-) while performing the following operation: Step 7: Update Invoice Includes Prepay Flag The problem occurs for inclusive tax. On line validation shows the same error.	Invoice with automatic tax is not getting validated and inclusive tax amount not getting subtracted from item distribution. This was logged as Bug 6653070: R12: APXINWKB - ITEM LINE WITH MULTI DISTRIBUTIONS - INVOICE VALIDATION ERROR and was fixed in the following file versions: apetxsrb.pls-120.81.12000000.20 apetxutb.pls-120.66.12000000.12 apaprvlb.pls-120.94.12000000.13	For R12.0.x: Patch 6663869:R12.AP.A - AP_RETRO_PRICING_PKG GETS INVALIDATED BY APPLICATION OF PATCH 6509776 OR ABOVE to deliver apetxsrb.pls-120.81.12000000.20 apetxutb.pls-120.66.12000000.12 apaprvlb.pls-120.94.12000000.13	Note 473363.1
20	Invoice Validation concurrent program Completed with error. REP-1419: 'beforereport': PL/SQL program aborted. REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00101: Error occured in BATCH_APPROVAL() MSG-00102: Error Code : -20001 MSG-00103: Error Message : ORA-20001: ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.AP_APPROVAL_PKG", line 8974 MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_FUNDS_CONTROL_PKG.Calc_QV<-AP_APPROVAL_MATCHED_PKG.Exec_Qty_Variance_Check <-AP_APPROVAL_PKG.Approval<-APXAPRVL with parameters (Invoice_id = X, Po_dist_id = X, Inv_currency_code = X, Po_price = X, Po_qty = X) while performing the following operation: CALC_QV - find dist line with max qty for positive qty_variance	Invoice validation was erroring out with ORA-01403 NO DATA IN AP_FUNDS_CONTROL_PKG.CALC_QV where system tries to calculate the quantity variance, but there is no unapproved distribution left to stamp the new calculated variance. This is discussed in Bug 9564576 - RCA: GSIAP:INV VALIDATION ERR: ORA-01403 NO DATA IN AP_FUNDS_CONTROL_PKG.CALC_QV and was fixed with the following file versions: For R12.0.x: aprmtchb.pls version 120.42.12000000.40 or higher. For R12.1.x: aprmtchb.pls version 120.43.12010000.30 or higher	For R12.0.x: Patch 11067286:R12.AP.A - WRONG INVOICE PRICE VARIANCE (IPV) TRANSFER TO INVENTORY to deliver aprmtchb.pls version  120.42.12000000.42 For R12.1.x: Patch 10327622:R12.AP.B - Final Matching hold placed on an invoice even no Finally Matched invoices exists and PO finally closed from PO to deliver aprmtchb.pls version 120.43.12010000.31	Note 1160865.1
21	Invoice Validation program when scheduled completes with warning and shows the following error in the log: Error: ORA-20001: APP-SQLAP-10000: ORA-1403: no data found occurred in AP_APPROVAL_PKG.Approval_Init<-AP_APPROVAL_PKG.Approval <-APXAPRVL with parameters (&PARAMETERS) while performing the following operation: Retrieving tolerances for validation When submitted through SRS window with same parameters, it completes normal.	Bug 8420964: R12 SCHEDULED INVOICE VALIDATION COMPLETING WITH WARNING and was fixed with the following file versions: For R12.0.x: apaprvlb.pls version 120.94.12000000.84 and higher.	For R12.0.x: Patch 10052153:R12.AP.A - LINE ITEM ALLOCATION WINDOW SHOW NO ROWS RETURNED WHEN ALLOCATION WINDOW IS USED to deliver apaprvlb.pls version 120.94.12000000.126	Note 838382.1
22	While trying to validate an invoice which has some tax applicable on it and which has the voucher_number field populated,system throws the error: APP-SQLAP-10000: ORA-1722: invalid number occurred in AP_ETAX_SERVICES_PKG.Populate_Headers_GT<-AP_ETAX_SERVICES_PKG.Calculate <-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXINWKB with parameters ( P_Invoice_Header_Rec = X P_Calling_Mode =CALCULATE P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Calculate<-AP_ETAX_PKG.Calling_eTax <-AP_APPROVAL_PKG.Approval<-APXINWKB) while performing the following operation: Step 9: Populate zx_trx_headers_gt	his was logged as Bug 6656894: APPRVL - INVOICE VALIDATION FAILS WITH APP-SQLAP-10000: ORA-01722 and was fixed through Bug 6666809: APPRVL - INVOICE VALIDATION FAILS WITH APP-SQLAP-10000: ORA-01722 in the following file versions: For R12.0.x: apetxsrb.pls version 120.81.12000000.21 or higher.	For R12.0.x: Patch 10353554:R12.AP.A - LOGGED THIS BUG TO CREATE REPLACEMENT FOR PATCH 10140354 to deliver apetxsrb.pls version 120.81.12000000.131	Note 472414.1
23	Online Invoice Validation works, however, when attempting to run Invoice Validation as a concurrent request the following error occurs: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1419: MSG-00000: When Others:User-Defined Exception REP-1419: 'beforereport': PL/SQL program aborted. ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in AP_ETAX_SERVICES_PKG.Cache_Line_Defaults<-AP_ETAX_SERVICES_PKG.Calculate <-AP_ETAX_PKG.Calling_eTax<-with parameters (&PARAMETERS) while performing the following operation: Cache Supplier Site Attributes	The invoice that is failing does not have any Supplier Site entered.  This condition was caused by Bug 7140346: IN R12 IT IS POSSIBLE TO SAVE AN INVOICE WITHOUT THE SUPPLIER SITE which was fixed with the following version: For R12.0.x: APXINWKB.fmb version 120.496.12000000.164 or higher.	Update the invoice causing validation to fail, and add a supplier site. To prevent future occurances, for R12.0.x: Apply Patch 7140346 - IN R12 IT IS POSSIBLE TO SAVE AN INVOICE WITHOUT THE SUPPLIER SITE to deliver APXINWKB.fmb version 120.496.12000000.164	Note 601624.1
24	Unable to validate an invoice due to: APP-SQLAP-10000: ORA-6508: PL/SQL: could not find program unit being called occurred in AP_FUNDS_CONTROL_PKG.Funds_Reserve<- AP_APPROVAL_PKG.Approval <-APXINWKB with parameters (invoice_id = 15374 &PARAMETERS) while performing the following operation: &DEBUG_INFO FND DEBUG LOG Shows: ORA-04063: package body ""APPS.PSA_AP_BC_PVT"" has errors ORA-06508: PL/SQL: could not find program unit being called: ""APPS.PSA_AP_BC_PVT"" ORA-20001: APP-SQLAP-10000: ORA-06508: PL/SQL: could not find program unit being called occurred in AP_FUNDS_CONTROL_PKG.Funds_Reserve<-AP_APPROVAL_PKG.Approval<-APXINWKB with parameters (Invoice_id = xxx Set of books id = xxx System user = xxx) while performing the following operation: &DEBUG_INFO	There were compilation errors on package body PSA_AP_BC_PVT - psavapbs.pls	Apply Patch 12359561:R12.PSA.B: Critical Bug fixes for Public Sector Customer to deliver psavapbb.pls version 120.49.12010000.28	Note 1326884.1