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
In hierarchical structure of a database? we have write query from where we should start?
Explain what are the tables of auto invoice?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Tell me how to find the custom directory in front end?
what is the difference between request group and request security in oracle apps?
what are the prerequisites for costing transactions?
where to define interorganization transaction charges and what are the different options?
Can u give the Documentation of Custom.pll in oracle apps
What is a value set? List its various types.
How is choreography different from orchestration?
List the various types of value set.
testing tools?
Plz anybody send me Technical specification for AP Interface
What is the concept of soa governance?
What is oracle soa suite?