Oracle EBs Apps Blog of Mahfuz, OPM and OBIEE Consultant

Saturday 19 December 2020

Error : To Create OPM Batch, ORA-01400: Cannot insert null into .... in Package GME_BATCH_HEADER_DBL Procedure INSERT_ROW

First check calculate_step_quantity is null or not.

select * from gmd_recipes_b
where calculate_step_quantity is null

Sometimes, When uploaded Recipe using API, it will happen,

Solution is to update by bellow Script : 


update gmd_recipes_b
set calculate_step_quantity = 0  -- or = 1
where calculate_step_quantity is null

Here  0  is if no automatic_step_calculation needed &                                                                                            1 is if automatic_step_calculation 

 

No comments:

Post a Comment

Internal location is Already assigned to another Ship-to Address

      SELECT *   FROM hz_cust_accounts  WHERE ACCOUNT_NUMBER = 'R08'; -- CUST_ACCOUNT_ID =51401 , PARTY_ID= 235048    SELECT *   FRO...