OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » SEQUENCE value is not not incrementing when it is Scheduling

Home » Applications » Oracle Fusion Apps & E-Business Suite » SEQUENCE value is not not incrementing when it is Scheduling

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SEQUENCE value is not not incrementing when it is Scheduling [message #194735]

Mon, 25 September 2006 00:56

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

Hi,
I have a problem in parameter GROUP_ID, defined as Default type SQL Statement and their value is (select FSG_invoice_grp_s.nextval group_id from dual). This parameter value is sharing other five concurrent programs within Request set. The problem is when I schedule to run this program the value is not incrementing, we are getting its previous value.
But if I run this request set as a independent (i.e. Without scheduling) the value is populating with Nexval, if I copy the request set and run, I am getting the same problem.

Please help me out immediate, bez this is prod issue

Thanks In Advance

Regards
Anil

Report message to a moderator

Re: SEQUENCE value is not not incrementing when it is Scheduling [message #195165 is a reply to message #194735]

Wed, 27 September 2006 04:52

KARTHICK_narayan
Messages: 21
Registered: September 2006
Location: BAHRAIN

Junior Member

hi anil,

i think u r running the concurrent request in parallel.

try with the seqeunce. hope u will get it.

Report message to a moderator

Re: SEQUENCE value is not not incrementing when it is Scheduling [message #196109 is a reply to message #194735]

Wed, 04 October 2006 03:10

KARTHICK_narayan
Messages: 21
Registered: September 2006
Location: BAHRAIN

Junior Member

anil,

this concurrent request is using the shared variable.

remove the shared variable and assign individual variable in the request set parameter form.

regards

karthick.

Report message to a moderator

Re: SEQUENCE value is not not incrementing when it is Scheduling [message #196116 is a reply to message #194735]

Wed, 04 October 2006 03:24

anil_apps
Messages: 34
Registered: November 2005
Location: India

Member

Hi karthick,

Thanks for replay,
There are 10 programs in the request set, 4 th program is Using GROUP_ID parameter of type SQL statement. Select CMSEQ.nextval from Dual, the value of this sequence is sharing the other 4 programs
If run the request set manually, no issue. If we schedule the program the value is not incrementing, I.e. parameter form is not refreshing. As per u r suggestions if I remove the Sharing in between the other programs I will get problem, because I want only one value to all other programs, and this value is incremented for each run.
I have tested the sequence in backend it is working fine.

Please help me out.

Regards
-Anil

Report message to a moderator

Previous Topic:	Need Inventory Item Functional Details
Next Topic:	Regarding FSG

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:13:45 CDT 2024