Home » Applications » Oracle Fusion Apps & E-Business Suite » condition using not null in interfaces
condition using not null in interfaces [message #378310] Mon, 29 December 2008 21:24 Go to next message
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 Go to previous messageGo to next message
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.
Re: condition using not null in interfaces [message #382536 is a reply to message #382180] Thu, 22 January 2009 19:39 Go to previous message
radhavijaym
Messages: 65
Registered: December 2008
Location: singapore
Member
Hi,
ya i solved it.

Thank u.
Previous Topic: Creation of Sales order
Next Topic: Auto Invoice error
Goto Forum:
  


Current Time: Fri Dec 09 08:15:05 CST 2016

Total time taken to generate the page: 0.10285 seconds