My Oracle Support Banner

EGL: InterUnit ProRata Allocation Creating Multibook Journals That Fail Journal Edits Due To: The Transaction For Ledger XXXXXX Is Not in Sync With The Primary Ledger Transaction. (Doc ID 1564832.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.


Customer Environment
Application Release 9.1,
Bundle level MP10 through bundle 20

PeopleTools 8.51

Upgrading from
Application release 9.0
Bundle 7

Error message
Edit error hard processing error
The transaction for ledger XXXXXX is not in sync with the primary ledger transaction.
- Returned for Business Unit for Translation ledger Base Currency

Replication steps

1. Define Ledger group
  -ACT_LOCAL - primary, inherit base curr
  -ACT_GBP - translation, base curr GBP
  -ACT_USD - translation, base curr USD

2. Establish Business unit
3. Define Ledger for a unit for business unit/ledger group
4. Define Allocation Step that has offset defined to zero original pool data.
5. Define Allocation group
6. Establish Pool data from LEDGER
7. Create Basis data
8. Allocation request
9. Collect Allocation journal before edit
  Some lines only have local and GBP
  Others have only local and USD
  And some have all 3.
  After edit with no "recalc" of exchange rates selected on the edit
  Ends up in error status: The transaction for ledger ACTGBP is not in sync with the primary ledger transaction.
10. If Edit with "recalc" then Goes to valid

Business Impact
Can not post journal because journal gets generated in error related to secondary translation ledgers


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.