Fixed Assets - EBS (MOSC)

MOSC Banner

Create accounting Issue

edited Sep 6, 2018 5:03AM in Fixed Assets - EBS (MOSC) 3 commentsAnswered

Hi , 

We have some unprocessed events in create accounting : Eg

1451781013795402DEPRECIATIONUU31-MAY-2018 00:00:00N345202-MAY-2018 23:28:44
1454024013795402ROLLBACK_DEPRECIATIONUI30-APR-2018 00:00:00N345203-MAY-2018 21:25:07

We are currently in Aug- 18 and the query :

  select ev.event_id, ev.event_type_code, ev.event_status_code, ev.process_status_code

from xla_events ev,

xla_transaction_entities et

where ev.application_id = 140

and ev.event_status_code not in ('N', 'Z', 'P')

and ev.process_status_code not in ('P', 'Z')

and et.entity_id = ev.entity_id

and et.valuation_method = 'CN CNY CORP'

order by ev.event_id;

As provided us earlier gives us 18 rows.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center