Requirements:

  • JDE Orchestrator Studio.

  • API URL from your Central Bank (Free public access usually).

The Dirty Step-by-Step

  1. Scout the API: Search for your Central Bank's API. Test it in Postman. You want a JSON response.

  2. The Connector: Create a Connector in Orchestrator. Set the output to parse the response into an Array (Destination Currency + Rate). Tip: Use today's date logic.

  3. The Recorder: Open P0015A in JDE. Turn on the Process Recorder. Manually enter one rate. Save. This generates your Form Request.

  4. The Loop: Create an Orchestration. Add the Connector (Step 2). Add the Form Request (Step 3). map the Array from Step 2 to iterate over Step 3.

  5. The Report: Add a step to run the standard Exchange Rate report (R00151P) immediately after, filtering by your local currency.

  6. The Notification: This is key. Create a notification that sends that report to the Finance Controller. Pro Tip: Add a subscription for the person responsible. If the API fails, they must know instantly.

  7. The Schedule: Set it to run 15 minutes after the Central Bank usually publishes their rates.

Warning:

Always add error handling. If the API is down, the Orchestration must fail gracefully and scream (Notify) at someone.

Go break things (safely),

Mario

Reply

or to participate