Workflows and automation FAQ — page 4
All FAQ topics / Workflows and automation
156 questions · page 4 of 4
A BPA workflow's IFS Projection task, meant to update a field at record creation via a Projection call, fails — inspecting the equivalent call in Postman shows IFS itself calling two entity sets together in a single web-service request, but the Projection task configuration only allows specifying one.
Does BPA Workflow avoid the classic mutating-table problem that plain Custom Events regularly hit when trying to query or update the same table that's still mid-transaction?
Trying to add a field (like a status field) to the Subscription feature for a given screen, but the field doesn't show up in the list of fields available to subscribe to — why?
How do you schedule a recurring background job (like a migration/import job) to run only on specific days of the week, every hour, rather than a plain daily or hourly schedule?
What's a reliable date expression for scheduling a custom task/job to run on the last day of every month, that works consistently across different Oracle database versions?
How do you schedule a Database Task to run at three specific times during the day (like 8 AM, 12 PM, and 4 PM) rather than on a fixed interval, so it doesn't also fire overnight or in the evening?
The STEP_READY_FOR_APPROVAL system event fires correctly when moving from one approval step to the next, but doesn't fire for the very first step when an approval template is initially applied — how do you get the first-step approver notified too?
A Scheduled Database Task supports sending a Streams notification when it runs, but that only notifies whoever created the job — is there a way to notify a whole group of users instead of just the job's creator?
Scheduling a Database Task to run on a dynamic date (like the end of an accounting-period quarter) rather than a fixed calendar date is tricky since those period-end dates shift from year to year — is there a way to drive the schedule off business logic instead of a fixed date/interval expression?
The system automatically sends an email with a report attached (like a Customer Order confirmation) whenever 'Send E-mail To' is checked and the report prints successfully — is there a way to customize that automatic email's subject/body, or to fully disable it in favor of a custom Event Action's own email (to avoid getting two separate emails for the same event)?
Is there a way to change or customize the format of an email message before it's sent out automatically by the system?
Is there a way to have a label automatically print (using the same underlying report view as an operational report, like an Arrival Report) every time that operational report itself gets printed, without a separate manual step?
With multiple Companies configured in one environment, is there a way to have outgoing report/document emails (like invoices) automatically use a different default 'From' address per Company, rather than one single system-wide default?
Is there an upper limit on how many comma/semicolon-separated email addresses can be used in a Custom Event's email action, and is it good practice to rely on this instead of a dedicated distribution list?
Custom PL/SQL logic tied to an Approval Routing step being approved (for example writing a custom History entry with the step's description) works for every step except the very last one, where looking up the current approval step throws an error.
Is there a way to enrich a built-in system Application Defined Event, like the Approval Routing step-approved event that sends an email, with additional looked-up information — for example showing a Document's title and class description instead of its raw document number?
When an approval request lands with a user, is there a way for them to see who actually originated/requested that approval, since there's no obvious native field showing this and users often have follow-up questions for whoever triggered it?
A Custom Event set up to fire when a Functional Object's Operational Status changes to 'Out of Operation' never triggers, even though the same general event/event-action setup process has worked correctly for other notifications built the same way.
Building a Custom Event on Customer Order Invoice Head, some specific fields needed in the event's logic, like a net-amount field and a status/state field, don't appear at all in the available attribute list for the Logical Unit/table pairing being used. How can these missing fields be accessed for use in the event?
A Streams notification meant to alert whoever is set as the Responsible user on a Change Order Action can't actually be routed to that user — the only fields available on the object are a Responsible ID (an employee/person number) and Responsible (a display name), neither of which the notification mechanism can send to directly. How can the notification actually reach that specific user?
A Custom Event on PDF_REPORT_CREATED, set up to automatically email an invoice once it prints, with its condition matching against the specific report ID, both the event and event action appear enabled, but the email never gets sent and nothing shows up in Application Messages at all. What's a good troubleshooting checklist?
Is it possible to generate a Streams notification whenever a specific application Error Message occurs, for example a specific 'Insufficient material' error shown when attempting a particular transaction?
On Apps9, background job interfaces occasionally fail with an 'object has been modified by another user'-style error, and there's a manual process to resend failed items, but it's often overlooked since nobody's notified when a job actually lands in a Warning or Error state. Is there an event that can notify when a background job finishes in one of those states?
A persistent custom field tracks which Sales Manager is currently assigned to a Salesman, and a second custom field on Customer Order is meant to record that Sales Manager's ID at the moment an order is released, so it can be reported on historically even if the Salesman's manager assignment later changes. A Custom Event built to copy this value across on release fires without error but never actually updates the target field. Where's the issue, and what's a working approach?
Building a Custom Event to trigger when a Shipment's status changes to 'Closed,' the field for the status/state doesn't appear under any obviously-named 'Status' or 'State' attribute when browsing the available Logical Units for Shipment.
Among the built-in Approval Routing Application Defined Events, what's the actual difference between APPROVAL_ROUTE_REJECTED and STEP_REJECTED_NODOC, since both seem to relate to a rejected approval step?
Is it possible to build an event that automatically emails a specific user 30 days BEFORE an order's latest finish date is reached, if the order's status is still not completed and it matches a specific classification — rather than reacting to an immediate database change?
One specific user never sees the numerical notification badge on their Streams button when sent something, even though the underlying task/notice does show up once they click into Streams — no configuration is found anywhere to toggle this badge on or off, and this only affects this one user. Separately, if MANY users start getting flooded with excessive/miscellaneous Streams alerts, what commonly causes that?
A Stream notification, built via `FND_STREAM_API.Create_Event_Action_Streams` with a `URL_` attribute pointing at a form like `ifsapf:frmActivity`, opens the correct form when clicked but doesn't navigate to the specific record that triggered the notification. Is there a way to make the URL open directly to that specific record?
A Stream message alerting a user about a failed background job needs to link them directly to that job's Background Job details form, but the DATA_TRANSFER query-string parameter IFS itself generates for direct navigation isn't something that can be reliably hand-constructed for a custom event's URL.
Is it worth building a Custom Event that automatically restarts a print job whenever it lands in Error status, as an automated version of the manual RMB Restart action, specifically for an intermittent Crystal Web Service issue currently under investigation?
A custom procedure that updates a related record's date field, based on values fetched from the same table it's updating, works fine as a Custom Menu but crashes with a mutating-trigger error when the same logic runs from a Custom Event fired on record creation. Passing the call through Transaction_SYS.Deferred_Call to move the update into a background job doesn't help, since the target procedure has OUT parameters. What's the correct pattern here?
A Custom Event needs to Park a Shop Order via a background Deferred_Call (to avoid a mutating-trigger error from calling it directly), bundling several sub-fields like PARK_REASON and PARK_PERSON_ID into one Client_SYS attribute string that's itself nested inside an outer attribute string. The resulting call throws 'Field [PARK_REASON] has an invalid value format,' with the sub-fields clearly getting jumbled together rather than parsed correctly.
Is it possible to have a Deferred_Call's underlying action actually execute as though performed by a different specific user, rather than the current session's user?
Is it possible to have a Custom Event run purely on a schedule, with no underlying database-change trigger at all, for example to periodically query and email a list of background jobs currently in Warning status?
No questions match. Try a broader term or reset the filters.