Featured post

Functionality of Segment Value Inheritance ESS Process

  The Segment Value Inheritance process simplifies the maintenance of the chart of accounts. When the characteristics of values in the value...

Monday 21 November 2016

Item Cross References in Oracle Apps R12

Item Cross References in Oracle Apps R12

   
This post talks about the Front end navigations related to Item Cross References.
  1. How to create a cross reference type?
  2. Which form is used to assign the Item cross reference type and Items?
  3. How to define cross reference name for an item?
  4. Is there a standard report to show the list of cross references?

1.     How to create a cross reference type?

Cross Reference : This form can be used to capture the reference information pertaining to an item, like drawing number, vendor part number, etc.
This is available at Inventory >> Items >> Cross References



                      
In this form, user can define the list of cross references applicable for the Items. This list will be available at the Item master.


                     

2.      Which form is used to assign the Item cross reference type and Items?

New Cross reference label & description can be added in this form.

            

3.      How to define cross reference name for an item?

After defining a cross reference, the value can be assigned to items using ASSIGN button. Select the item from the LOV and applicable value for the cross reference can be defined at VALUE column. Org assigning feature also avialble in this form.
                            


After defining the Cross reference labels at the Cross Reference form, values for the labels can be assigned from Item Master form as well.

                       
 Query the Item record >> Tools menu >> Cross Reference >> Select the Cross Reference Type  >> Assign Values for the Cross Reference Labels >> Save



 4.      Is there a standard report to show the list of cross references?

There is report at Inventory to view the Cross Reference Listing by items.

Name of the Report : Item Cross-References Listing

Thats all folks!!!!  please provide your comments to improve our team and readers knowledge....

4 comments:

  1. Hi, customer cross reference we can see in Sales order line item level, what abt manufacturing cross-reference if I define where this effect will be visual?

    ReplyDelete
  2. In customer cross-reference "hello" is assigned to my internal items like A,B,C,D ;now when I try to enter the sales order if I give item like hello , associated items will appear iam hapoy , in the same way if I define manufacturing cross-reference, effect is where? Like PR/PO/BOM/WIP?

    ReplyDelete
  3. I need to see while entering my welcome associated items should be display.Plz help on to that

    ReplyDelete
  4. Hi,
    I am trying to uploaded orders via EDI via flat file. We have customer item name populated in flat file.
    Also have done item cross reference setup in oracle. Still i am not able to load order to oracle. its giving below error
    "Please enter required information - Inventory Item" can anyone help ?

    ReplyDelete

Please review my topic and update your comments

Note: only a member of this blog may post a comment.