display date oracle environment refreshed

Dispaly date oracle environment refreshed

After refershing the clone a date can be displayed on the form by adding the date in the site name. This can be achieved by editing the profile option 'site name'. This can be done thru front end or backend.

Changing thru front end:

Navigation: Responsibility---Sytem Administrator

Profile--->System

In system profile option find the profile 'site name'. See the value here and add the refreshed date in the text.

Example:

Original value in the site name profile is
It is changed to



save.

Logout and login again and see the title on any form.

Changing thru back end:

Run the below query


UPDATE apps.FND_PROFILE_OPTION_VALUES SET
profile_option_value = 'TEST:'||' Refreshed from '||'Production: '||SYSDATE
WHERE profile_option_id = 125


Example:


UPDATE apps.FND_PROFILE_OPTION_VALUES SET
profile_option_value = 'Clone XXX'||SYSDATE
WHERE profile_option_id = 125



After update

Clone XXX Refreshed on 24-Oct-08

Thanks.

Happy learning.
Kutub

Purchasing Setup: Encumbrance Accounting

This is the note taken from metalink. I will add more notes on encumbrance accounting.

Purchasing Setup: Encumbrance Accounting
(reference:Doc ID: Note:121860.1)


PURPOSE
-------

To assist viewers of this document in verifying the common setup steps related
to this topic. Please consider all steps or guidelines mentioned below prior
to logging an iTAR with support.


SCOPE & APPLICATION
-------------------

This document is intended for all users, consultants and support analysts of
the Oracle Purchasing application. The setup steps listed below are not
necessarily in the proper order, but are simply provided as a tool for the
user to verify their work.


Purchasing Setup: Encumbrance Accounting
----------------------------------------

Setting up encumbrance accounting actually has very few actions that need to be
performed in Oracle Purchasing module. The primary level of effort required for
encumbrance accounting setup is in the General Ledger module. There is one
action that can be taken by PO and it deals with the AP form Financial Options.

Here are some quick setup steps for encumbrance accounting. The setup details
may differ depending on your business needs. There are very minor differences
between Release 10.7 and Release 11; the steps included here are for Release 11.

NOTE: Any navigation paths specified in this document can be performed using
the Purchasing Super User and General Ledger Super User responsibilities, unless
noted otherwise. Also, any and all profile options discussed in this document
can be defined from the following responsibility and navigation within Oracle
Applications:

Responsibility: System Administrator
Navigation: Profiles -> System


1) Define the Encumbrance Account
1.1. Navigation in GL: Setup -> Financials -> Flexfields -> Key -> Values
Navigation in PO: Setup -> Financials -> Flexfields _> Key -> Values
1.2. Perform a find by entering the following criteria:
Application: Oracle General Ledger
Title: Accounting Flexfield
Structure:
Segment: Account
1.3. Click the Find button.
1.4. Add a new segment value.
Value: (enter your own)
Description: Reserve For Encumbrance
Qualifiers:
Allow Budgeting: Yes
Allow Posting: Yes
Type: Liability
1.5. Save the record.

2) Enable Budgetary Control
2.1. Navigation in GL: Setup -> Financials -> Books
2.2. Query up the proper Set Of Books
2.3. In the Budgetary Control Options alternate region:
Enable Budgetary Control: Yes
Require Budget Journals: Can be blank - dependent on business needs.
2.4. Add Reserve For Encumbrance Account
2.5. Save

3) Open the Encumbrance Year (GL)
3.1. Navigation in GL: Setup -> Open -> Close.
3.2. Set the year to open.
3.3. Click button Open Next Year.
3.4. After confirming the prompt to open the selected year, a concurrent
request is launched; the encumbrance year will be open upon completion
of this concurrent request.

