bsush
Active Member
Hi All
I am working on a issue in the P43060 app in E1 9.1. In local web (of FAT client) it is working correctly and the quantity is getting reduced (in Form A the entry point) after clicking on the "Generate Order" Form exit. The purchase order is also getting created in F4301 and F4311. However when I run P43060 on the server in DV910 the quantity is not getting reduced in Form A but the PO is getting created in F4301 and F4311. The server jdedebug.log shows the below:
**********************************************************************************
Jul 18 04:13:02.531000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering jdeCloseDictionary
Jul 18 04:13:02.531001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exited jdeCloseDictionary with DDType 0
Jul 18 04:13:02.531002 - 5236/3656 WRK:E191643_0950B1B8_P43060 Return value is 0 for UpdateF41021PrimaryLocationQty. BSFNLevel = 3)
Jul 18 04:13:02.531003 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering AddObjectCache
Jul 18 04:13:02.531004 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_OpenTable(Table = )
Jul 18 04:13:02.531005 - 5236/3656 WRK:E191643_0950B1B8_P43060 JDB9900307 - Failed to find table specifications
Jul 18 04:13:02.532000 - 5236/3656 WRK:E191643_0950B1B8_P43060 JDB3100007 - Failed to get valid table specifications
Jul 18 04:13:02.533000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_OpenTable(Table = ) with Failure
Jul 18 04:13:02.533001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_GetEnv
Jul 18 04:13:02.533002 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_GetEnv with Success
Jul 18 04:13:02.533003 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_InitUser with (AUTO commit mode)
Jul 18 04:13:02.533004 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_BeginTransaction (UserHandle 0699FDC8)
Jul 18 04:13:02.533005 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_BeginTransaction with Success (UserHandle 0699FDC8)
Jul 18 04:13:02.533006 - 5236/3656 WRK:E191643_0950B1B8_P43060 Incremented huser count to 5
Jul 18 04:13:02.533007 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_InitUser with Success (UserHandle 0699FDC8)
Jul 18 04:13:02.533008 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering jdeCloseDictionary
Jul 18 04:13:02.533009 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_FreeUser (UserHandle 0699FDC8)
Jul 18 04:13:02.533010 - 5236/3656 WRK:E191643_0950B1B8_P43060 Decremented huser count to 4
Jul 18 04:13:02.533011 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_FreeUser with Success(UserHandle 0699FDC8)
Jul 18 04:13:02.533012 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exited jdeCloseDictionary with DDType 0
Jul 18 04:13:02.533013 - 5236/3656 WRK:E191643_0950B1B8_P43060 ERROR INFO JDEERR - ID= 0, Error= 3143 - b4300360.c, Line= 431
Jul 18 04:13:02.534000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_FreeBhvr (UserHandle 0699B090)
Jul 18 04:13:02.534001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_FreeBhvr with Success(UserHandle 0699B090)
Jul 18 04:13:02.534002 - 5236/3656 WRK:E191643_0950B1B8_P43060
**********************************************************************************
In the above log patch the table for which the specs are not found is not appearing in the log.
Please help me figure out how to identify the missing table.
Thanks a Lot in advance.
I am working on a issue in the P43060 app in E1 9.1. In local web (of FAT client) it is working correctly and the quantity is getting reduced (in Form A the entry point) after clicking on the "Generate Order" Form exit. The purchase order is also getting created in F4301 and F4311. However when I run P43060 on the server in DV910 the quantity is not getting reduced in Form A but the PO is getting created in F4301 and F4311. The server jdedebug.log shows the below:
**********************************************************************************
Jul 18 04:13:02.531000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering jdeCloseDictionary
Jul 18 04:13:02.531001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exited jdeCloseDictionary with DDType 0
Jul 18 04:13:02.531002 - 5236/3656 WRK:E191643_0950B1B8_P43060 Return value is 0 for UpdateF41021PrimaryLocationQty. BSFNLevel = 3)
Jul 18 04:13:02.531003 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering AddObjectCache
Jul 18 04:13:02.531004 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_OpenTable(Table = )
Jul 18 04:13:02.531005 - 5236/3656 WRK:E191643_0950B1B8_P43060 JDB9900307 - Failed to find table specifications
Jul 18 04:13:02.532000 - 5236/3656 WRK:E191643_0950B1B8_P43060 JDB3100007 - Failed to get valid table specifications
Jul 18 04:13:02.533000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_OpenTable(Table = ) with Failure
Jul 18 04:13:02.533001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_GetEnv
Jul 18 04:13:02.533002 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_GetEnv with Success
Jul 18 04:13:02.533003 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_InitUser with (AUTO commit mode)
Jul 18 04:13:02.533004 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_BeginTransaction (UserHandle 0699FDC8)
Jul 18 04:13:02.533005 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_BeginTransaction with Success (UserHandle 0699FDC8)
Jul 18 04:13:02.533006 - 5236/3656 WRK:E191643_0950B1B8_P43060 Incremented huser count to 5
Jul 18 04:13:02.533007 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_InitUser with Success (UserHandle 0699FDC8)
Jul 18 04:13:02.533008 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering jdeCloseDictionary
Jul 18 04:13:02.533009 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_FreeUser (UserHandle 0699FDC8)
Jul 18 04:13:02.533010 - 5236/3656 WRK:E191643_0950B1B8_P43060 Decremented huser count to 4
Jul 18 04:13:02.533011 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_FreeUser with Success(UserHandle 0699FDC8)
Jul 18 04:13:02.533012 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exited jdeCloseDictionary with DDType 0
Jul 18 04:13:02.533013 - 5236/3656 WRK:E191643_0950B1B8_P43060 ERROR INFO JDEERR - ID= 0, Error= 3143 - b4300360.c, Line= 431
Jul 18 04:13:02.534000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_FreeBhvr (UserHandle 0699B090)
Jul 18 04:13:02.534001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_FreeBhvr with Success(UserHandle 0699B090)
Jul 18 04:13:02.534002 - 5236/3656 WRK:E191643_0950B1B8_P43060
**********************************************************************************
In the above log patch the table for which the specs are not found is not appearing in the log.
Please help me figure out how to identify the missing table.
Thanks a Lot in advance.