Thursday 6 March 2014

Remaining Life of an Asset in Fixed Assets Query

SELECT DECODE
          (books.period_counter_fully_retired,
           NULL, GREATEST
                         (  NVL (books.life_in_months, 0)
                          - TRUNC
                                 (MONTHS_BETWEEN (SYSDATE,
                                                  books.date_placed_in_service
                                                 )
                                 ),
                          0
                         ),
           0
          ) remaining_life_in_months,
       DECODE
          (books.period_counter_fully_retired,
           NULL, TRUNC
              (  GREATEST
                         (  NVL (books.life_in_months, 0)
                          - TRUNC
                                 (MONTHS_BETWEEN (SYSDATE,
                                                  books.date_placed_in_service
                                                 )
                                 ),
                          0
                         )
               / 12
              ),
           0
          ) remaining_life_in_years,
       asset_id
  FROM  fa_books books
  WHERE asset_id=100036-- Pass your assest 

Wednesday 5 March 2014

retrieving the list of values has stopped because it is taking longer than permitted















Go to tools options
         Then Query Governor tab
                     


Change the value 'Cancel Value retrieval after'  from 00.15 seconds to 1.00 and try.




Tuesday 4 March 2014

What are the tables that replaced RA_CUSTOMERS, RA_ADDRESSES_ALL and RA_SITE_USES_ALL ?

The migration of customer data from Oracle Receivables (AR) to the Trading Community Architecture (HZ) is very complex. There isn't a one to one mapping of the old table in AR to a new table in HZ, because the structure of data has completely changed.


Old TableNew Table
RA_CUSTOMERSHZ_PARTIES and HZ_CUST_ACCOUNTS
RA_ADDRESSES_ALLHZ_PARTY_SITES, HZ_LOC_ASSIGNMENTS,
HZ_LOCATIONS and HZ_CUST_ACCT_SITES_ALL
RA_SITE_USES_ALLHZ_CUST_SITE_USES_ALL