4) Set Encumbrance Types (PO)
4.1. Navigation in PO: Setup -> Organizations -> Financial Options
Encumbrance Alternate Region
4.2. Choose encumbrance types for Requisitions and Purchase Orders.
Oracle Financials provides two predefined encumbrance types that you
can use to identify requisition, purchase order, and invoice
encumbrances: Commitment and Obligation. Additional encumbrance types
can be defined in Oracle General Ledger.
4.3. Use Requisition Encumbrance:
If you enable this option, Purchasing creates journal entries and
transfers them to General Ledger to encumber funds for purchase
requisitions.
- Encumbrance Type:
If you enable Use Requisition Encumbrance, you must select a
requisition type by which you can identify your requisition
encumbrance journal entries. Purchasing assigns this encumbrance
type to the encumbrance journal entries it creates for purchase
requisitions.
- Reserve at Requisition Completion:
If you enable Use Requisition Encumbrance, indicate whether you want
requisition preparers to have the option to reserve funds. If you
do not enable this option, only requisition approvers will have the
option to reserve funds.
4.4. Use PO Encumbrance:
Enable this option to encumber funds for purchase orders, invoiced
matched to purchase orders, and basic invoices (not matched to a PO).
If you enable this option, Purchasing encumbers funds for purchase
orders and Payables encumbers funds for variances during approval of
invoices matched to purchase orders. If you enable this option and
enter a non-purchase order-matched invoice, Payables will encumber
funds for it during approval. All Payables encumbrances are reversed
during posting. If you enable Use Requisition Encumbrance, you must
also enable this option.

5) Define Budgetary Control Groups
5.1. Navigation in GL: Budgets -> Define -> Controls.
5.2. Query the Standard budgetary control level.
5.3. Select the funds checking level to either absolute, advisory or none.
5.4. Save.

6) Define Budget
6.1. Navigation in GL: Budgets -> Define -> Budget.
6.2. Enter a name and description
6.3. Status: Open
6.4. Require Budget Journals: Yes
6.5. Define the budget periods (these are typically for the duration of the
fiscal year).
6.6. Click the Open Next Year button (concurrent process gets submitted).

7) Define Budget Organization
7.1. Navigation in GL: Budgets -> Define -> Organization
7.2. Enter Budget Organization Name and Description.
7.3. Ordering Segment: Account
7.4. Display Sequence: Enter the sequence of segments desired.
7.5. Suggest not entering a password but you may if so desired.
7.6. Click the Ranges button.
7.7. Enter the Account Range From/To, click OK.
7.8. Type: Entered
7.9. Currency: USD
7.10. Encumbrance: Yes
7.11. Funds Check Level: Select from Absolute, Advisory, or None.
7.12. Amount Type: YTD (usual entry)
7.13. Funding Budget: Enter the Budget created on step 6 above.
7.14. Save.

8) Define Budget Journal (GL)
8.1. Navigation in GL: Budgets -> Enter -> Journals
8.2. Enter the Budget Organization created in Step 7
8.3. Find the appropriate budget, accounting periods, currency.
8.4. Alternate Region: Worksheet mode
8.5. Click and enter the accounts field and enter the accounts range.
8.6. Enter the budget amounts for each time period in question (usually
monthly budgets)
8.7. Save
8.8. Click the Create Journals button
8.9. Name a journal batch (make it meaningful)
8.10. Category: Budget
8.11. Funds Status: Required.
8.12. Click Check Funds button (concurrent request submitted).
8.13. Wait for completion of task.
8.14. Click Reserve Funds button (concurrent request submitted).
8.15. Wait for completion of task.
8.16. Click View Results to ensure proper status of above entries.
8.17. Click Done button to exit forms.
8.18 View Concurrent Requests to ensure successful completion of the above-
submitted concurrent requests.

9) Post Journal Entries (GL)
9.1. Navigation in GL: Journals -> Post
9.2. Find Balance Type: Budget
9.3. Select the journal entry batches you entered for posting by enabling
the check box
9.4. Click the Post button; this submits a concurrent request.

10) Review Posted Entries (GL)
10.1. Navigation in GL: Inquiry Account
10.2. Select Accounting Period From/To
10.3. Alternate Region: Primary Balance Type
10.4. Actual: yes
10.5. Alternate region: Secondary Balance Type
10.6. Budget: Yes
10.7. Budget: Select the budget from the LOV.
10.8. Click in the account field for account range.
10.9. Click the Show Variance button.
10.10. The account should show the budgets as defined with an actual of $0.



