EBS Customizations (MOSC)

MOSC Banner

Parameter in Oracle alert

edited Dec 30, 2015 10:00AM in EBS Customizations (MOSC) 3 commentsAnswered

Hi Experts,

    I am triggering a concurrent program in a 'Oracle Alert' .This Alert will be triggered when a record is inserted/updated in hz_parties table.The party_id and party_name from hz_parties

is passed as a parameter to the concurrent program.Below is the query used.

SELECT PARTY_ID ,PARTY_NAME INTO &P_PARTY_ID1,

&PARTY_NAME1 FROM HZ_PARTIES

WHERE PARTY_TYPE ='ORGANIZATION'

and CREATED_BY_MODULE = 'CE'

and ROWID=:ROWID

Here is how i am calling the concurrent program.

For ex: If party_name is "Bankalert1" then the concurrent program is working correctly as expected.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center