GET_BIR_CONVERTED_VALUE - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon PPM

Intergraph Smart Materials Customization (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

Description:

This function returns a modified value for Business Intelligence Reporting in order to display Smart Materials data correctly in the reports. For example, you can remove linefeeds or replace double quotes with single quotes.

After each change of this CIP function, the BOM ident data must be re-created. To do this, proceed as follows:

  1. Launch a SQL*Plus session, and connect to the Business Intelligence Reporting - Smart Materials schema.

  2. Clear the bir_spmat_identdata table:

    truncate bir_spmat_identdata;

  3. Call the sync data script:

    begin

    bir_bi_functions.sync_data();

    end;

Type:

Function

Usage:

BIR

Event:

Data synchronization

Default:

replace(replace(p_invalue,chr(10),' '),chr(34),chr(39)||chr(39))