Scribd
Upload
25 views2 pages

BOM Import Process Error Queries

The document contains SQL queries for retrieving data from the XXBBB_BOM_IMPORT_STG and XXBBB_BOM_ALT_ROUTE_IMPORT_STG tables, focusing on different process flags and error messages. It highlights issues with specific assembly items, particularly APEATH1121, which cannot be processed due to validation errors. Additionally, there are comments indicating various routing and item sequences related to the BOM process.

Uploaded by

Pavankumar Trvd
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
25 views2 pages

BOM Import Process Error Queries

The document contains SQL queries for retrieving data from the XXBBB_BOM_IMPORT_STG and XXBBB_BOM_ALT_ROUTE_IMPORT_STG tables, focusing on different process flags and error messages. It highlights issues with specific assembly items, particularly APEATH1121, which cannot be processed due to validation errors. Additionally, there are comments indicating various routing and item sequences related to the BOM process.

Uploaded by

Pavankumar Trvd
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

select

assembly_item_name,component_item_name,organization_code,process_flag,error_message
from xxbbb.XXBBB_BOM_IMPORT_STG
where process_flag='E'; and error_message not in('Duplicate Assembly, Component,
Altbill Record'); and assembly_item_name='ALFAF12015' order by
item_sequence_number;

select
assembly_item_name,component_item_name,organization_code,process_flag,error_message
from xxbbb.XXBBB_BOM_IMPORT_STG
where process_flag='S';

select
assembly_item_name,component_item_name,organization_code,process_flag,error_message
from xxbbb.XXBBB_BOM_IMPORT_STG
where process_flag='N';

select * from xxbbb.XXBBB_BOM_IMPORT_STG; where assembly_item_name='CTX010121';

select
assembly_item_name,component_item_name,organization_code,item_sequence_number,proce
ss_flag,error_message from xxbbb.XXBBB_BOM_IMPORT_STG where
assembly_item_name='MTC43428';

select
assembly_item_name,component_item_name,organization_code,item_sequence_number,proce
ss_flag,error_message from xxbbb.XXBBB_BOM_IMPORT_STG where error_message not like
('%, assembly item :% already exists in : BMD%');

select distinct count(*),assembly_item_name,error_message from


xxbbb.XXBBB_BOM_IMPORT_STG group by error_message;

select assembly_item_name,organization_code,process_flag,error_message from


xxbbb.XXBBB_BOM_ALT_ROUTE_IMPORT_STG; where process_flag in 'S';

select * from xxbbb.XXBBB_BOM_ALT_ROUTE_IMPORT_STG;


--routing BCD
--1,20,860
--2,654
--1,18,206

select 118206+2654 from dual;


--Global_PRIVATE_LBL_AND_KITTING
--47,113
--8,642
--38,471
select 8642+38471 from dual;
--Global_RBRND_FAR_MAP_RED_TRD.csv
--36,862

--Global_RBRND_CX_PLY_ALF_BCD
--v1
--79,926
--1,30,003

--v2
--2,02,831
You cannot create a revised component for revised item APEATH1121 when the revised
item is not BOM Allowed. Hence, a bill cannot be created for [Link] record was
not processed since a severe error occured while performing entity validations for
assembly item [Link] error occured while processing business object
APEATH1121 in organization BMD. Please check the data in this business object and
re-run the import process.

You might also like