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

RCV API

  DECLARE   ln_user_id      NUMBER;   ln_po_header_id NUMBER := 3319024; --1713998;   ln_vendor_id    NUMBER;   lv_segment1     VARCHAR2(20)...