Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 18658 Views
- iGate, I also Faced
- E-Mail Answers
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
q)what are the validations in sql*loader
Can you explain the difference between architecture followed in 10g & 11g?
What do you understand by concurrent programs?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Can u give the Documentation of Custom.pll in oracle apps
Are you familiar with internet architecture of oracle apps 11i?
What is sca and how is it useful?
What is the concept of soa governance?
tell me the scenarios of the independent in reports
can we use look up type instead of a pofile option?or valueset?is it possible how?
tell my any difficult situtation you solved in your experience in your company?
What is a value set? List its various types.
In support project one ticket alloted which steps follows manualy tell me ?
What does appl_top directory contain?
what are the different transaction clauses in AR?