RELATED DOCUMENTS
-----------------

Note 121858.1 Purchasing Encumbrance Accounting Concepts and Process Model


.

1. Physical inventory

Physical inventory is a process to count all items in selected subinventories or all subinventories for an organization. A physical inventory may be defined for a single subinventory, selected subinventories, or an entire inventory organization. Subinventories must be defined as “Quantity Tracked” to be included in a physical inventory. A physical inventory assumes that all on-hand balances within the scope of the physical inventory will be counted.

The physical inventory process takes a snapshot of the on-hand balances, and generates tags for all items with an on-hand balance. Counts are recorded against the tag number and compared to the snapshot quantity. Deltas between the snapshot quantity and the counted quantity will generate adjustment transactions.

Physical inventory counts are generally performed at the end of a fiscal year, although you may create a physical inventory and perform a count at any time. When a count is being performed, material movement transactions may continue, but should be limited and controlled if an accurate count is to be assured. The physical count is compared to a snapshot or frozen on-hand balance quantity, so material movements should not be done from the time the snapshot is taken until the count is completed.

Scenario: Place five items into your subinventory to use for a physical inventory.

Step1: Perform Miscellaneous transactions for four items into Subinventory SCRAP to use for a physical inventory in FGI Organization

Navigation: Inventory > Transactions > Miscellaneous Transaction

Screen: Miscellaneous Transactions (FGI)


Fields Values
Date (Take the default)
Type Miscellaneous receipt
Source Blank
Click on Transaction Lines Button
Note: Enter all items before saving.
Miscellaneous receipt screen Appears
Item 3000988
Subinventory SCRAP
Lot
Quantity 125
UOM (Take the default)
Account Dummy
Press the down arrow key
Item 3000991
Subinventory SCRAP
Account Dummy
Quantity 72
UOM (Take the default)
Press the down arrow key
Item 3001060
Subinventory SCRAP
Account Dummy
Quantity 87
UOM (Take the default)


Item 3001010
Subinventory SCRAP
Account Dummy
Quantity 112
UOM (Take the default)

Press the down arrow key
Click on the Save icon
Close the Windows



Step2: Define Physical Inventory and make an Inventory Snapshot. Use the Physical Inventories window to: Setup a physical inventory definition for your subinventory.


Navigation: Inventory > Counting > Physical Inventory > Physical Inventories

Screen: Physical Inventories Summary (FGI)

Region Fields Values
Click on New Button
Define Physical Inventory Screen Appears
Name TEST1
Description Test1 Physical Inventory
Date (Take the default)
Tab to the Approval Area
Approvals Required Select: If Out of Tolerance
Quantity +10% and -10%
Value +10% and -10%
Tab to the Count Subinventories Area
Count Subinventories Specific Check the Box
Subinventory SCRAP
Allow Dynamic Tags Uncheck the Box
Click on Snapshot button

• Record the concurrent request # ___________________
• Click OK
• Close the Define Physical Inventory screen
• Close the Physical Inventory Summary screen
• Go to the View menu and select Requests
• Click on the Find button in the Find Requests screen
• Verify your concurrent request completes normally
• Close the Requests screen

Step3: Generate Tags. Use the Tag Generation window to: Generate default tags for your physical inventory definition.

Navigation: Inventory > Inventory Counting > Physical Inventory > Tag Generation

Screen: Generate Physical Inventory Tags (FGI)

Region Fields Values
Name TEST1
Description Test1 Physical Inventory
Date (Take the default)
Tag Type Select Default
Show Serial on Tags Leave Checked
Tab to the Tags Area
Tags Starting Tag TXX001
Digit Increments 000111 (Defaults)
Ending Tag System calculated
Number of Tags System calculated
Click on Generate button

• Record the concurrent request # ___________________
• Click OK
• Close the Generate Tags screen
• Go to the View menu and select Requests
• Verify your concurrent request completes normally and close the window.

Step4: Enter Counts Use the Tag Counts window to: Enter tag counts using the default tags.

Navigation: Inventory > Inventory Counting > Physical Inventory > Tag Counts

Screen: Physical Inventory Tag Counts (FGI)

