Deferred Depreciation Accounting Is In Error With The Message : “Invalid Related Entry” / How To Set Up a Journal Line Rule To Generate Or Not Entries In The Secondary Ledger? (Doc ID 1938657.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Assets - Version 11.1.8.0.0 and later
Oracle Fusion Assets Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

Qn1:Deferred depreciation event should be accounted only in secondary ledger.
All journal entries are generated from the FA corporate book.
SLA set up has been done to create journal entries only in secondary ledger and not in Primary. Consequently ‘deferred depreciation’ journal entry rule set has been deleted in primary ledger accounting method and has been kept in secondary ledger accounting method.

When trying to create journal entries in GL for deferred depreciation event in FA, the "create accounting" output show an error message :
'The event type associated with the event is not included in the journal entry rule sets assigned to the accounting method used by the ledgers. Details: A journal entry rule set must be assigned to the Subledger accounting methods for this event type. If you do not want to create accounting for a particular event type, update the accounting method and confirm that no accounting will be created for the event.' for the primary ledger
and 'Invalid related entries' for the secondary ledger.
 
Qn2:What i want to do now is, depending on category key value, to generate or not entries in the secondary ledger (and systematically in primary one).
To do it i enter a condition in my account rule on asset category third segment value, this account rule is assigned in the JERS of the accounting method of the secondary ledger. I don’t modify the account rule used for the primary ledger as I want accounting to be generated in primary whatever the value of the category key is.
You can see in my file’SR SLA Addition’ the detail steps of set up done.
My issue is that now accounting is never done on my secondary ledger whether the condition is met or not.
In the first test case, the asset category doesn’t met the condition => no accounting is done that’s OK.
But in my second case the asset category does met the condition despite that there is still no accounting.

Solution

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 hundreds of Community platforms