Customer Interface - How to set status of Site_use

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
jscrunch
Posts: 35
Joined: Tue Apr 03, 2007 8:12 am
Location: Spain

Customer Interface - How to set status of Site_use

Post by jscrunch »

Hi friends,
I'm running Customer Interface to import data of AR Clients [11.0.3 to 11.5.10.2].
After executing the request, it appears an error mesage saying:
"For each customer, you may only have one active "Statements" type"
I've checked the customer data:
It has two addresses . The 1st has 2 business purposes: Bill_to and Statement. Both are Inactive and Main check-box NOT checked
The 2nd has both business purposes active (not checked Main check-box).

So the error message does not show the true situation. I think it's because the RA_CUSTOMER_INTERFACE_ALL has no a columns to show the status of the site_code (business purpose) and it tooks the CUSTOMER_STATUS column value (that it's 'A') and that's why I think it shows the error...
Do you know if is there any way to indicate this status? (i.e. via SITE_USE_ATTRIBUTE_1 to 15 columns?)
I've checked the note: 268865.1 but we have already applied the patches (we are on HZ.N) so.. I don't know what more things to try...
Thanks a lot.

Jose
Post Reply

Who is online

Users browsing this forum: No registered users and 25 guests