Home > The Specified > Row Already Exists With The Specified Keys

Row Already Exists With The Specified Keys


rem ***** Execute Get *****;       If Not &oBlgPersDtaCi.Get() Then          rem ***** No rows exist for the specified keys.*****;          errorHandler();      Wikidot.com Privacy Policy. The keys for the CI are as follows (no CreateKeys) 1) GetKeys EMPLID EMPL_RCD 2) FindKeys EMPLID EMPL_RCD NAME LAST_NAME_SRCH NAME_AC PER_ORG BUSINESS_UNIT DEPT_ID When I test the CI in App Why not? have a peek here

No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Something does not work as expected? PCMag Digital Group AdChoices unused Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages why not find out more

Row Already Exists With The Specified Keys

The role is Standard Non-Page Permissions. Generating a PeopleCode CI Template Now, we are ready to begin adding PeopleCode to Step 01.  You can open the PeopleCode by double clicking anywhere in the gray of the PeopleCode Adam replied Apr 26, 2006 Karteek, yep dat was it, thanks a lot!!

  • How can I stop Alexa from ordering things if it hears a voice on TV?
  • This dialog box displays the keys (in the left-hand columns) for getting, creating, or finding an instance of the component interface.
  • Post to Cancel Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses!

Top Sun, 12/14/2008 - 2:11pm #12 Guest (not verified) Re: component Interface hi, i think you have to first create rowset,then use rowset.fill then use getrecord (your record) method to create i get an error like this Begin (91,50) - No rows exist for the specified keys. {GR_CIMAIN} (91,50) (2,214) - SetID not found for name='BUSINESS_UNIT', value='IN005' with record 'LED_FLDS_BAL_VW', tree ''. print multiple rows from a select statement more Recent comments Re: Loading CSV file into staging tables without using file ...3 days 3 hours ago AR Racer Speed – The World’s Custom ColorFunction for GeoGraphics plot with ReliefMap How to help reduce students' anxiety in an oral exam?

Additional info: PeopleTools 8.53.02 PeopleSoft HRMS 9.20.000 Attached is a screenshot of my Location CI. Row Already Exists With The Specified Keys. (91 49) rem ***** Get the Component Interface *****;       &oBlgPersDtaCi = &oSession.GetCompIntfc(CompIntfc.BLG_PERS_DTA_CI);       If &oBlgPersDtaCi = Null Then          errorHandler();          throw CreateException(0, 0, Thanks! my review here E.g.

Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more. If you then add another level 1 record then you will have 2 rows in the scroll but only a reference to the second. For example, it might be EFFDT at level 0 but something like EFFDT_1 in level 1 of the component interface. Tom replied Mar 10, 2010 It looks like there are no rows to be returned with the keys in CSV file.

Row Already Exists With The Specified Keys. (91 49)

Kindly try to use this CI using Excel to CI and it wont work whereas it works fine when Testing Component Interface through Application Designer. http://stackoverflow.com/questions/36039750/peoplesoft-effective-dated-ci-no-rows-exist-for-the-specified-keys-java This explains as "An error occurred while getting the Component Interface. Row Already Exists With The Specified Keys You can do that for your permission list.There you can specify what access you would like to give. Row Already Exists With The Specified Keys Component Interface Check out how this page has evolved in the past.

Why are my Findkeys missing certain fields? I only used it to perform basic operations but I followed your guidelines and reproduced the same error message. rem ***** Set the Component Interface Mode *****;       &oBlgPersDtaCi.InteractiveMode = True;       &oBlgPersDtaCi.GetHistoryItems = True;       &oBlgPersDtaCi.EditHistoryItems = True; Then, we update the Empl ID field on You can still ask questions and help others!

Thanks in advance. Kindly report it to Oracle to get the correct CI for the same or update the CI by including all key fields to the child record same as parent record. This HTML page also displays the complete list of error and warning messages in a tabular format. Check This Out That is the only "flaky" behavior I have noticed.

Check that the field is actually in your component interface. Like I said, generally good advice. Get , find,etc..

Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM

Adam replied Apr 17, 2006 I have already given the CI full access through permissions so i dont think that is an issues; besides in that case the error that is If you then set the fields on the second row and try to save it, you may get exactly the kind of errors (missing required fields on row 1) that you Can I override my Component Interface methods? Append content without editing the whole page source.

Start a new thread here 5648087 Related Discussions Pass date to CI property Getting Invalid Property On My Component Interface Create Record in PS_ACAD_PROG Table using CI Peoplecode Job data CI Also check that you have access to all possible methods (Get, Save, Create, Cancel, Find). Why not? Sophos Thawte View All Topics View All Members View All Companies Toolbox for IT Topics PeopleSoft Groups Ask a New Question PeopleTools A forum where peers share technical expertise, solve problems,

All Rights Reserved. One of the following three status values can appear when you submit data to the database: Field or Control Definition Ok The submission to the database finished successfully. Most probably, this is caused by the Effective Date behavior of the table. share|improve this answer answered Mar 18 '16 at 14:36 Jared 1879 1 Generally good advice, but not always 100% accurate.

Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... The permission list is HCSPCMPINT. General Wikidot.com documentation and help section. Is there a comprehensive list of issues and solutions?

The search record for your component does not have any search keys defined. Cheers. –Barney Mar 21 '16 at 20:52 1 Component Interface is tricky, GetDummyRows and Interactive mode will change the behavior. l1.DESCR = ci.save() // cross your fingers... Why are my Findkeys missing certain fields?

Home | Invite Peers | More PeopleSoft Groups Your account is ready. I was able to create and update a Location through the web/online application but can't do the same from CI.