Oracle ERP Technical - PLSQL Based Concurrent Program

Oracle ERP Technical - PLSQL Based Concurrent Program

[@sureshrautela5131]

How can I make one concurrent program run only one at a time based on specific parameter either through pl/SQL or through Front end.

[@in2sun275]

Is there any possibility that the number for parameter mentioned in procedure to take exactly 6 number not less than 6 and more than 6 exactly 6 should accept ,can we control that in the value set???

[@oratrainings]

Yes, it is possible, conditionally you can control concurrent program parameters

[@in2sun275]

@@oratrainings one more doubt ,actually by entering data by clients in flexfields ,it will store data into table , but they will enter twice that make an error by single query fetching more than one .So in order to avoid i can manage it in procedure but i have to change so many places.But my question is Is there any possibility to avoid double entries without oaf but only by controlling value set

[@supriyakhandave5479]

If i have only plsql query and need to create concurrent program and expect output in excel format then i need to create executable or else only define the program?

[@oratrainings]

You need both Executable And Program

[@supriyakhandave5479]

@@oratrainings but i dont have package or procedure so how executable will be created?

[@oratrainings]

@@supriyakhandave5479 so you just have SQL Query, then the conc executable should be of type : SQL*Plus