Home » Applications » Oracle Fusion Apps & E-Business Suite » Customer conversion  () 1 Vote
icon5.gif  Customer conversion [message #431040] Fri, 13 November 2009 13:59 Go to next message
oraclefaqs1
Messages: 23
Registered: October 2008
Location: SC
Junior Member

hi all,

I got 2 questions:

1. I am populating the STANDARD_TERM_NAME in RA_CUSTOMER_PROFILES_INT_ALL but unable to get that on front end after running the CUSTOMER INTERFACE (though interface runs without any errors)

I even tried with keeping the OVER_RIDE_TERMS flaf to 'Y'

can u please help me

2. I have some customers with foreign (CANADA) bill to address (canadian ZIP codes are like this 'VXN 1433') and US ship to address, so when I am entering the ship to record of that particular customer referencing BILL_TO_ORIG_ADDRESS_REF to foreign (CANADA) address it is erroring out saying:

The Postal Code is not in the defined range of system option

how do I solve this ??

than
ks,[/i]
pu[/i]rna[/i][/size]
Re: Customer conversion [message #431324 is a reply to message #431040] Mon, 16 November 2009 17:36 Go to previous messageGo to next message
oraclefaqs1
Messages: 23
Registered: October 2008
Location: SC
Junior Member

guys I need help...I am stuck
Re: Customer conversion [message #431325 is a reply to message #431324] Mon, 16 November 2009 17:37 Go to previous messageGo to next message
oraclefaqs1
Messages: 23
Registered: October 2008
Location: SC
Junior Member

2nd part got solved, but I cudn't find any solution for the 1st question.

and 1 more what's wrong with this part of coding, it's erroring out in where clause saying invalid identifier
DECLARE
   CURSOR cur_bill_customers
   IS
      SELECT *
        FROM apps.xxar_c110_custstg c110
       WHERE NVL (status, 'N') = 'N'
         AND site_use_code = 'BILL_TO';
BEGIN
   FOR cur_bill_customers_rec IN cur_bill_customers
   LOOP
      BEGIN
         UPDATE apps.xxar_c110_custstg
            SET orig_system_customer_ref =
                     'CUST' || cur_bill_customers_rec.orig_system_customer_ref,
                orig_system_address_ref =
                      'CUST'
                   || cur_bill_customers_rec.orig_system_customer_ref
                   || '_'
                   || 'ADRR'
                   || cur_bill_customers_rec.orig_system_address_ref
         WHERE  customer_number =
                               cur_bill_customers_rec.orig_system_customer_ref
            AND site_use_code = 'BILL_TO';
      END;
   END LOOP;
END;
/


[EDITED by LF: removed commented lines, reformatted code, applied [code] tags]

[Updated on: Tue, 17 November 2009 01:32] by Moderator

Report message to a moderator

Re: Customer conversion [message #431356 is a reply to message #431325] Tue, 17 November 2009 01:35 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Invalid identifier" means that you have used a column name that doesn't exist in a table.

Perhaps it would be a good idea NOT to "select *" from a table (see cursor declaration), but "select column1, column2, ..." instead.

As we don't know your tables (though, people who know Oracle Apps. might be familiar with them - I'm not) and column list is unknown, I really wouldn't know how to help but suggest to check table and column names once again.
Re: Customer conversion [message #432652 is a reply to message #431356] Wed, 25 November 2009 08:31 Go to previous message
oraclefaqs1
Messages: 23
Registered: October 2008
Location: SC
Junior Member

Thanks littlefoot.

That's not the issue, I had to use FOR UPDATE....WHERE CURRENT OF;
syntax. And problem solved

cheers..
Previous Topic: Is XML Publisher causing shared memory problem..?
Next Topic: question in sales order in order management
Goto Forum:
  


Current Time: Tue Dec 06 12:25:12 CST 2016

Total time taken to generate the page: 0.09823 seconds