This page (revision-4) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by kparrott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 6 KB kparrott to previous
3 26-Nov-2021 10:22 6 KB kparrott to previous | to last
2 26-Nov-2021 10:22 6 KB kparrott to previous | to last
1 26-Nov-2021 10:22 6 KB kparrott to last

Page References

Incoming links Outgoing links
WORK ORDERS VALIDATION (JD Edwards)...nobody
WORK ORDERS VALIDATION (JD Edwards)

Version management

Difference between version and

At line 7 removed one line
At line 9 removed one line
At line 15 removed one line
At line 19 removed one line
At line 22 changed 5 lines
* USERNAME - is a database level user in the JD Edwards Financial system with proper permission, e.g. gluser
* USERPASSWORD - is the password for the above username, e.g. p2kpass
* DBALIAS - is the database alias for the JD Edwards financial system
**- the JD Edwards financials database alias must be in the TNSNAMES.ora file in the database’s ORACLE_HOME\NETWORK\ADMIN directory
\\ \\
where USERNAME - is a database level user in the JD Edwards Financial system with proper
permission , e.g. gluser
USERPASSWORD - is the password for the above username, e.g. p2kpass
DBALIAS - is the database alias for the JD Edwards financial system
- the JD Edwards financials database alias must be in the
TNSNAMES.ora file in the database’s
ORACLE_HOME\NETWORK\ADMIN directory
At line 35 added one line
This ‘SELECT’ statement should return the number of records in this F4801 Table.
At line 38 removed 2 lines
* this ‘SELECT’ statement should return the number of records in this F4801 Table.
At line 42 removed one line
At line 45 changed 2 lines
* this error occurs when the Database link is not established properly or the Table does not exist in the JD Edwards Financials data base, please check database link and the JD Edwards Financials database Tables to ensure all Tables exist
* the actual name of the JD Edwards Financials Table may need to be referenced by the username, e.g. gluser.F4801, if this is the case, the DBA need to create a public synonym in the JD Edwards Financials Table for the Table.
- this error occurs when the Database link is not established properly or the Table does not exist in the JD Edwards Financials data base, please check database link and the JD Edwards Financials database Tables to ensure all Tables exist
- the actual name of the JD Edwards Financials Table may need to be referenced by the username, e.g. gluser.F4801, if this is the case, the DBA need to create a public synonym in the JD Edwards Financials Table for the Table.
At line 51 changed 3 lines
WADOCO number - Work Order\\
WASRST char(2) - Work Order Status
WADOCO number - Work Order
WASRST char(2) - Work Order Status
At line 56 changed one line
[{Image src='WorkOrdersVal_JDE_01.jpg' width='700'}]
[{Image src=’WorkOrdersVal_JDE_01.jpg' width='700'}]
At line 87 changed one line
In order to validate between the 2 systems, P2K uses an Oracle SELECT statement to read the JD Edwards Financial F4801 table and do an exact match to the Work Order Number.
In order to validate between the 2 systems, P2K uses an Oracle SELECT statement to read the JD Edwards Financial F4801 table and do an exact match to the Work Order Number. The Work Order Number must be Active in order to be valid. Active Work Order Numbers are with WASRST = ‘60’.
At line 89 removed 2 lines
The Work Order Number must be Active in order to be valid. Active Work Order Numbers are with WASRST = ‘60’.
At line 95 changed one line
SELECT *\\FROM F4801@jde_financials\\WHERE WADOCO = 130\\
SELECT *
FROM F4801@jde_financials
WHERE WADOCO = 130
At line 99 removed one line
This page (revision-4) was last changed on 26-Nov-2021 10:22 by kparrottTop