Payables and Cash Management - EBS (MOSC)

MOSC Banner

Is it possible to view original data which were updated from backend

edited Nov 10, 2014 1:29PM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered ✓

Respected Experts,


I have an invoice amount 60000.00 prepayment applied 59999.99 (3 prepayments lines in distribution) I DONT KNOW the other 2 prepayment distributions amount except 1 distribution which was -22727.27


When i updated from mentioned update query :


Update AP_INVOICE_DISTRIBUTIONS_ALL

  2         Set amount = -22727.28

  3          where invoice_id in (82303)

  4          and invoice_distribution_id in(503960)

  5          AND LINE_TYPE_LOOKUP_CODE = 'PREPAY'

  6          and org_id = 84;


Updated successfully distribution should be equal to 60000.00 BUT system randomly added extra amount of 9090.91 in distributions (Other 2 prepayment distribution lines)


Now i want to know that how can i view the previous amounts of other 2 prepayments distribution lines amounts

Why system behave like this any idea ?

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