My Oracle Support Banner

hz.parties.Party_Name Currently Saves as Firstname.Lastname. Need the Ability to Populate the Party_NAME (Person) as Last Name, First Name, Middle Name (Doc ID 1930959.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Customers Module

The hz.parties.Party_name currently saves as firstname.Lastname.

If you set the Profile Option:  HZ: Name/Address Backwards Compatability = No, the Parties (that get created after profile change) Party Name will change to "Last Name, First Name Middle Name" format (Which is the desired result).

This does automatically reformat the existing Party Names, as expected.
The Party_NAME is still populated in the wrong format, when Customer of type Person is saved.
The HZ_PARTIES.Party_Name is still showing as Firstname MiddleName LastName.

When a change is made to the the customer name:

Steps to Reproduce:
Responsiblity: System Administrator
Profile > System
Set HZ: Name/Address Backwards Compatability" to "No"

Navigation:  Customers > Customers
Query a Customer with Type of Person
Update customer and Save.
The HZ_PARTIES.Party_Name is saved as Firstname MiddleName LastName.
You need the name to be saved in the format of "Lastname, Firstname MI."




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

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