How to list account addresses via groovy script? (Doc ID 2052933.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Fusion Sales - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

We want to query and list account's all addresses, so we found the script about achieve it. It is

def t = PartySite
while(t.hasNext())
{
def trow = t.next()
println("Address - " + trow.FormattedAddress)
println("Primary Flag - " + trow.IdentifyingAddressFlag)
println("Country code - " + trow.Country)
println("Country - " + trow.getSelectedListDisplayValues("Country"))
println("Id - " + trow.PartyId)
println("Ids - " + trow. PartySiteId)
}

We listed all addresses by these script. But there is no difference between Sell to addresses and Bill to addresses.

How to differentiate by Address Type?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms