Requirements:
JDE Orchestrator Studio.
API URL from your Central Bank (Free public access usually).
The Dirty Step-by-Step
Scout the API: Search for your Central Bank's API. Test it in Postman. You want a JSON response.
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.
The Recorder: Open P0015A in JDE. Turn on the Process Recorder. Manually enter one rate. Save. This generates your Form Request.
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.
The Report: Add a step to run the standard Exchange Rate report (R00151P) immediately after, filtering by your local currency.
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.
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



