Update the Component Value

After installing the OFS LLFP application, the component value must be updated for data to flow into the dim_gl_account table.

If the component value in the setup_master table that corresponds to the v_component_code for GL_ACCOUNT_HIER is Default, then modify this value to the correct general ledger hierarchy ID that is used in the subledger definition.

Note:

If the correct general ledger hierarchy ID is already present in the setup_master table that corresponds to the component code for GL_ACCOUNT_HIER,then there is no need to update the value.

The following is a sample query that can be used update the value:

Before executing this query, replace the text <GL Hierarchy Name> with the correct General ledger hierarchy name that is used or will be used in a subledger definition.

update setup_master

set v_component_value = (select object_definition_id

from fsi_m_object_definition_tl

where short_desc = '<GL Hierarchy Name>' )

where upper(v_component_code)='GL_ACCOUNT_HIER'

and upper(v_component_value) = 'DEFAULT' ;

commit;

After committing the above update, execute the batch <Infodom>_DIMENSION_DATA_POPULATION. This ensures that the general ledger hierarchy structure is used in the dim_gl_account reporting table.