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 is a flexfield? List out its types.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What do you understand by a set of books?
Explain what are the tables of auto invoice?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
can we use look up type instead of a pofile option?or valueset?is it possible how?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
is it possible to run the interface without using oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What do you understand by soa?
How can you achieve loose coupling in soa framework?
Do you know where we can check the status of po?
please send me forms, xml pulisher questions,answers
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify