Wednesday, May 6, 2009

Manipulating Child Rows in A PeopleSoft Component Through Web Services

I had this issue when trying to manipulate ID types for a user profile through web service. It was easy to update an existing ID type or to insert a non-existing ID type. For example, look at the following SOAP message:


<soapenv:Body>
<ns1:Update__CompIntfc__USER_PROFILE xmlns:ns1="http://xmlns.oracle.com/Enterprise/Tools/schemas/M274199.V1">
<ns1:UserID>COPYUSER2</ns1:UserID>
<ns1:IDTypes>
<ns1:IDType>EMP</ns1:IDType>
<ns1:Attributes>
<ns1:Fieldname>EmplID</ns1:Fieldname>
<ns1:Recname>PERSONAL_DATA</ns1:Recname>
<ns1:AttributeValue>AA0001</ns1:AttributeValue>
<ns1:AttributeName>EmplID</ns1:AttributeName>
</ns1:Attributes>
</ns1:IDTypes>
</ns1:Update__CompIntfc__USER_PROFILE>
</soapenv:Body>


If ID Type 'EMP' exists for user profile 'TESTUSER', system updates the ID Type's attribute value as 'AA0001'. Or if ID Type 'EMP' doesn't exist with user profile 'TESTUSER', it inserted.

However, this way won't work if we need to remove 'EMP' from 'TESTUSER'. We must adopt an attribute 'CINodeAction' to do the work:


<soapenv:Body>
<ns1:Update__CompIntfc__USER_PROFILE xmlns:ns1="http://xmlns.oracle.com/Enterprise/Tools/schemas/M274199.V1">
<ns1:UserID>TESTUSER</ns1:UserID>
<ns1:IDTypes CINodeAction="delete">
<ns1:IDType>EMP</ns1:IDType>
</ns1:IDTypes>
</ns1:Update__CompIntfc__USER_PROFILE>

As the matter of fact, we can also set value 'update' or 'insert' to 'CINodeAction' for first and second scenacios stated above, and this makes the SOAP message unambiguous and more understandable.

Attribute 'CINodeAction' is not documented, but can be digged from application package SOAPTOCI.

PS: This tip applies up to PeopleTools 8.49. In to-be-released PeppleTools 8.50, property 'action' has been announced together with some other properties.

34 comments:

Anonymous said...

Good point!

Anonymous said...

[B]NZBsRus.com[/B]
No More Sluggish Downloads Using NZB Files You Can Rapidly Search High Quality Movies, PC Games, Music, Software and Download Them at Blazing Rates

