ERPstuff - Oracle EBS Community

Hi All,

I have a query on building the location segment in Oracle Assets.

i believe a segment can be dependent upon only independent segment, am i correct in assuming that in the entire location flexfield only segment can be dependent and all other independent.

We are planning to have 7 segment defined.( Region-Country-State-City-Address-Building-Floor). Except Region client expects all other segments to be dependent upon the previous one. Can this be achieved?

Regards
Anurag

Hi,

It is achievable

But for it is recomended that not to use the dependent valueset in any of the key flexifields.

There is one more option of defining all the value sets independent and through combination you can control the same.

Thanks,
Shanmukh

Thanks Shanmukh for the reply.

Can you guide me in detail how it can be acheived.

Regards
Anurag

Hi,

while creating the value set for region you have to give as independent and for creating value set for other segments you have to change it to dependent

http://download.oracle.com/docs/cd/A607 ... /index.htm

Thanks,
Shanmukh

Hi,

refer the below link for creating dependent value sets

http://download.oracle.com/docs/cd/A607 ... m#ffmvsdep

Thanks,
Shanmukh