This discussion is archived
1 Reply Latest reply: May 2, 2013 10:15 AM by JasonBatzlaff RSS

URGENT:How the orig_sys_ref column is created in cz_ps_nodes

1006670 Newbie
Currently Being Moderated
Hi,

I am importing the data from cz_imp_ps_nodes to cz_ps_nodes.for this import,the value for orig_sys_ref column is mandatory so just wanted to know how this value is created.
What is the souce of this column.

Best Regards,
AJ

Edited by: 1003667 on May 2, 2013 1:07 AM
  • 1. Re: URGENT:How the orig_sys_ref column is created in cz_ps_nodes
    JasonBatzlaff Explorer
    Currently Being Moderated
    When you are importing a BOM from Oracle EBS, the value might look something like this:

    60802-61393-61234:OPTIONAL:84:60802

    This string breaks down as follows:

    COMPONENT_CODE: 60802-61393-61234
    EXPLOSION_TYPE: OPTIONAL
    ORGANiZATION_ID: 84 (for the related imported model)
    INVENTORY_ITEM_ID: 60802 (for the related imported model)

    Component Code is a delimited string showing the parent-child relationship. in the example above, I show "60802-61393-61234"

    Where:

    60802 = Top Imported Model
    61393 = Option Class Item Item
    61234 = Inventory Item Id of the component in the option class.


    As far as I know, this field just needs to be unique. The method above is how Oracle EBS ensure uniqueness for an imported BOM. I am not absolutely positive, but I doubt that this column is used for any other purposes. I imagine it is there to unsure that the same set of items are not duplicated for the same project.

    In your case, just make sure that you generate a Unique String for each node that you import for a specific model.

    Thanks,
    Jason

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points