Address Number Violation on Receipt Entry form

[GauriP24]

We have develeloped the customozied Cash Receipts Entry form on the similar lines of P03B102, while executing the same, when i bring the open reciepts from 'Select Invoices' form, the system gives me error saying " Address Number-Invalid" and "Address No has an invalid data dictionary value" I debugged the form extensively but no luck. i changed the jde.ini settings it shows that its choosing next no NN001 from f002 and chaeking for its presence in address book, where it gets error, seomebody please guide me. The part of debug log is as follows,

Aug 28 14:59:40 ** 3824/464 *** End dumping data structure for business function IsColInCurrencyCodeTable
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 Return value is 0 for IsColInCurrencyCodeTable. (BSFNLevel = 1)
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitUser with commit mode 0.
Aug 28 14:59:40 ** 3824/464 Entering JDB_BeginTransaction
Aug 28 14:59:40 ** 3824/464 Entering JDB_OpenTable( Table = F0002)
Aug 28 14:59:40 ** 3824/464 Entering JDB_FetchKeyedForUpdate
Aug 28 14:59:40 ** 3824/464 ORACLE DBInitReq conn=050C63A8 requ=05354008 db2 (jdev) new
Aug 28 14:59:40 ** 3824/464 SELECT CRPCTL.F0002.*, ROWID FROM CRPCTL.F0002 WHERE ( NNSY = '01' ) FOR UPDATE OF NNN001, NNN002, NNN003, NNN004, NNN005, NNN006, NNN007, NNN008, NNN009, NNN010
Aug 28 14:59:40 ** 3824/464 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Aug 28 14:59:40 ** 3824/464 Entering JDB_UpdateCurrent
Aug 28 14:59:40 ** 3824/464 ORACLE DBInitReq conn=050C63A8 requ=052930C8 db2 (jdev) new
Aug 28 14:59:40 ** 3824/464 UPDATE CRPCTL.F0002 SET NNN001=40020124.000000,NNN002=0.000000,NNN003=0.000000,NNN004=0.000000,NNN005=0.000000,NNN006=0.000000,NNN007=0.000000,NNN008=0.000000,NNN009=0.000000,NNN010=0.000000 WHERE ROWID = :LASTROWID
Aug 28 14:59:40 ** 3824/464 ORACLE DBFreeReq conn=050C63A8 requ=052930C8 DROP
Aug 28 14:59:40 ** 3824/464 Entering JDB_CloseTable(Table = F0002)
Aug 28 14:59:40 ** 3824/464 Entering JDB_ClearSequencing
Aug 28 14:59:40 ** 3824/464 Entering JDB_ClearSelection
Aug 28 14:59:40 ** 3824/464 ORACLE DBCommitCon envr=02FED7C0 conn=050C63A8
Aug 28 14:59:40 ** 3824/464 ORACLE DBFreeReq conn=050C63A8 requ=05354008 DROP
Aug 28 14:59:40 ** 3824/464 ORACLE DBCommitCon envr=02FED7C0 conn=050C63A8 (implicit for free connect)
Aug 28 14:59:40 ** 3824/464 Entering JDB_ClearBuffers
Aug 28 14:59:40 ** 3824/464 Exiting JDB_ClearBuffers with success.
Aug 28 14:59:40 ** 3824/464 Exiting JDB_CloseTable(Table = F0002) with Success
Aug 28 14:59:40 ** 3824/464 Entering JDB_FreeUser
Aug 28 14:59:40 ** 3824/464 Entering JDB_AuditingOn
Aug 28 14:59:40 ** 3824/464 Exiting JDB_AuditingOn with success
Aug 28 14:59:40 ** 3824/464 Calling Business function IsColumnInAddressBook for HIMGAURIK. Application Name [P58AC260], Version [FI00001] (BSFNLevel = 1)
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 *** Start dumping data structure for business function IsColumnInAddressBook
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 IN->[ 1] <Item>: idBhvrErrorId <type>: ID <Value>: [9999]
Aug 28 14:59:40 ** 3824/464 IN->[ 2] <Item>: szBehaviorEditString <type>: STRING <Value>: [40020123]
Aug 28 14:59:40 ** 3824/464 IN->[ 3] <Item>: szDescription001 <type>: STRING <Value>: []
Aug 28 14:59:40 ** 3824/464 IN->[ 4] <Item>: mnAddressnumber <type>: MATH_NUMERIC <Value>: [40020123]
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 *** End dumping data structure for business function IsColumnInAddressBook
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitBhvr
Aug 28 14:59:40 ** 3824/464 Entering JDB_OpenTable( Table = F0101)
Aug 28 14:59:40 ** 3824/464 Entering JDB_FetchKeyed
Aug 28 14:59:40 ** 3824/464 ORACLE DBRsetReq conn=0249AF70 requ=0522C478 db2 (jdev)
Aug 28 14:59:40 ** 3824/464 SELECT * FROM CRPDTA.F0101 WHERE ( ABAN8 = 40020123.000000 )
Aug 28 14:59:40 ** 3824/464 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 100
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitUser with commit mode 0.
Aug 28 14:59:40 ** 3824/464 Entering JDB_BeginTransaction
Aug 28 14:59:40 ** 3824/464 Entering JDB_FreeUser
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitUser with commit mode 0.
Aug 28 14:59:40 ** 3824/464 Entering JDB_BeginTransaction
Aug 28 14:59:40 ** 3824/464 Entering JDB_FreeUser
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitUser with commit mode 0.
Aug 28 14:59:40 ** 3824/464 Entering JDB_BeginTransaction
Aug 28 14:59:40 ** 3824/464 Entering JDB_FreeUser
Aug 28 14:59:40 ** 3824/464 Entering JDB_CloseTable(Table = F0101)
Aug 28 14:59:40 ** 3824/464 Entering JDB_ClearSequencing
Aug 28 14:59:40 ** 3824/464 Entering JDB_ClearSelection
Aug 28 14:59:40 ** 3824/464 ORACLE DBFreeReq conn=0249AF70 requ=0522C478 CLOSE
Aug 28 14:59:40 ** 3824/464 Entering JDB_ClearBuffers
Aug 28 14:59:40 ** 3824/464 Exiting JDB_ClearBuffers with success.
Aug 28 14:59:40 ** 3824/464 Exiting JDB_CloseTable(Table = F0101) with Success
Aug 28 14:59:40 ** 3824/464 Entering JDB_FreeBhvr
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 *** Start dumping data structure for business function IsColumnInAddressBook
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 OUT->[ 1] <Item>: idBhvrErrorId <type>: ID <Value>: [9999]
Aug 28 14:59:40 ** 3824/464 OUT->[ 2] <Item>: szBehaviorEditString <type>: STRING <Value>: [40020123]
Aug 28 14:59:40 ** 3824/464 OUT->[ 3] <Item>: szDescription001 <type>: STRING <Value>: []
Aug 28 14:59:40 ** 3824/464 OUT->[ 4] <Item>: mnAddressnumber <type>: MATH_NUMERIC <Value>: [40020123]
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 *** End dumping data structure for business function IsColumnInAddressBook
Aug 28 14:59:40 ** 3824/464 **********************************************************************************
Aug 28 14:59:40 ** 3824/464 Return value is 2 for IsColumnInAddressBook. (BSFNLevel = 1)
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitUser with commit mode 0.
Aug 28 14:59:40 ** 3824/464 Entering JDB_BeginTransaction
Aug 28 14:59:40 ** 3824/464 Entering JDB_InitUser with commit mode 0.
Aug 28 14:59:40 ** 3824/464 Entering JDB_BeginTransaction
Aug 28 14:59:40 ** 3824/464 Entering JDB_FetchKeyed
Aug 28 14:59:40 ** 3824/464 ORACLE DBRsetReq conn=03043850 requ=05353A78 db2 (jprd)
Aug 28 14:59:40 ** 3824/464 SELECT * FROM DD7333.F9207 WHERE ( FRDTAI = '019T' )
Aug 28 14:59:40 ** 3824/464 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 100


