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

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?

4784

---

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

1123

---

How many schemas we have? how many you have used?

2069

---

testing tools?

2258

---

what is the differences between internal requisition and internal sales order?

2661

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2378

---

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

2617

---

tell me the scenarios of the independent in reports

2626

---

What do you understand by a set of books?

1116

---

is it possible to run the interface without using oracle apps?

1980

---

Tell me how to find the custom directory in front end?

1111

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2219

---

What are file in oracle.

2239

---

do you know is it possible to run the interface without using oracle apps?

1120

---