InterCompany Solution

[former_member593872]

Hi All

I have validation stored procedures which worked before installing inter company after inter-company add on activation the stored procedures do not work, they are skipped or create errors now. Can this normal behavior for stored procedure written in HANA or there is a way to make them work again.

Please help has anyone come across this before?

[former_member186605]

Samuel, is it solved now?

Btw, are you using Intercompany PL31 already? Since we delivered a significant performance improvement you should consider this seriously, customers observe 40% increase in performance. Ref: SAP Note 2743003 - Performance improvement in SAP HANA DB environment

[former_member593872]

The issue above has been solved. I am using SAP Business One 9.3 PL06, version for SAP HANA and I see that the following versions are supported unless I getting it wrong.

This patch can be used to directly upgrade, update, or install from scratch the Intercompany integration solution 2.0.

Compatible SAP Business One versions (only these combinations of versions are approved and supported):

• SAP Business One 9.3 PL08
• SAP Business One 9.3 PL08, version for SAP HANA
• SAP Business One 9.3 PL09
• SAP Business One 9.3 PL09, version for SAP HANA

Kind Regards

[kvbalakumar · Accepted solution]

Hi,

It is not normal since we have HANA customers making use of SP for validation along with InterCompany.

It should be something specific to the code it is written.

Can you please share the code or some sort of sample code here?

Regards,

Bala

[former_member593872]

Hi All

Moving this SP to the Top of Validation helps"CTX_IC_SP_TRANSACTIONNOTIFICATION"

Regards

[former_member593872]

Hi Bala

I have the following code,

--Prevent Adding Item with serial number to any distribution code which does not end with _S --History - Created by SM 2019-04-09 IF :object_type = '4' AND (:transaction_type='A' or :transaction_type='U') THEN SELECT COUNT(T0."ItemCode") INTO err_count FROM OITM T0 WHERE T0."ItemCode" = :list_of_cols_val_tab_del AND T0."ManSerNum" = 'Y' AND T0."U_CTX_DSCD" NOT IN ( 'ITE_EC_S','ITE_KES_S' , 'ITE_KS_S'); IF :err_count > 0 THEN error := 01; error_message := 'BK - Select the correct Distribution code ending with **_S for Serialised item'; END IF; END IF; err_count :=0; -------------------------------------------------------------------------------------------------------------------------------- --Prevent Adding Item with Global item tick to add without to any distribution code assigned --History - Created by SM 2019-04-09 IF :object_type = '4' AND (:transaction_type='A' or :transaction_type='U') THEN SELECT COUNT(T0."ItemCode") INTO err_count FROM OITM T0 WHERE T0."ItemCode" = :list_of_cols_val_tab_del AND T0."U_CTX_REIC" ='Y' AND T0."U_CTX_DSCD" IS NULL; IF :err_count > 0 THEN error := 02; error_message := 'BK - Item is marked as a Global Item the Global Distribution Code cannot be blank '; END IF; END IF; err_count :=0;

-- Select the return values IF(:object_type !='410000000' ) Then CALL ""."CTX_IC_SP_TRANSACTIONNOTIFICATION"(object_type,transaction_type, num_of_cols_in_key,list_of_key_cols_tab_del,list_of_cols_val_tab_del,:error,:error_message ); End IF; select :error, :error_message FROM dummy; end;

[former_member593872]

Hi Bala

I have the following code,

--Prevent Adding Item with serial number to any distribution code which does not end with _S --History - Created by SM 2019-04-09 IF :object_type = '4' AND (:transaction_type='A' or :transaction_type='U') THEN SELECT COUNT(T0."ItemCode") INTO err_count FROM OITM T0 WHERE T0."ItemCode" = :list_of_cols_val_tab_del AND T0."ManSerNum" = 'Y' AND T0."U_CTX_DSCD" NOT IN ( 'ITE_EC_S','ITE_KES_S' , 'ITE_KS_S'); IF :err_count > 0 THEN error := 01; error_message := 'BK - Select the correct Distribution code ending with **_S for Serialised item'; END IF; END IF; err_count :=0; -------------------------------------------------------------------------------------------------------------------------------- --Prevent Adding Item with Global item tick to add without to any distribution code assigned --History - Created by SM 2019-04-09 IF :object_type = '4' AND (:transaction_type='A' or :transaction_type='U') THEN SELECT COUNT(T0."ItemCode") INTO err_count FROM OITM T0 WHERE T0."ItemCode" = :list_of_cols_val_tab_del AND T0."U_CTX_REIC" ='Y' AND T0."U_CTX_DSCD" IS NULL; IF :err_count > 0 THEN error := 02; error_message := 'BK - Item is marked as a Global Item the Global Distribution Code cannot be blank '; END IF; END IF; err_count :=0;

-- Select the return values IF(:object_type !='410000000' ) Then CALL ""."CTX_IC_SP_TRANSACTIONNOTIFICATION"(object_type,transaction_type, num_of_cols_in_key,list_of_key_cols_tab_del,list_of_cols_val_tab_del,:error,:error_message ); End IF; select :error, :error_message FROM dummy; end;