How to extend customer address
I’m working for a customer that wants to extend customer address information adding several new fields.
Customer is using Oracle Financials 11.5.10 cu2.
Using documentation and white-papers I’ve found several ways to extend customer addresses:
- using TCA location extensible attributes
- using standard “Remit Address HZ” DFF
- using standard “HZ_PARTY_SITES” DFF
Unfortunately I’m facing these showstoppers:
- because of note 1123964.1 (How To Use Location Extensible Attributes(Location Profile) In Customers Online?) the extended fields declared in TCA are not available on OCO
- because of note 1381336.1 (Error: When attempting to extend address flexfields - APP-FND-01024) the attribute columns of HZ_LOCATIONS are not useable for DFF