EBS Customizations (MOSC)

MOSC Banner

Concurrent Parameters Display Values

edited Aug 24, 2015 10:02AM in EBS Customizations (MOSC) 4 commentsAnswered

Concurrent Program

1)

SEQ= 10

p_Account_Number
Value set -> SQL Statement
Default Value -> select Account_NUMBER from XXBG_FUN_BATCH_NUMBER_V WHERE Account_name=:$FLEX$.p_Account_Name

2)

SEQ=20

p_Account_Name
Value set -> SQL Statement
Default Value -> select Account_name from XXBG_FUN_BATCH_NUMBER_V WHERE Account_NUMBER=:$FLEX$.p_Account_Number

This is only working when we use flex value in SEQ= 20 however it is not working when we use for SEQ= 10.

Can you please let me know how to make it working when I select account number then it should display corresponding account name and vice versa.

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