Microsoft Office 2010 Home And Student Dealing wit
 

ORACLEINSIDER.COM

View my web page on Oracle Community
--> Free of charge Oracle Journal Profit:The Executive's Guide to Oracle Applications -->
Posted on October 21st, 2008 by Sanjit Anand | Print This Post
| Email This Post
Have you joined Hub Local community Network Forums of OracleaApps professionals? Don't wait. Do it today

Take a note ,Office Pro,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
Use TCA API's - this will take care of most of field that you can see in customer master screen.
Use of Customer Import - The Field is not getting populated by interface table cum import program.
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,Microsoft Office Professional Plus,
d.party_site_id
,Office Pro Plus 2010 Key,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,Office Pro Plus 2007 Key,
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 ,Office 2010 Key,
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.Ge t(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
Deep Drive : Customer Interface in AR