Skip to main content
Question

Customer Check Migration Job

  • 6 November 2020
  • 1 reply
  • 279 views

WSHAH
Do Gooder (Customer)
Forum|alt.badge.img+8
  • Do Gooder (Customer)

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

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • November 8, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings