My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.