Oracle ERP standard address string method

 

Oracle ERP standard address string method

 

1. Set ou

1. from the menu edit-> preferences-> profiles, you can use MO: operating unit to query ou (assuming the value is vision operations) 2. you can use the following SQL statement to query the corresponding ou ID.

SELECT ORGANIZATION_ID
  FROM HR_OPERATING_UNITS
 WHERE NAME = 'Vision Operations';

3. If the resulting ou ID is 204, use the following PL/SQL statements to set the client environment variable:

BEGIN
  DBMS_APPLICATION_INFO.SET_CLIENT_INFO(204);
END;

Ii. Standard address SQL

Select arp_addr_pkg.format_address (RA. address_style,
RA. address1,
RA. address2,
RA. address3,
RA. address4,
RA. City,
RA. County,
RA. State,
RA. Province,
RA. postal_code,
Terr. territory_short_name) concatenated_address
From ra_addresses Ra
, Fnd_territories_vl terr
Where Ra. address_id = p_address_id -- the parameter is the specified address ID.
And Ra. Country = terr. territory_code (+ );