Fixed Assets - EBS (MOSC)

MOSC Banner

Asset Drill Down

edited Jul 27, 2019 5:07AM in Fixed Assets - EBS (MOSC) 1 commentAnswered

Dears,

I'm working on Asset Drilldown query from GL batches into invoices in asset source lines,

I've a problem as asset transaction history table "FA_TRANSACTION_HISTORY_TRX_V" is linked with the asset source lines table "FA_INVOICE_DETAILS_V" by "INOVICE_TRANSACTION_ID" which mean that multiple lines in the source lines are linked to one transaction, therefor the cr & dr amount form XLA lines table "XLA_AE_LINES" are duplicated because the XLA transactions are linked with the asset transactions table based on transaction number.

so please advise if there is any way to link each invoice in asset source lines with it's accounting events (cr & dr amount) in SLA.

Tagged:

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