Component Interface

Updating a row using Peoplecode - Component Interface.

Hi, My client requirement is to insert and update rows from staging record to a transaction records PS_LOCATION_TBL. I am getting issues when a row is already exists in a record and I CI need to update a row.
For example: With Location ID 001 there are two rows in location table with effective dates 01/01/1900 and 01/01/2001. There is a row in a staging record with effdt 01/01/1900 that need to be updated.

Below is a snippet of a code and I am getting issue where I am comparing location collection effective date with the date in a staging record to tell CI only that row need to be updated (If &oLocationTblCollection.EFFDT = &currLocEffdt Then).

If I do not enter above IF statement then I get an error Instance must exist to set property {LOCATION.EFFDT} as it's trying to update 01/01/2001 and it's not in staging record. If I enter If &oLocationTblCollection.EFFDT = &currLocEffdt then I get First operand is .NULL error because collection has not been loaded. But it's important to compare collection effective date with staging effective date to update the row correctly without errors.

Failed to get the Component Interface Error

Hello, we seem to have an issue on the odd occasion with an integration message where it cannot find the keys to update the chartfield value. This process is working correctly for 98% of transactions for a variety of chartfields. This is the error we are getting.

No rows exist for the specified keys. {DEPT_CF} (91,50)
No rows exist in the database with the specified keys.

Invalid value -- press the prompt button or hyperlink for a list of valid values (15,11)

hi all,
am tring to upload data to dept_tbl.

first i have uploaded data into one dept_tmp record through file layout and from that am tring to fill dept_tbl record.
in dept_tmp data is there.
while running the ci am getting following error "Invalid value -- press the prompt button or hyperlink for a list of valid values (15,11)"
i have tried hardcoding the values in ci also . result is sucessful but data in not there in dept_record.

and even i have tried lrim also ..
and plese help in this regard .
here am giving the code of that ci

/* ===>

Huge amount of data causing CI Error

While i am trying to insert data into the table using CI it was woking for few rows lets say upto 200-500 rows. But when i am tryin g to insert huge data lets say 25000 rows it is showing therror as below.

error saving Component Interface

Please send inputs if anybody faced such issue.