| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL script to add Oracle userīs responsibilities
I have a few things you can start with. We migrate items to production via scripts which includes assigning programs and request
sets to responsibility groups. I also have some scripting examples of how a responsibility can be assigned to an individual via api.
Forms are also great as tools, but they were never meant for mass loading purposes... hence Oracle seeded apis are made available.
Barry Chase
On Thu, 10 Aug 2006 14:12:14 -0700, DA Morgan <damorgan_at_psoug.org> wrote:
>contracer11_at_gmail.com wrote:
>> DA Morgan wrote:
>>> contracer11_at_gmail.com wrote:
>>>> Iīm looking for a SQL script to add Oracle userīs responsibilities,
>>>> bypassing Oracle forms.
>>>> Is there any way ?
>>>>
>>>> Iīm using:
>>>>
>>>> Oracle Applications : 11.5.4
>>>> Oracle Forms Version : 6.0.8.25.2
>>>> Application Object Library : 11.5.0
>>>>
>>>> Thanks.
>>> Why?
>>>
>>> What is wrong with the current interface?
>>> --
>>> Daniel A. Morgan
>>> University of Washington
>>> damorgan_at_x.washington.edu
>>> (replace x with u to respond)
>>> Puget Sound Oracle Users Group
>>> www.psoug.org
>>
>> I have thousands responsibilities to add diary, and Iīd like
>> create a script to insert it, bypassing Oracle graphics interface.
>> Every time that I insert a duplicated resp I get a popup message:
>> "This responsability has already been assigned to this user.
>> Please enter a diferent responsibility"
>>
>> Thanks.
>
BChase
bsc7080mqcXX_at_myoracleportal.com
(remove XX to contact)
 |
 |