If we transfer the data from legacy system to oracle base
tables. I want to hold the data in interface table how?
Answer Posted / nagaraju chittamsetty
Hi to all,
Actually there is no possibility to insert data into base
tables directly.We use Standard API provided by oracle
people.
Suppose let us assume that if we want to transfer standard
purchase orders into po base tables we are useing
po_headers_interface,po_lines_interface,po_distribuitons_int
erface.
After transer the data into interface tables we are run the
standard API like import standard purchase orders api which
will validate the data,then insert into respective base
tables.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
Can u give the Documentation of Custom.pll in oracle apps
How to move the one file from one instance to another instance? And your scripts also?
Tell me where we find the status of order information?
q)what are the validations in sql*loader
Tell me how to find the custom directory in front end?
how do you describe O2C along with tables
do you know is it possible to run the interface without using oracle apps?
is it possible to run the interface without using oracle apps?
What is instead of trigger in where we will use?
Can you define an erp system?
what are the balancing segments in AR?
What do you understand by soa?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
can we use look up type instead of a pofile option?or valueset?is it possible how?