jbbr111
Member
INFRASTRUCTURE
Our Oracle infrastructure is based on:
- Oracle tool release version: 8.96
- JDE Enterprise one version: 8.12
- Microsoft Sql 2005 Enterprise Edition SP2 (cluster)
The user (manually) insert a JE using the program called P0911 (or P570911) using the web browers. We do not have “fat client”.
The application works in this way:
1. INSERT JE batch control record (header) on proddta.F0011 (1 record for each document)
2. WRITE on application server cache (not onto database) JE detail
3. WRITE JE detail on proddta.F0911 (2 or more based on details) taken from the cache
o NOTE: ON STEP3: If the batch header on F0911 is not yet present delete F0011 record
The problem we’re experiencing is that the user, when goes to post the transaction, does not find the batch header. In this case IT rebuild (using Oracle functionalities) the header based on JE detail
The number of missing batches is increaing in frequency. Does anybody have any ideas why this maybe happening?
Our Oracle infrastructure is based on:
- Oracle tool release version: 8.96
- JDE Enterprise one version: 8.12
- Microsoft Sql 2005 Enterprise Edition SP2 (cluster)
The user (manually) insert a JE using the program called P0911 (or P570911) using the web browers. We do not have “fat client”.
The application works in this way:
1. INSERT JE batch control record (header) on proddta.F0011 (1 record for each document)
2. WRITE on application server cache (not onto database) JE detail
3. WRITE JE detail on proddta.F0911 (2 or more based on details) taken from the cache
o NOTE: ON STEP3: If the batch header on F0911 is not yet present delete F0011 record
The problem we’re experiencing is that the user, when goes to post the transaction, does not find the batch header. In this case IT rebuild (using Oracle functionalities) the header based on JE detail
The number of missing batches is increaing in frequency. Does anybody have any ideas why this maybe happening?
