Parts
Overview
Parts data includes part numbers, serial numbers, part associations and serial number associations. There are two ways you can create parts data: through a bulk upload process or through manual entry.
Parts Structure
Bulk Upload
You can enter parts, Price Book, serial number, and translation data through bulk upload. The formats supported for upload are XML and CSV. This process enables you to enter large batches of parts data into the system quickly. For more information, see the topic Bulk Uploads.
Manual Entry
Parts data can also be administrated manually. Within Parts Administration, you can also set the visibility level of BOMs (Bill of Materials) to regulate how much parts data buyers see.
The bulk upload process is recommended for entering large amounts of parts data. For small amounts of data, manual entry in the parts administration area may be faster. For more information, see the topic Managing Parts.
Administration
Accessing the Parts Search for Admin Page
- Click Admin to go to the Admin Home Page.
-
Click Parts in the Products section.
The Parts Search for Admin page opens.
Searching for Part Numbers
You can search for parts by using serial numbers or parts.
-
Navigate to the Parts Search for Admin page.
- Click Admin to go to the Admin Home Page.
-
Click Parts in the Products section.
The Parts Search for Admin page opens.
- Enter a value in either the Serial Number or Part Number field.
-
Click Search.
The Serial Number or Part Search Results page opens.
-
If you only know a partial part number, you can search by the first few characters. The search engine locates all parts starting with the characters entered.
For example, you can conduct a search using 123, and the search engine will find parts such as 12330, 12357, 123a1, and so on.
-
Click the expand icon
to see any Part or Serial Number associations.
Setting BOM Levels
The BOM level restricts how many levels of a BOM users can see. Set this option if you want to configure how many levels to show. By default, users can select up to 15 levels of BOM, which is the maximum number of levels.
BMQL and Language Parameters
Administrators can retrieve a specific translation of a Part Description using BMQL.
Specify language parameters using a local variable or attribute variable.
- If a language value is set, that value is returned
- If the value is blank, the site’s base language is called.
- If the BMQL query doesn’t contain a language parameter, the user’s session language is used.
NOTES
The maximum number of part records is 999,999,999,999,999,999 in the Oracle CPQ database.
Related Topics
See Also