Question

Customer Check Migration Job

  • 6 November 2020
  • 1 reply
  • 253 views

Userlevel 3
Badge +8
  • Do Gooder (Customer)
  • 42 replies

Dear All

 

I am trying to Migrate data in Customer Check windows on APP10 but facing error

 

ORA-20124: Error.NULLVALUE: Field [PAY_DATE] is mandatory for Payment and requires a value.

 

Manually column created PAY_DATE with sysdate as default value but still not working

 

Regards


1 reply

Badge +2

I believe this may be a bug.  Although PAY_DATE is a mandatory field in the relevant Customer Table, it has not been created as a Variable in the Function.  If you go into System Info and find the name of the API, go into SQL Developer and find the Package: *_API.new__ in the Package Body.

When you go thorugh this it should either point you to: *_API.new.  

Take a look at the Variables and PAY_DATE will not be one of them. 

You will need to raise with IFS as a bug, however to get around this issue you can do the following.

  1. Instead of Creating the DM as the View and Package, just enter the package name and append (*_API.New).  This should build your fields in the field list, withouit PAY_DATE.

 

If this doesnt resolve the issue then do the following.

  1. Open the Debug Console and create a new Customer in the “Customer Check” screen.  The debug console will show you the PL/SQL code to create this (will show as *_API.new).  Click on Copy Special and this will pull up the whole PL/SQL code.  Create this as a brand new API after making any necessary adjustments.  Then in the DM Tool, reference the new API.

Reply