Where does Absolute Occurrence attribute information is stored in Database?

[Mani_D]

Hi there,

I am eager to know the information of the tables in which the absolute occurrence attribute information (or in-context occurrence) is stored in the database.

I am using Teamcenter 11.2.2.1 currently.

Thanks in advance.

[Mahendra · Accepted solution]

Hello,

I wouldnt really suggest to dig into database tables.

In your case, it really depends on what kind of occurrence details you are looking for.

There are couple of tables which are all sub classes of PABSOCCDATA. You can get the their names from BMIDE.

e.g., quantity details can be fetched from PAbsOccQuantity table.

you may need other occurrence related tables to actually get the context of the information in these tables

Regards

Mahendra

[Mani_D]

Hi,

Thanks for your quick reply. I will look into the below suggested tables to find the related information that I need.

Regards,

Manikanta

[Iggy]

Hi,

I need to be able distinguish an absolute occurrence note from a regular occurrence note with ITK functions.

I was not able to see where this information is residing in the BOMline properties.

Using tcxml utility it looks like it has to do with AbsOccData object.

Goal: The program applies an occurrence note tag (in context) only when there is no prior occurence tag in the same context. It does work great when field is empty or already has a tag in context (of the BOM head).

Issue: If there is already an occurrence note (with no context) it does not apply the tag (where it should add a tag).

Do you know how I can check whether an occuremce note tag is in the context or not from ITK functions?

Thank you

[LC_MAYA]

@Iggy 

I need to write ITK code the manages absolute occurrence notes values.

Have you found how to know if an occurrence note value is in context and what the context is? Also, how to write a value to an occurrence note in a specific context?

Thanks

[jonathan_morris]

Apologies for the late reply.

There are a few BOMLine properties that can help you determine this:

bl_properties_in_context - This returns a comma-separated string of the internal property names of the overridden properties.  So if you have an in-context note JM4_Note and you also override the occurrence type you would get a string like JM4_Note,bl_occ_type

bl_property_context_tags - This returns an array of context node BOMLine tags that specify the context node for each of the property overrides.

bl_property_overrides - This returns an array of strings of the format <BOMLine property name>;<Context Node UID>;0  The BOMLine property is as before, so JM4_Note, or bl_occ_type.  The Context Node UID is the runtime BOM uid, so something dynamic like BOM::86413.  You would need to parse this string, then turn the UID into a tag.  There are ITK calls for this.

These properties are set visible false in BMIDE, so you won't be able to see them directly in Structure Manager.

This is done as there will be a performance penalty for calculating them for every BOMLine.

You can however read them through the apis, including SOA.