| condition using not null in interfaces [message #378310] |
Mon, 29 December 2008 21:24  |
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
|
Member |
|
|
im oracle apps technofunctional consultant.
i had 2 systems one legacy system and other is oracle system.
now while doing inbound interface im check the following details.
i had 2 tables tab1 and tab2 tab1 from legacy system and tab2 from oracle system.
i must select tab1.col1 and tab2.col1 from tables tab1 and tab2 and again i must check the condition that tab1.col2 and tab2.col2 must be not null and tab1.col3 and tab2.col3 must be not null in this condition i need to fetch values and then i shold raise a msg if not exit
im new to interfaces.
if ay one have sound knowledge in interfaces please give there mail id so that i can give the details clearly.
|
|
|
|
| Re: condition using not null in interfaces [message #382180 is a reply to message #378310] |
Wed, 21 January 2009 04:42  |
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
|
Senior Member |
|
|
in interfaces you take data from tab1 and insert into pre-interface table. do some validations on the data and then you put this pure data in oracle apps base table using standard interface programs or APIs...
Let me know if you face any problem.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
