R12 95340 errors when attempting to create accounting for payments [ID 561130.1]

 

 

R12 95340 errors when attempting to create accounting for payments [ID 561130.1]
		修改时间 19-MAY-2008     类型 PROBLEM     状态 PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

---

 

 

Applies to:

Oracle Payables - Version: 12.0.3
This problem can occur on any platform.

Symptoms

When attempting to create accounting for payments the following error occurs:

ERROR
95340 The total debits and the total credits do not balance for this subledger journal entry.
Please ensure that the application accounting definition Accrual Basis owned by Oracle contains
journal line types for the event class Payments and event type Payment Created that can create a
balanced entry. Also verify that any conditions associated with a journal line type are correct.

Cause

The following bugs cause 95340 errors:

Bug 6649025 - R12: UNBALANCED ENTRIES FOR FOREIGN CURRENCY PAYMENTS EVENT AFTER PATCH 6493828
Bug 6708406 - R12 SLA Rounding Errors Out When Prepayment Is Applied
Bug 6686360 - 95340 Error Off By 0.01 to 0.02 For Certain Transactions
Bug 6648094 - Accounting Failing With 95340 Errors Due To Invoices Being 0.01 Off
Bug 6600117 - 95340 Error When Accounting Some Transactions Off By 0.01 With No Round
Bug 6614295 - Acctg Some Transactions Off 0.01 With No Rndg
Bug 6600341 - 95340 Accounting Error When With Large Rounding Line When Accounted Out Of Order
Bug 6621586 - 95340 Error On Clearing Events Due To Rounding
Bug 6718967 - PREPAYMENTS GET 95340 OR ACCOUNT AND REMAIN ON THE TRIAL BALANCE:
Bug 6633653 - R12 FOREIGN CURR PYMTS WITH AWT AT PYMT TIME RESULTS IN UNBALANCED ACCTG ENTRIES:
Bug 6493828 - R12 FOREIGN CURR PYMTS WITH AWT AT PYMT TIME RESULTS IN UNBALANCED ACCTG ENTRIES
Bug 6692420 - R12 UNBALANCED ENTRIES FOR FOREIGN CURRENCY PAYMENTS EVENT AFTER PATCH 6493828:

Solution

The following patches deliver the indicated versions of the files that will help correct 95340 errors:  

 

File	Version
Patch 6901404
apacrndb.pls	120.11.12000000.13
appaydib.pls	120.21.12000000.11
appaydis.pls	120.12.12000000.7
apimportaad.sql	120.1.12000000.1
appostimportaad.sql	120.2.12000000.1
ap_payment_extract_details_v.xdf	120.7.12000000.4
ap_prepayapp_extract_details_v.xdf	120.5.12000000.8
ap_prepayapp_extract_dtls_bc_v.xdf	120.2.12000000.9
SQLAPXLAAAD.ldt	120.55.12000000.22
APXLASET.ldt	120.40.12000000.14
Patch 6878666
apaprvlb.pls	120.94.12000000.36

 

1. Please download and review the readme for the following patches:

Patch 6901404
Patch 6878666

2. Apply the patches to get the current versions of these files.

3. Run the Create Accounting process and verify the 95340 errors are resolved.

4. Log SR with support for any 95340 errors still occurring after patches with the latest code are applied.

References

BUG:6875784 - DATAFIX: CLEARING EVENT WITH ERROR 95340
NOTE:471421.1 - Accounting 95340 Error on Payments - Off By 0.01 or Very Small Amounts

---