FA Auto Generate

, ,
1

For the inbound data into TN, an FA is generated Automatically (set the property to auto generate FA to true in inbound TPA).

I am getting the below error from the server

“com.wm.app.b2b.server.ServiceException: java.sql.SQLIntegrityConstraintViolationException: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into (“TN_ADMIN”.“EDICONTROLNUMBER”.“SENDERID”)”

After debugging the generateFA service.I found out that the sender and receiver ID qualifiers were not passed onto the getcontrolnumber service in build997 service in generateFA thus causing the above exception and creating group control number as 0000.

IS anybody able to create a group control number for a 997 by setting the autogenerate to ON in TPA.

am I missing a paratmeter?

Any help is greatly appreciated.

Thanks!

2

Need to add below property to the properties.cnf file in WmEDI

EDIAllowCustomControlNumberSequences=strictCompatibility

And this will allow the autogenerateFA service to get group control numbers with or
without qualifiers.

Thanks!