- OracleApps Epicenter - http://www.oracleappshub.com -

Dealing with “Addressee” on Customer Master

Take a note ,when you are dealing with Health care or Telecom client,there is specific requirement for maintaining addressee field, which can be used for one of the attribute for billing purpose. Though this is not a correct Field in AR context , but still you can use to cater customer need. Products like SAP have this feature in Customer Master.

So what will you do , if you are dealing with customer Migration.

Dealing in Migration - Couple of options

  1. Use TCA API's - this will take care of most of field that you can see in customer master screen.
  2. Use of Customer Import - The Field is not getting populated by interface table cum import program.
  3. Use Customer import + TCA API's to update customer site : This you can achieve.

Option 3 is bit realistic and safer if you are dealing with thousands of customer Migration.

The Field called "Addressee" on Customer Address Form

Addressee field is potentially used to assist with the interface with iStore. Receivable in real sense does not have any significance unless you are customizing your statement of account(SOA) or sales invoice format.

How it works

Addressee is used when an order is made by a customer and is shipped somewhere else.

It is just like you purchase a book and have it shipped to your friend . Your friend becomes the addressee at the address that the book is sent to.

Therefore you can use ADDRESSEE column to store an alternative displayed name which can be used in place of the party name on mailing labels or other external documents.

The usage of this column may vary in different applications within Oracle EBS.

Oracle Shipping

Oracle Shipping will display the column on mailing label for ship to customer when the customer account owning party is a party of party type PERSON.

Oracle OM

Order Management may display the column in a sales order along with the customer name (from party name), ship to org name (from customer site use simplifying the process of creating the on-time ship to address.

Oracle CRM Product

CRM iStore will use the column to display the person name in a personal address book since CRM consider that it is a huge overhead to create a party record for each person in a personal address book.

Technical walk through

TCA table HZ_PARTY_SITES parking the column data in ADDRESSEE field.

Customer Import - don't care about this field

Here is update on this field, if you are using 11i.

API for Customers master to update Addressess

So if you are coming from SAP or Sun or SAGE, you can achieve with combination of these process as mention in option 3.

 

Step1 : Create Customer through Customer Import

What you can see addressee field is blank.

use this query to get your party_site_id for which you are updating the record.

select distinct a.party_id,
a.orig_system_reference,
b.customer_name,
a.account_name,
d.party_site_id
,d.object_version_number
,d.addressee
from hz_cust_accounts a ,
ra_customers b ,
hz_party_sites d
where a.orig_system_reference=b.orig_system_reference
and d.party_id=a.party_id
and a.account_name ='PESC'
---and trim(b.customer_name) =trim('PHILIPS ELECTRONICS SINGAPORE')

Step 2 : Call the API to update Addressee field

Your API selection details should be as:

Package :HZ_PARTY_SITE_V2PUB
Procedure :UPDATE_PARTY_SITE
Table Affected :
HZ_PARTY_SITE

DECLARE
p_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
p_object_version_number NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);

CURSOR C_ADDRESSES IS
select distinct a.party_id,
a.orig_system_reference,
b.customer_name,
a.account_name,
d.party_site_id
,d.object_version_number
,d.addressee
from hz_cust_accounts a ,
ra_customers b ,
hz_party_sites d
where a.orig_system_reference=b.orig_system_reference
and d.party_id=a.party_id
-- and a.account_name ='PESC'
and trim(b.customer_name) =trim('PHILIPS ELECTRONICS SINGAPORE') ;

BEGIN

FOR addresses_rec in C_ADDRESSES

Loop

fnd_client_info.set_org_context(1066); replace with your org_id if you are in 11i

p_party_site_rec.party_site_id := addresses_rec.party_site_id;
p_object_version_number := addresses_rec.object_version_number;
p_party_site_rec.addressee := 'Kind Attn:' || 'Mr XYZ';
p_party_site_rec.created_by_module := 'POST MIGRATION UPDATE';

hz_party_site_v2pub.update_party_site
(
'T',
p_party_site_rec,
p_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);

dbms_output.put_line('Return_status = '||SUBSTR(x_return_status,1,255));
dbms_output.put_line('Msg_count = '||TO_CHAR(x_msg_count));
dbms_output.put_line('Msg_data = '||SUBSTR(x_msg_data,1,255));

IF x_msg_count >1 THEN
FOR I IN 1..x_msg_count LOOP
dbms_output.put_line(I||'.'||SUBSTR(FND_MSG_PUB.Get(p_encoded=> FND_API.G_FALSE), 1, 255));
END LOOP;
END IF;
END LOOP;
COMMIT;
END;

( This is test script , you can fine tune to acheive your desired result)

Step 3 : Confirm from Oracle Customer Master Screen

Similar Post

1 Comment (Open | Close)

1 Comment To "Dealing with “Addressee” on Customer Master"

#1 Pingback By Customer Interface Vs TCA API | OracleApps Epicenter On October 28, 2008 @ 12:19 am

[…] Interface Vs TCA APITCA Customer setup in Oracle EBSTrading Community Architecture (TCA) 101Dealing with “Addressee” on Customer MasterR12 Supplier Bank – Techno Functional GuideA note on sub ledger reconciliation reports during period […]