[URL=http://www.nzbsrus.com][B]NZB[/B][/URL]

Anonymous said...

Halt Our Dastardly Prices at www.Pharmashack.com, The Portentous [b][url=http://www.pharmashack.com]Online Chemist's look to [/url][/b] To [url=http://www.pharmashack.com]Buy Viagra[/url] Online ! You Can also Bode to In the chips Deals When You [url=http://www.pharmashack.com/en/item/cialis.html]Buy Cialis[/url] and When You You [url=http://www.pharmashack.com/en/item/levitra.html]Buy Levitra[/url] Online. We Also Combat against in a Susceptive Generic [url=http://www.pharmashack.com/en/item/phentermine.html]Phentermine[/url] As a aid to Your Foodstuffs ! We Hawk Speciality streak [url=http://www.pharmashack.com/en/item/viagra.html]Viagra[/url] and Also [url=http://www.pharmashack.com/en/item/generic_viagra.html]Generic Viagra[/url] !

Anonymous said...

You could easily be making money online in the hush-hush world of [URL=http://www.www.blackhatmoneymaker.com]blackhat download[/URL], You are far from alone if you don't know what blackhat is. Blackhat marketing uses alternative or misunderstood avenues to build an income online.

xanax said...

I am not able to see this web site correctly on my telephone

free viagra said...

Wow, nice post,there are many person searching about that now they will find enough resources by your post

Anonymous said...

walmart alcohol and substance abuse policy http://alcoholboutique.com/kauffman.html alcohol 70 [url=http://alcoholboutique.com/heering.html]tylenol alcohol and valium[/url] homemade alcohol law

Anonymous said...

Firѕt оff I want tο say terrific blog!
I had a quіck question in which I'd like to ask if you don't mind.
I waѕ curious tо find out how you center yourself and clear your head before writing.
I have had a hard time cleaгing my thοughts in getting my iԁeas out.
Ι truly do take pleasurе іn writing but it just seems likе
the first 10 to 15 minutes are gеnerallу lοst simply just
trying to figure out how to begin. Any rеcommendatіοns or tips?
Appreсіate it!

Alsо visіt mу website; payday loan
Feel free to visit my blog : Online Payday Loan

Anonymous said...

s snd m dating services http://loveepicentre.com/ legal dating age

Anonymous said...

free dating numbers http://loveepicentre.com/taketour.php translation dating services

Anonymous said...

Saved as а favorite, I really liκe your website!


Мy weblog; payday loans online same day
My page > payday loans online

Anonymous said...

free online lesbian sim dating games http://loveepicentre.com/success_stories.php klerksdorp dating

Anonymous said...

[url=http://loveepicentre.com/][img]http://loveepicentre.com/uploades/photos/2.jpg[/img][/url]
ultimate dating blackbook [url=http://loveepicentre.com/faq.php]speed dating adult site[/url] history of internet dating services
online dating email reply [url=http://loveepicentre.com/]steve napier spain dating websites[/url] teen dating body lauguage
dating online professional service [url=http://loveepicentre.com/map.php]ink dating brunelle[/url] teen dating advice 101

Anonymous said...

[url=http://loveepicentre.com/][img]http://loveepicentre.com/uploades/photos/1.jpg[/img][/url]
dating 365 [url=http://loveepicentre.com/]internet dating liars[/url] singles pakistan chinese dating
free cinncinati oh dating sites [url=http://loveepicentre.com/articles.php]dating services worth it[/url] are you dating a player
single parents dating website [url=http://loveepicentre.com/articles.php]safe dating site[/url] who is zach levi dating

Anonymous said...

online dating service herpes http://loveepicentre.com/advice.php dating 30s

Anonymous said...

bishop book 17 ebook http://audiobookscollection.co.uk/fr/Real-Time-Systems-Design-and-Analysis/p140525/ ebook on christian authors [url=http://audiobookscollection.co.uk/M-Doi/m78930/]how to hide things ebook[/url] ebook across the wall

Anonymous said...

john d mcdonald and ebook http://audiobookscollection.co.uk/fr/Breathe-Well-Be-Well-A-Program-to-Relieve-Stress-Anxiety-Asthma-Hypertension-Migraine-and-Other-Disorders-for-Better-Health/p171732/ elie wiesel free ebook [url=http://audiobookscollection.co.uk/es/Moving-Millions-Transport-Strategies-for-Sustainable-Development-in-Megacities-Alliance-for-Global-Sustainability-Bookseries/p213086/]ho to use psalms free ebook[/url] reese gabriel torrent ebook

Anonymous said...

urantia ebook http://audiobookscollection.co.uk/Biochemistry/c1530/?page=38 free lincoln the unknown ebook [url=http://audiobookscollection.co.uk/it/Higher-National-Computing-Tutor-Resource-Pack-Second-Edition-Core-Units-for-BTEC-Higher-Nationals-in-Computing-and-IT/p226280/]effective stl ebook download[/url] freeware rocket ebook

Anonymous said...

ebook reader for mp3 player http://audiobooksplanet.co.uk/The-Ukrainian-Question-The-Russian-Empire-and-Nationalism-in-the-Nineteenth-Century/p223782/ hinduism ebook [url=http://audiobooksplanet.co.uk/it/authors/?letter=No]free pdf ebook proteomics[/url] catia v5 r16 ebook free

Anonymous said...

network flows ebook http://audiobooksworld.co.uk/Humor/c1232/?page=4 reloading ebook [url=http://audiobooksworld.co.uk/A-Million-Little-Pieces/p11225/]ebook devices in silicon valley[/url] c ebook streams

Anonymous said...

ebook on automated student record system http://audiobooksworld.co.uk/Job-Markets-and-Advice/c1989/ free ebook the merchant of death [url=http://audiobooksworld.co.uk/Tamela-Ice/m122947/]applications code markup ebook download[/url] royalty paying ebook publishers

Anonymous said...

geovision ip software http://buyoem.co.uk/product-11676/Iolo-Search-And-Recover-V2-5 operational availability and software loads [url=http://buyoem.co.uk/it/product-37208/Meta-Product-Download-Express-1-9]windows media player lyrics software[/url] blackberry device software v4.5 features
[url=http://buyoem.co.uk/product-37352/Ultra-Video-Splitter-5-0]Ultra Video Splitter 5.0 - Software Store[/url] accubid software
[url=http://buyoem.co.uk/de/product-36688/NoiseControl-1-0-for-Adobe-Photoshop][img]http://buyoem.co.uk/image/3.gif[/img][/url]

Anonymous said...

sketchup software model libraries http://buyoem.co.uk/product-36579/Microsoft-Windows-7-Ultimate-x32-Danish windows defender deleted my software [url=http://buyoem.co.uk/product-36740/RoomMate-5-0]password pantech service software[/url] synthesizer on pc keyboard free software
[url=http://buyoem.co.uk/fr/product-34597/Adobe-Creative-Suite-5-5-Production-Premium-MAC]Adobe Creative Suite 5.5 Production Premium MAC - Cheap Legal OEM Software, Software Sale, Download OEM[/url] computer chess software
[url=http://buyoem.co.uk/product-36941/OfficePrinter-2-0][img]http://buyoem.co.uk/image/1.gif[/img][/url]

Anonymous said...

[url=http://www.23planet.com]casino[/url], also known as accepted casinos or Internet casinos, are online versions of significant ("chunk and mortar") casinos. Online casinos own gamblers to bear off work looking on situation in and wager on casino games from cut off to foot the Internet.
Online casinos superficially by away up as a replacement search after of sales marathon odds and payback percentages that are comparable to land-based casinos. Some online casinos certify on higher payback percentages with a ruling toss up automobile games, and some transform known payout segmenting audits on their websites. Assuming that the online casino is using an fittingly programmed unspecific reduce up generator, catalogue games like blackjack clothed an established keep edge. The payout shard as a replacement in the diversion of these games are established then non-standard set aside to the rules of the game.
Assorted online casinos jurisdiction d‚mod‚ or apprehension their software from companies like Microgaming, Realtime Gaming, Playtech, Intercontinental Imposture Technology and CryptoLogic Inc.

Anonymous said...

buy ativan 1mg lorazepam equivalent - lorazepam 1mg

Anonymous said...

[url=http://redbrickstore.co.uk/refer-a-friend.htm][img]http://onlinemedistore.com/1.jpg[/img][/url]
shipees pharmacy wanaque http://redbrickstore.co.uk/products/ventolin.htm homeopathic pharmacy for dog nosodes online [url=http://redbrickstore.co.uk/products/arimidex.htm]kleins pharmacy[/url]
adipex online dr and pharmacy approval fedex overnight delivery http://redbrickstore.co.uk/products/diamox.htm walmart pharmacy milwaukee [url=http://redbrickstore.co.uk/products/cardura.htm]cardura[/url]
pharmacy vacancy in sao tome and principe http://redbrickstore.co.uk/products/viagra-super-active-plus.htm certified pharmacy tech accessories [url=http://redbrickstore.co.uk/products/reminyl.htm]careplex pharmacy[/url]
pharmacy unit dose robit http://redbrickstore.co.uk/products/eriacta.htm lake underhill pharmacy [url=http://redbrickstore.co.uk/products/herbolax.htm]herbolax[/url]

Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/proscar.htm][img]http://onlinemedistore.com/12.jpg[/img][/url]
utah state requirements for pharmacy tech http://certifiedpharmacy.co.uk/products/depakote.htm ideas for pharmacy week [url=http://certifiedpharmacy.co.uk/products/casodex.htm]rogue pharmacys[/url]
loyds pharmacy http://certifiedpharmacy.co.uk/products/antabuse.htm pharmacy tech programs [url=http://certifiedpharmacy.co.uk/products/brand-amoxil.htm]brand amoxil[/url]
online pharmacy tech http://certifiedpharmacy.co.uk/products/azulfidine.htm horizon pharmacy services [url=http://certifiedpharmacy.co.uk/categories/arthritis.htm]shire pharmacy[/url]
james pharmacy http://certifiedpharmacy.co.uk/products/levaquin.htm cyber pharmacy vioxx [url=http://certifiedpharmacy.co.uk/products/rogaine-2-.htm]rogaine 2 [/url]

Anonymous said...

ivxalfc502925061
wyqalzh549558034
http://onlineeducationexperience.com/node/34774
http://17drupal.com/node/1252#comment-40953
http://jumptheshark.souredmilk.com/sour/longchamp-20-janvier-1984-ulcalax-503726166#comment-218

Anonymous said...

It is Miuccia [url=http://www.furworld.ru/ ]шуба [/url] and Patrizio Bertelli who discover the secret of Prada and invent the first black nylon Prada handbag on the planet which opens the successful and beneficial door of celebrated handbag brand. Prada Handbags is renowned for its lavish. Each lady wants a Prada handbag which stands for the fashion and the way of life. Prada store sells cheap Prada, including Prada purses and Prada handbags. [url=http://www.furworld.ru/ ]шубы из китая [/url] is the greatest way for you to select a bag of top quality and best designed. With the development of Prada, more and more [url=http://www.furworld.ru/ ]мех [/url] are established. Buying Prada handbags and Prada wallets in [url=http://www.furworld.ru/ ]Шубы [/url] will save you numerous time and money. [url=http://www.furworld.ru/ ]Шубы оптом [/url] can also be a good choice for you. [url=http://www.furworld.ru/ ]Шубы оптом [/url] will not let you down.

Anonymous said...

single online dating agency uk meet and fuck lelia virtual online dating game
free internet dating classifieds http://freeinternetdating.info/singles/singles-dance-greenville figuring out what dating dealbreakers are
scam nigerian scam dating dating site in usa and canada dating in schuylkill county pa

Anonymous said...

dating escorts romance costa rica http://loveepicentre.com/contact/ buddhist dating free
free online dating simulator [url=http://loveepicentre.com/advice/]mathematical methods of the historical dating[/url] mark croker dating in alberta
who is taylor swift dating [url=http://loveepicentre.com/taketour/]black people meet dating service[/url] love and dating online [url=http://loveepicentre.com/user/Magas/]Magas[/url] dating game theme

Anonymous said...

free interracial dating 100 free http://loveepicentre.com/map/ faith christian dating
orthodox online dating [url=http://loveepicentre.com/articles/]american single dating site[/url] i want dating site
gay and lesbian online dating [url=http://loveepicentre.com/faq/]uruguay dating customs[/url] panama singles dating [url=http://loveepicentre.com/user/tsolak_m/]tsolak_m[/url] adult sex dating sites american express

Anonymous said...

No one else provides you such for the simple reason a business
loan which has they are cautious about this.
If you have the heart, the legal documents, and the business plan then
the source of finance might be the next problem
to seek solution to! In both these examples, the borrower has the loan secured against personal assets and the loan is
made based off of personal credit and income.


Stop by my site :: Payday Loans ()

jubrin.finance said...

Good day,
We are a registered private Loan lender. We give out loans to individuals, corporate bodies, and companies firms. who need to update their financial status all over the world, with very Minimal annual Interest Rates as Low as 3% within a year to 25 years repayment duration period to any part of the world. We give out loans within the range of $2,000.00 to $500,000,000.00.in all currency, if Interested in our loan offer which includes Personal Loan,Consolidation Loan,Business Loan,Home Loan,Investment Loan,Agricultural Loan.Please do provide us with the following details below if Interested via email: jubrinfinance333@gmail.com