1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need Help in PA

Discussion in 'Oracle Apps Technical' started by jagadekara, May 30, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Buddies,

    In PA module I have one project number which consists 9 draft invoices and 7 draft revenues.
    So my requirement is to find out which revenue is against which invoice?

    Some times 6 draft invoices and 8 draft revenues also... So how can I recognize which revenue is against which invoice?
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I find one table pa_cust_rev_dist_lines_all which have project_id and draft_invoice_num and draft_revenue_num.

    So I joined with this table for draft invoices and draft revenues. But for some project numbers it is fine. But some project numbers it is not coming.

    Any Ideas?