| 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 | |
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 | |
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 | |
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. | |
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. | |
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 | |
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 | |
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 | |
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. | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | | | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2013/1/16 14:52:55
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡
楼主
发表于 2013/1/17 11:07:59