Region Fields Values
Name TXX-PHYS
Click on the Find button
Click on Yes on Decision Box
Use arrow keys to move from line to line and enter a count for each item
3000988 100
3000991 111
3001060 125
3001010 60
Click on the Save icon
Close the window.

Step5: Approve the Adjustments.
Use the Approve Physical Adjustments Summary window to: Approve all the adjustments.

Navigation: Inventory > Inventory Counting > Physical Inventory > Approve Adjustments

Screen: Approve Physical Adjustment Summary (FGI)



Region Fields Values
Name TEST1
Click on the Find button
Click No on Decision Box
Click on the Approve All button
Click on the Save icon
Close the window.

Step6: Launch the Adjustments Program
Use the Physical Inventories Summary window to: Adjust the physical inventory quantities.


Navigation: Inventory > Inventory Counting > Physical Inventory > Physical Inventories

Screen: Physical Inventory Summary (FGI)


Fields Values
Click on the line which lists your Physical Inventory TEST1
Go to the Tools Menu and select: Launch Adjustments

The Launch Adjustments screen will open
Adjustment Account Variance account
Click on the Launch Adjustments button

• Record the concurrent request # ___________________
• Click OK
• Close the Physical Inventory Summary screen
• Go to the View menu and select Requests
• Verify your concurrent request completes normally and close the window.


Step7: Physical Inventory Report.
Use the Request Window to: Run the Physical Inventory Accuracy Analysis report

Navigation: Inventory > Reports > ABC and Counting

• Select Single Request in the dialog box and click OK.
• Select the report name: Physical Inventory Accuracy Analysis.
• Enter the name of your physical inventory definition “TEST1”
• Click on OK and then Submit.

• Record the concurrent request # ___________________
• Click on No.
• Go to the View menu and select Requests.
• Verify your concurrent request completes normally .
• Click on the line which lists your request.
• Click on the View Output button to review the report.
• Close the report output window and the requests screen.

Step8: Purge Physical Inventory
Use the Physical Inventories window to: Run the physical inventory purge program

Navigation: Inventory > Counting > Physical Inventory > Physical Inventories

Screen: Physical Inventories Summary (FGI)

• Click on the line which lists your Physical Inventory TEST1

• Click on Open Button to verify that the Adjustment Posted box is checked
• Go to the Tools Menu and select: Perform Purge

The Perform Purge screen will open

Select: All in the dialog box.
Click on the Purge button.

Record the concurrent request # __________________.
Click OK.

Close the Physical Inventory Summary screen.

Go to the View menu and select Requests.
Verify your concurrent request completes normally and close the window.

Reopen the Physical Inventories Summary screen to verify the purge has removed your definition “TEST1”.

Good training articles

Good training articles


Good training articles are available on below site. We thank and appreciate the person involved in this work.

http://getappstraining.blogspot.com


Happy learning and knowledge sharing.

Difference between Discrete-Process and Flow Manufacturing

Difference between Discrete, Process and Flow Manufacturing:

This post contains links to where you can find explanations on these types of manufacturing which will enable you to determine the difference between them.
ITtoolbox has a good article entitled Difference Between Discrete and Flow Manufacturing which is worth taking a look at. Oracle’s Manufacturing Page explains how each of these modules works and contains product data sheets you can download.
A brief outline of each of the modules capabilities per the site is outlined below:

Discrete Manufacturing

Oracle Discrete Manufacturing helps you manage the entire product lifecycle for discrete manufacturing processes, from initial design and engineering through work-in-process to cost and quality management. Minimize costs and cycle times while supporting efficient mass customization as well as build-to-order and project-based manufacturing methodologies.

Flow Manufacturing

Oracle Flow Manufacturing supports the entire build-to-order manufacturing process, including make-to-stock, configure-to-order, discrete-repetitive, assemble-to-order, and engineer-to-order. Initiate schedules as soon as customer orders are complete, and ensure shipment as soon as build is complete. Results include shorter cycle times, balanced production, reduced inventory costs, and improved product quality.

Process Manufacturing

