Answer / vans

The above posted details are perfect.

Here to load the data from legacy system to your staging
table you can use SQL LOADER.

Once loaded to the table run the package to do the required
validations.

We can use two approaches to load the data into base table.
1)Using open interface
2)Use API.

1)Using open interface
We need to place the validated date from staging table to
standard interface table and then run the standard
interface program to place the data in Base table

2)Use API

In this case we do not use interface table.We take the data
from staging table validate and call the standard API which
will place the data into base table.

Here, to the API we need to pass the required IN parameter
from the staging table once it being validated.

For example in HRMS the employee conversion we can call the
below API to create employee
hr_employee_api.create_us_employee

Answer / 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

Answer / prasad reddy

Hi,
In Oracle apps if you want to load data from legacy
system to Oracle application we go for conversion, if it is
one time process.

The following steps must be followed.

Load data from flat file to staging tables ( temp tables )
then write your own package or procedure to populate the
interface table.

Then finally you can run oracle seeded program to populate
the base table.

ex
----

Interface tables

MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE

Base tables

MTL_SYSTEM_ITEMS_B
MTL_CATEGORIES_B
MTL_ITEM_REVISIONS_B

Concurrent program name is -> import items

Error table
------------
MTL_INTERFACE_ERRORS

Validations
-------------
Organization Code

SELECT organization_code
INTO l_organization_code
FROM org_organization_definitions
WHERE organization_code =
cur_rec.organization_code;

Inventory Org Id

SELECT organization_id
INTO l_organization_id
FROM mtl_parameters
WHERE organization_code = l_organization_code;

To check whether item is already exits


SELECT COUNT (*)
INTO l_item_count
FROM mtl_system_items_b
WHERE segment1 = cur_rec.segment1
AND organization_id = l_organization_id;

Item Type

IF cur_rec.item_type IS NOT NULL
THEN
SELECT lookup_code
INTO l_item_type
FROM fnd_common_lookups
WHERE lookup_type = 'ITEM_TYPE' AND meaning =

cur_rec.item_type;

very mandatory
mtl_system_items_interface
(
process_flag,
transaction_type,
item_number,
description,
organization_id,
set_process_id)
VALUES
(1,
'CREATE', or update
'Rev_hist_test', ----item_number
'IOI Revision Part', ----description
204,
1
);


I think the explanation could help you.



Regards,
-prasad

Tell me where we find the status of order information?

0 Answers  

---

in GL module specifing org_id or not?

1 Answers  

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

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?

0 Answers  

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---

How to retry multiple errored workflow processes? What is the access level in workflow used for? How do you define start and end functions in workflow? How does they differ from normal functions? Give me some workflow tables? What is the difference between a function and notification in workflow? I have sent two different notifications to two different users and I want to wait till both they are approved to send 3rd notification. How can you achieve it? What is item type and item key in workflow? How do you use attribute values in workflow messages? How do you use lookups in workflow? What are roles in workflow and how they are used? How do you download or upload a workflow from a server? What are steps to customize the workflow? What functions can you perform from workflow administrator responsibility? To send an email to the user workflow notification is the only way or is there any other ways to send it? Give me some workflow standard procedures? How can you run/start/kickoff workflow? What is wf_engine package used for? How many processes can each workflow contain? What is Runnable option in workflow? At what level it exists? What are different types of attributes in workflow? How do you reassign a notification? What is process in workflow? How can you send direct oracle form link through workflow notifications? How can you send a notification to multiple users? Can you change the list dynamically? Can you send html code in workflow notification? I have sent two different notifications to two different users and I want to wait till atleast one is approved to send 3rd notification. How can you achieve it?

0 Answers   Accenture, CTS,

---

Registering parametric report?

1 Answers  

---

what are the difference between oracle discoverer and report6i

1 Answers  

---

what is the need of registering table in apps?

5 Answers   TCS,

---

What is sca and how is it useful?

0 Answers  

---

In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,

---