Amazon Recomendations

Showing posts with label Concurrent Program. Show all posts
Showing posts with label Concurrent Program. Show all posts

Monday, July 14, 2014

Creating Read-Only Value Sets

hi,
I been away too long, guess raising baby girl is more time consuming than I thought - but honesty, I enjoy spending time with her way better then posting tech ;-)
OK, following piece is short and to the point.
I been asked to provide our client with a way to run certain concurrent program with read-only parameters. All the required parameters would be initiated automatically: there are default values to every one of them, whenever its Profile Option or SQL Statement.
Task: User should be able to see those values on Submit Request form, but he would not be allowed to update those values.
There are numerous sophisticated tricks to make dependable parameter through dependable Value Sets and hidden parameters, but I am not interested in redesign my concurrent program completely, so it is not a solution I am looking for.
Why not just create "Read-Only" Value Set?
Solution: We are going to create two Read-Only value set for chars and numbers correspondingly.
1.Create new Special value set XX_NUMBER_READ_ONLY (see the screens)


by pressing Edit Info, lists' logic revealed:


2. Same goes for XX_VARCHAR_READ_ONLY Value Set:


Now, the only this that left is to connect those Value Sets to corresponding parameters as displayed below:


So once the program is submitted, the Parameters form would look like:


enjoy,

Felix




Sunday, May 19, 2013

Failing to Submit Custom Programs in Oracle

hi,
Following the solution for the issue we been bumping in every new environment we create lately:
every single Concurrent Program created under Custom Application (XX...something) been failing to submit:


Oracle actually has a detailed solution for this issue, so I decided to re-post for all the unfortunate souls that does not have an access for Metalink:


Add the custom application to a data group.

1.  Under the System Administrator responsibility navigate to 
Security -->Oracle --> DataGroup.
2.  Query up a data group (Standard Data Group is appropriate).
3.  A list of applications associated with the standard data group will appear.
4.  Click on FILE in the toolbar menu then click on NEW.
5.  In the Application column select the custom application from the LOV.
6.  Add an Oracle ID to the ORACLE ID column (APPS is appropriate)
7.  Save the changes.
8.  Resubmit the concurrent request.

enjoy