Oracle Process Manufacturing automates the entire product lifecycle for recipe-based manufacturing, from new product development, recipe management and production, to cost, quality, and regulatory management. It enables you to formulate products to individual customer specifications, manage variability, optimize capacity, and drive continuous process improvement.


Thanks for reading.

If PR stuck in work flow then how to retry it

If PR stuck in work flow then how to retry it:

Save below script as name wfretry in C directory of your conmputer

rem HEADERrem $Header: wfretry.sql 110.0 97/07/22 16:34:45 appldev ship $rem NAMErem wfretry.sql - WorkFlow Handle error'ed activityrem USAGErem @wfretry rem DESCRIPTIONrem Displays a list of errored activityes for the indicated item.rem Type in the name of the activity, and command to skip, retry, or reset.
set verify off
define item_type='&1'define item_key='&2'
prompt Select from list of error activitiesselect pa.instance_label Label, ias.activity_result_code Resultfrom wf_item_activity_statuses ias, wf_process_activities pawhere ias.item_type = '&item_type'and ias.item_key = '&item_key'and ias.process_activity = pa.instance_idand ias.activity_status = 'ERROR';/accept activity prompt "Label: "
prompt SKIP, RETRY or RESET activity? accept comflag prompt "Command: "
prompt Result of activity if command is SKIPaccept result prompt "Result: "
begin Wf_Engine.HandleError('&item_type', '&item_key', '&activity', '&comflag', '&result');end;/set verify on


Now follow below steps

1. Run the script
@C:\wfretry;

2. Enter value for 1:
&WF_ITEM_TYPE= REQAPPRV

Enter value for 2:
&WF_ITEM_KEY= 112843-226248(will be different for different PR)
(Can get above value by running below script
select segment1,ORG_ID,WF_ITEM_TYPE,WF_ITEM_KEY,AUTHORIZATION_STATUS from po_requisition_headers_all where segment1= 84701)

3.Label: MAIN_REQAPPRV_PROCESS
SKIP, RETRY or RESET activity?
Command: RETRY
Result of activity if command is SKIP
Result:

PL/SQL procedure successfully completed
4. Commit;

Form personalization process and examples

Dear Friends,

I will add some examples of form personalization. Some I have created and some i got from various blog sites. I will try to put as explainatory as I can.

Coming soon.....

Regards,
Kutub

Understanding ERP

Understanding ERP
Suppose you are running a small grocery shop. So the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and stocked it in your shop.
Ocassionally you may not be carrying items or run out of stock that people ask for so you make a note of it and promise the person to come back tomorrow and they will get their item. So far so good, now lets name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor, the people who come to your shop to buy things are known as customers, the stock in your shop is known as inventory.

So far we have identified few entities that play an active role in your day-to-day operations. As time goes by, your business expands and now you take orders over the phone and provide service to deliver the items to your customers, so you hire people to help you out in maintaining the inventory, do the delivery part and all the necessary stuff to keep the business running smoothly. The people you hire are known as employees.

So in this small shop, you typically manage the bookkeeping activities by hand using a notepad or something similar. Now imagine the same setup on a larger scale where you have more than 10,000 customers, have more than 1000 vendors, have more than 1000employees and have a huge warehouse to maintain your inventory. Do you think you can manage all that information using pen and paper? Absolutely not possible! Agree?

To facilitate big businesses, companies like Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications. Now coming to think of it, Oracle Applications is not one huge software, instead it is a collection of software known as modules that are integrated and talk to each other.

Now what is meant by integrated? First let us identify the modules by entities. For e.g Purchasing and Account Payables deal with the vendors since you typically purchase from vendors and eventually have to pay the dues. Oracle Purchasing handles all the requisitions and purchase orders to the vendors whereas Oracle Accounts Payables handles all the payments to the vendors.

Similarly Oracle Inventory deals with the items you maintain in stock, warehouse etc. Dealing with customers is handled collectively with the help of Oracle Receivables and Oracle Order Management. Order Management helps you collect all the information that your customer is ordering over the phone or webstore etc whereas Receivables help you collect the money for the orders that are delivered to the customers.

