Could any one tell me the steps of conversions and what
kind of validations and exceptions do we use during this
conversion? Please do answer in detail.
what program do we write in user exit in reports?
Answer Posted / nagaraju chittamsetty
Hi to all,
Conversion is one of the important RICE components.It is
one time process.
The main use of conversion transfer the data from legecy
systems to oracle base tables,To do this we need to follow
some steps.
Example take Purchasing(import standard purchase orders):
1.First take the legecy data(.csv or .dat or .txt etc) file
2.create the stagging table/temparary table based on the
interface table.
3. Create the package and run the package based on the
functional document and insert any errors into the errors
table(i.e.custom validation errors)
4.After running the package data transfered from stagging
table to respective interface tables,In purchasing module
interface tables arepo_headers_interface,po_lines_interface
and po_distributuions_interface.
5.Once data inserted into interface tables then run the
standard concurrent program which is already provided by
oracle apps.
6.Once we run the import standard purchase orders then data
is transferred into respective base tables,if any errors
occured in processing time those errors are stored into
po_interface_errors table.
I think it will give good idea on conversion of standard
purchase orders.If any clarifications and suggestions send
feed back to csnraja@gmail.com
Regards,
Nagaraju.ch
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What are the benefits of using soa architecture?
what is global tempory table?
Can you differentiate between mediator and osb?
how can i print random rows in plsql table
what are the balancing segments in AR?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What is a value set? List its various types.
Tell me how to debug the report?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can we create tables in apps schema?
Do you know what is applysys in oracle application database schema, what is apps?
In hierarchical structure of a database? we have write query from where we should start?
what are the prerequisites for costing transactions?
please send me forms, xml pulisher questions,answers
q)what are the validations in sql*loader