The no **40020123** is nowhere in address book, i am unable to understand from where did this trigger is getting executed and why is it taking next no value and checks it inaddress book, please tell me the solution

Help is greatly appreciated !!!!

 

[lagerboy1]

Not knowing your custom app, it could be the FC Address Field has next numbering still turned on which is why it is accessing the NN function. You can turn it off in the application by sleecting the field and the overrides button

 

[Gov]

I agree with lagerboy1. Due to NN on, on your FC address number. It will assign a new number for every run of application. But this new number assigned to your FC will be not be in F0101. So it is throwing the error. Please override your FC Address Number by disabling Next Number in Override Options. This will take care of your issue.

 

[Zoltan_Gyimesi]

Hi Salik,

Maybe (I suppose) disabling Next Numbering on FC Address Number won't solve your problem, but disabling Editing on that FC hopefully will solve.

Read you later,

Zoltán
P.S.:
The attachment is much more appropriate place for long and large logs, then in body of the post.

 

[Gov]

Zoltán,

You are correct. Overriding 'Editing' will stop throwing error message. But I think still it will display Next Number with form control. If we override both, that could be the better solution.

 

[GauriP24]

Hi Gov, Zoltan, lagerboy1 ......Thanks for your help!!!!
I checked the override "Edit Rules" to disable the trigger and it worked....

Thanks a lot again!!! I really appreaciate ur help!!!