JDE Report Tool
Oracle JD Edwards EnterpriseOne report execution and business function calls via the AIS REST API.
Tool ID
jde-report
Credential Required
Yes — JDE AIS server connection.
Credential Properties
| Property | Type | Default | Description |
|---|---|---|---|
server |
string | — | Required. JDE AIS server hostname |
port |
integer | — | AIS port (omit for default) |
login |
string | — | Required. JDE username |
password |
string | — | Required. JDE password |
https |
boolean | true |
Use HTTPS |
environment |
string | — | JDE environment (e.g., JDV920, JPD920) |
jasServer |
string | — | JDE Java Application Server name |
role |
string | — | JDE user role (e.g., *ALL) |
Operations
1. report — Execute UBE reports
| Property | Type | Default | Description |
|---|---|---|---|
objectType |
string | Report |
Must be "Report" |
objects |
array | — | Required. Report objects to execute |
pollIntervalSeconds |
integer | 5 |
Seconds between status polls |
maxWaitSeconds |
integer | 600 |
Max wait for completion |
Each report object:
| Property | Type | Default | Description |
|---|---|---|---|
reportName |
string | — | Required. UBE report name (e.g., R0006P) |
reportVersion |
string | XJDE0001 |
Report version |
fireAndForget |
boolean | false |
Submit without waiting for completion |
dataSelection |
array | — | Report data selection criteria |
reportInterconnectData |
object | — | Report interconnect data |
Published Outputs:
- reportsExecuted — count
- report_N_name — report name
- report_N_version — report version
- report_N_jobNumber — JDE job number
- report_N_jobStatus — status code
- report_N_finalStatus — final status (D = done, E = error)
- report_N_fileName — output file name
Job Status Codes: S = submitted, W = waiting, P = processing, H = held, D = done, E = error
2. bsfn — Execute Business Functions
| Property | Type | Default | Description |
|---|---|---|---|
objectType |
string | Business Function |
Must be "Business Function" |
objects |
array | — | Required. BSFN objects to execute |
Each BSFN object:
| Property | Type | Default | Description |
|---|---|---|---|
name |
string | — | Required. BSFN name |
input |
object | — | Input parameters |
Published Outputs:
- bsfnsExecuted — count
- bsfn_N_name — function name
- bsfn_N_submitted — submission timestamp
- bsfn_N_out_{id} — each output parameter
3. discover-report / discover-bsfn — Get metadata
| Property | Type | Default | Description |
|---|---|---|---|
discoverName |
string | — | Report or BSFN name to discover |
Returns metadata about the report or business function (parameters, data selection, etc.).
Killable
Yes — logs out of JDE session.
Technology
Java 11 HttpClient against JDE AIS REST API v2. Token-based session management.
Chaining Patterns
- JDE report → Email — run a report, email notification
- JDE report → FTP — run a report, upload output file
- SQL export → JDE BSFN — extract data, call business function
- JDE BSFN → SQL import — call business function, import results
Use Cases
- Automated nightly UBE report execution
- Fire-and-forget for long-running reports
- Business function integration for data processing
- Scheduled compliance reporting
- Multi-report execution in sequence
Error Handling
- Report polling: configurable interval and max wait
- Fire-and-forget mode skips polling entirely
- Failed jobs detected via status code
E - Timeout: reports that don't complete within
maxWaitSecondstrigger failure
Publishes
The keys a later task may reference as {{taskName.key}}. Referencing anything not listed here resolves to nothing at run time.
bsfnsExecuteddiscoverNamemetadatareportsExecuted