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

can we use look up type instead of a pofile option?or valueset?is it possible how?

1792

---

can we get profile values in report without using user exists is it possible how?

2327

---

q)what are the validations in sql*loader

1750

---

What are do's and dont's of Interface?

1913

---

How do you register report in oracle apps?

636

---

---

how to print multi lay outs,muti currency,muti language in xml publisher

10767

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

640

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2473

---

In oracle application how do you debug or trace errors?

643

---

What is a value set? List its various types.

655

---

What do you understand by a set of books?

657

---

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

1585

---

How can a process be deployed in soa?

705

---

What is the concept of soa governance?

776

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2133

---