Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to populate a column value dynamically based on org id value

778517Dec 29 2011 — edited Dec 29 2011

Hi,
I have two columns in a table program_id and org_id,

I need to populate program_id = 1 for org_id = 100
I need to populate program_id = 2 for org_id = 101

for populating org_id i am using "fnd_profile.value('ORG_ID')". This is working fine. But when i decode doe program_id it is not working.

below is the samle control fille i am using.

into table ap_credit_card_trxns_all
when (1) = '1' and (431:432) <> 'CA' and (431:432) <> '04' and (431:432) <> '03' and (431:432) <> '01' and (431:432) <> 'NF'
(
trx_id "ap_credit_card_trxns_s1.nextval",
validate_code constant 'N',
payment_flag constant 'N',
card_program_id "decode(:org_id,82,10000,83,10001,null)", --
org_id "fnd_profile.value('ORG_ID')"

I tried all possible ways but still not working. Can any experts please help me on this.

Thanks,