Now who maintains the paychecks, benefits of the 1000 employees? It is managed by Oracle Human Resources. So by now you might have got an idea - for each logical function there is a separate module that helps to execute and maintain that function.
So all the individual functions are being taken care but how do I know if I am making profit or loss? That’s where integration comes into play. There is another module known as Oracle General Ledger. This module receives information from all the different transaction modules and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc.

To simplify, when you pay your employees that payment is reported back to General Ledgers as cost i.e money going out, when you purchase inventory items the information is transferred to GL as money going out, and so is the case when you pay your vendors. Similarly when you receive items in your inventory it is transferred to GL as money (i.e. a form of money) coming in, when your customer sends payment it is transfered to GL as money coming in. So all the different transaction modules report to GL (General Ledger) as either “money going in” or “money going out”, the net result will tell you if you are making a profit or loss.

All the equipment, shops, warehouses, computers can be termed as Assets and they are managed by Oracle Fixed Assets. Initially Oracle Applications started as bunch of modules and as time passed by they added new modules for different and new functions growing to meet the needs of today's global business corporations

(Source:from internet)

Purchasing Setup Checklist

Purchasing Setup Checklist
1. Define set of books
2. Define descriptive flexfields
3. Define organizations
4. Define cross-reference types
5. Define profile options
6. Define financials options
7. Define accounting flexfield combinations
8. Define tax names
9. Define payment terms
10. Open and close General Ledger (GL) accounting periods
11. Open purchasing and inventory accounting periods
12. Define locations
13. Define location associations
14. Define job flexfield
15. Define jobs
16. Define position flexfield
17. Define positions
18. Define position hierarchies
19. Enter employee
20. Define item categories flexfield
21. Define category
22. Define category sets
23. Define default category set
24. Define control rules and groups
25. Define position controls
26. Fill employee hierarchy
27. Define usernames
28. Define purchasing lookup codes
29. Define freight carriers
30. Define inspection codes
31. Define hazard classes
32. Define United Nations (UN) numbers
33. Define standard notes
34. Define unit of measure classes
35. Define units of measure
36. Define unit of measure conversions
37. Define system items flexfield
38. Define item attribute controls
39. Define item templates
40. Define item catalog flexfield
41. Define item catalog groups
42. Define buyers
43. Define item
44. Define item relationships
45. Define line types
46. Define document controls
47. Start autosubmit
48. Define purchasing options
49. Define receiving options
50. Enter vendors
51. Define your transactions reasons
52. Set up Oracle Workflow
53. Request your receiving transaction processor
54. Define your concurrent process resubmission interval

Item upload thru Item interface

Item upload thru Item interface:

1. Gather all your data in excel sheet.

