You are browsing the archive for ARHGEOUP.

Spatial Information for Locations Batch Update

 

NAME: Spatial Information for Locations Batch Update
SHORT CODE: ARHGEOUP
MODULE: Oracle Accounts Receivables

Description: Update the Geometry column in HZ_LOCATIONS
Navigation: Oracle AR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_loc_type : Location Type
  • p_site_use_type : Site Use to Update Geometry Column for
  • p_country : Update Only Locations in this Country (Leave Blank for All)
  • p_iden_addr_only : Yes or No for Processing Only Identifying Addresses
  • p_incremental : Update Only Locations where the Geometry Column is Empty
  • p_all_partial : Update All Records or a Subset
  • p_nb_row_update : Number of Records in Subset