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 added one line
At line 9 added one line
At line 15 added one line
At line 19 added one line
At line 18 changed 7 lines
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
* 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 removed one line
This ‘SELECT’ statement should return the number of records in this F4801 Table.
At line 38 added 2 lines
* this ‘SELECT’ statement should return the number of records in this F4801 Table.
At line 42 added one line
At line 41 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 47 changed 2 lines
WADOCO number - Work Order
WASRST char(2) - Work Order Status
WADOCO number - Work Order\\
WASRST char(2) - Work Order Status
At line 82 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. The Work Order Number must be Active in order to be valid. Active Work Order Numbers are with WASRST = ‘60’.
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.
At line 89 added 2 lines
The Work Order Number must be Active in order to be valid. Active Work Order Numbers are with WASRST = ‘60’.
At line 88 changed 3 lines
SELECT *
FROM F4801@jde_financials
WHERE WADOCO = 130
SELECT *\\FROM F4801@jde_financials\\WHERE WADOCO = 130\\
At line 99 added one line
This page (revision-4) was last changed on 26-Nov-2021 10:22 by kparrottTop