Oracle PA to AP mapping for the adjustments made in PA
Posted: 05 November 2008 08:17 PM
Newbie
Rank
Total Posts:  1
Joined  2008-11-05

Hi,

    I have to find out the data whose Adjustments made in PA which are NOT interfaced to AP.
    These adjustments are Supplier Invoice Costing adjustments made in PA.

Please help me to find the table and column in PA that has to be marked when those data got transferred to AP.

Thanks,
Nishank Jain

Profile
 
Posted: 18 March 2009 02:27 AM   [ # 1 ]
Newbie
Rank
Total Posts:  4
Joined  2007-02-24

Hi Nishank,

You need to look into pa_expenditure_items_all(Ei) and pa_cost_distribution_lines_all tables(Cdl). In Ei table, the system_linkage_function will be ‘VI’ and
in Cdl you need to look for transfer_status_code = ‘A’ which means it has been transferred to AP.

Thanks,
Sathish
http://www.projectsaccounting.com

Profile