1 Reply Latest reply: Feb 19, 2014 4:58 PM by Gene-Oracle RSS

    Migration - Extraction query

    1978851

      Hi,

           I am migrating PA expenditures from one Oracle instance to another (both R12.1.3). Is there any extract code available on PA tables (with joins) that provides data that can then by aggregated/translated and placed into PA_TRANSACTION_INTERFACE_ALL. Looking specifically at Capital projects where expenditure has not previously been capitalised. 

        • 1. Re: Migration - Extraction query
          Gene-Oracle

          Hello

           

          you need to look into PA_EXPENDITURE_ITEMS_ALL for EIs with COST_DISTRIUTED_FLAG=Y and REVENUE_DISTRIBUTED_FLAG=N. Your Ei should also be marked as billable.

          You can try using Capital Data Collection Test, there are queries that show capitalizable cost, you can modify them for your perusal.

           

          Thanks

          Gene