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
- 18463 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
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What do you understand by soa?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Can u give the Documentation of Custom.pll in oracle apps
Can you define an erp system?
What do you understand by concurrent programs?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
is it possible to run the interface without using oracle apps?
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 and what are the benefits of using this architecture?
What is a value set? List its various types.
Which oracle apps version you are very confident in?
Are you familiar with internet architecture of oracle apps 11i?
What are the Standard Reports and Forms in HRMS?
How do you register report in oracle apps?