2. We need to enter data in the table mtl_system_items_interface. Below is the statement.(Here extra dta are entered but can be increase or decrease more data but some mandatory are to be needed.

insert into mtl_system_items_interface(item_number,description,transaction_type,organization_id,organization_code,unit_weight,weight_uom_code,
primary_unit_of_measure,attribute_category,process_flag,set_process_id,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,attribute12,attribute13,attribute14,attribute15)

3. To enter the data in the table best way is to first enter data in the customised table and then insert in the mtl_system_items_interface table.

Below is the example:

create table X

(ITEM VARCHAR2(200),
DESCRIPTION VARCHAR2(300),
TRANS VARCHAR2(200),
ORGID VARCHAR2(200),
ORGCODE VARCHAR2(200),
UNIT_WEIGHT VARCHAR2(200),
WEIGHT_UOM_CODE VARCHAR2(200),
PRIMARY_UNIT_OF_MEASURE VARCHAR2(200),
ATTCAT VARCHAR2(200),PROFLAG VARCHAR2(200),
SETPROID VARCHAR2(200),
ATTRIBUTE1 VARCHAR2(200),
ATTRIBUTE2 VARCHAR2(200),
ATTRIBUTE3 VARCHAR2(200),
ATTRIBUTE4 VARCHAR2(200),
ATTRIBUTE5 VARCHAR2(200),
ATTRIBUTE6 VARCHAR2(200),
ATTRIBUTE7 VARCHAR2(200),
ATTRIBUTE8 VARCHAR2(200),
ATTRIBUTE9 VARCHAR2(200),
ATTRIBUTE10 VARCHAR2(200),
ATTRIBUTE11 VARCHAR2(200),
ATTRIBUTE12 VARCHAR2(200),
ATTRIBUTE13 VARCHAR2(200),
ATTRIBUTE14 VARCHAR2(200),
ATTRIBUTE15 VARCHAR2(200))

Data can be enter in the table X through below command:@C:\Prod_All_length_items.txt;

where the Prod_All_length_items.txt is a text file stored in the c drive containg all the rows to be inserted in the table X in below format

Insert into Length_Items values('AL100-100-10-10*CA*R','ANGLE 100MM X 100MM X 10MM, ASTM A572 GR50 X MM','CREATE','230','CAN','CAN Length
Raw Material','15','KG','Millimeter','CAN','1','88888','15','L100X100X10','ASTM A572 GR50');

Then insert data as below statement:
insert into mtl_system_items_interface(item_number,description,transaction_type,organization_id,organization_code,unit_weight,weight_uom_code,
primary_unit_of_measure,attribute_category,process_flag,set_process_id,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,attribute11,attribute12,attribute13,attribute14,attribute15)select * from x

4. After data are entered in the mtl_system_items_interface check the data

select * from mtl_system_items_interface.

5. To import the items follow the below navigation

Under Inventory responsibility:

Items-->Import--> Import Items
In the parameter all will be default except Process set. Enter Set_process_id value which was entered in the mtl_system_items_interface.
The last parameter is by default 1 which is for creating new item. If you want to update existing one enter value 2 here.

6. After completion the request see the log if any error is there. Correct that fault and update the process flag as 1 in the mtl_system_items_interface table and again import the items.

Error can be seen in the below table also:
select * from MTL_INTERFACE_ERRORS

update mtl_system_items_interfaceset process_flag=1where organization_id=230

7. Before creating items in the child org first item must be created in master org then same process must be followed for other organization by simply updating the org_id in the mtl_system_items_interface table.

Category Updation for existing item thru interface:

1. Arrange data in the correct format.

2. We need to enter data in the table MTL_ITEM_CATEGORIES_INTERFACE. Below is the statement.(Here extra data are entered but can be increase
or decrease more data but some mandatory are to be needed.

insert into MTL_ITEM_CATEGORIES_INTERFACE(inventory_item_id,category_set_id, category_id,process_flag,organization_id,OLD_CATEGORY_ID,set_process_id, transaction_type)values('341980',1,1136,1,22,1135,88888,'UPDATE')
insert into MTL_ITEM_CATEGORIES_INTERFACE(item_number,category_set_id, category_id,process_flag,organization_id,OLD_CATEGORY_ID,set_process_id, transaction_type)values('20-01*16*PC',1,1135,1,22,1136,88888,'UPDATE')

3. To import the items follow the below navigation
Under Inventory responsibility:
Items-->Import--> Item Category Assignment Open Interface
In the parameter all will be default except Record set id. Enter Record set id value which was entered in the MTL_ITEM_CATEGORIES_INTERFACE as set_process_id.

create table CAT_INT
( item_number VARCHAR2(200),
CATEGORY_NAME VARCHAR2(200),
category_set_id VARCHAR2(300),
process_flag VARCHAR2(200),
organization_id VARCHAR2(200),
OLD_CATEGORY_ID VARCHAR2(200),
set_process_id VARCHAR2(200),
transaction_type VARCHAR2(200))

insert into CAT_INT values ('35-05*723*PC','20.MP FITTING.RF-3',1,1,22,1,88888,'UPDATE');

Profile options need to set at responsibility level for a responsibility in a multi org environment

Profile options need to set at responsibility level for a responsibility in a multi org environment:

1. GL Set Of Books ID
2. GL Set of Books Name
3. HR: Security Profile
4. HR:Business group
5. HR:User Type
6. MO: Operating Unit
   

Introduction- Bismillah

I am creating this blog to share and improve knowlege on oracle ERP. And yes I will share possible enhancement which can be done in Oracle.