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

OM Order Info of respective ORDER_NUMBER in R12

 SELECT ood.organization_code           org_code,          ood.organization_name           org_name,          wdd.DELIVERY_DETAIL_ID        ...