Reply from Chen Chang on Dec 29 at 11:06 AM Swati:
The CUST_ADDRESS table has additional keys (ADDRESS_SEQ_NUM and EFFDT), that said, you should be able to populate multiple addresses on a CI load instance. Without looking at your actual codes, my guess is that your codes can not handle multiple addresses.
For example, the following code can only populate 1 address :
&oCustAddress = &oCustAddressCollection.Item(1);
The 2'nd address and on, you should use something like:
&oCustAddress = &oCustAddressCollection.InsertItem(1);
Notice that the InsertItem rather than Item, sort like you actually click the '+' button on the Grid or Scroll Area at the page.
Hope that helps!
| | | ---------------Original Message---------------
From: swati shah
Sent: Thursday, December 29, 2011 7:33 AM
Subject: Component Interface to Load Values to ps_customer
Hi,
I have created a component interface which is used to load values to ps_customer.
I am able to upload values to the record, but if there are multiple child records then it's not uploading as it give me row already exists .
Format is:
000|custid|custname|shortname|etc...
001|custid|addr1|adr2|city|postal
001|custid|addr3|adr4|city|postal
So If my customer has 2 addresses its not able to upload the data.
It's giving the row exist error as I know Create keys are set id and custid..
So when it gets the same it gives error, but how should it identify the address seq num? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment