Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Dealing with “Addressee” on Customer Master

Posted on October 21st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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.

dgreybarrow-2 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.

dgreybarrow-2 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.

cUSTOMER ADDRESSES1

dgreybarrow-2How 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.

dgreybarrow-2Oracle 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.

dgreybarrow-2Oracle 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.

dgreybarrow-2Oracle 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.

dgreybarrow-2Technical walk through

TCA table HZ_PARTY_SITES parking the column data in ADDRESSEE field.

dgreybarrow-2Customer Import - don't care about this field

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

customer addresses

dgreybarrow-2API 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.

Customer Import

 

Step1 : Create Customer through Customer Import

addressee1

What you can see addressee field is blank.

CUSTOMER

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

post -CUSTOMER

dgreybarrow-2 Similar Post

Related Posts

Posted in Oracle Receivable | 1 Comment »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. Customer Interface Vs TCA API | OracleApps Epicenter Says:

    […] 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 […]

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.