Which tables refer to primary Partner address in Oracle Sales?

The primary address is stored in HZ_PARTIES table.

If you know the Party_id for your partner, then you can get the address information using the following query:

select l.address1, l.city, l.county, l.state, l.postal_code, l.country, p.party_name, ps.identifying_address_flag from hz_parties p, hz_locations l, hz_party_sites ps where p.party_id = ps.party_id and ps.location_id=l.location_id and p.party_id=&PartyID;

If you know the Registry ID for your partner, then you can get the address information using the following query:

select l.address1, l.city, l.county, l.state, l.postal_code, l.country, p.party_name, ps.identifying_address_flag from hz_parties p, hz_locations l, hz_party_sites pswhere p.party_id = ps.party_id and ps.location_id=l.location_id and p.party_number=&RegistryID;