General Ledger - EBS (MOSC)

MOSC Banner

XLA_DISTRIBUTION_LINKS when relating PO_DISTRIBUTIONS is driving me nuts cannot match GL against PO

edited Jan 15, 2010 1:33AM in General Ledger - EBS (MOSC) 4 commentsAnswered
 Hello, all users we are reconciling XLA, GL against PO (REQs, POs, RCV), INV and AP.

I did all the work however when I am leveling down XLA thru DISTRIBUTIONS some transactions do not appear.

So I lose trx however the links are there what could be wrong!!! I am going nuts I cannot reconcile PO_DISTRIBUTIONS ...

Query see below:

select

jb.name batch_name,

jh.name header_name,

jh.je_category,

jh.je_source,

decode(jh.actual_flag,'E','Encumbrance','A','Réél','B','Budget') actual_flag, jh.actual_flag,'E','Encumbrance','A','Réél','B','Budget') actual_flag

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