Module-Specific Examples for Scheduled Processes Monitoring
1. SCM Example – Item Import (Product Management / Inventory)
Business Scenario
You are launching new products and loading 5,000 item records into Oracle Fusion using the Item FBDI template.
ESS Jobs Involved
-
Load Interface File for Import
-
Import Items
-
Item Batch Validation (auto-triggered)
How You Monitor This in Scheduled Processes
Step 1: Flat View Monitoring
-
Search for “Item Import” or your submission note: “New Product Launch Items – Dec Batch”.
-
Watch statuses:
-
Running → Item lines are being processed
-
Error → Common issues: missing categories, invalid UOM
-
Example insight:
“Load Interface File for Import – Completed with Warning (200 failed records)”
**Step 2: Use Status of Items to Process
Shows how many item rows were:
-
Successfully loaded
-
Failed
-
Skipped
Example view:
-
5,000 submitted
-
4,800 completed
-
200 failed → click View Log for the exact failure reasons.
Step 3: Switch to Hierarchy View
You will see:
Item Import (parent)
├── Load Interface File for Import
├── Import Items
└── Item Batch Validation
This helps you locate the exact child step that failed.
Typical Issues Easily Diagnosed Here
-
Missing mandatory attributes
-
Invalid category assignments
-
Duplicate item numbers
-
Incompatible UOM conversions
Final Output Check
Open Output for Import Items → CSV result summary.
2. Finance Example – Create Accounting (Payables)
Business Scenario
At month-end, AP team runs Create Accounting to generate accounting entries for invoices and payments.
ESS Jobs Involved
-
Create Accounting
-
Post Subledger Journal Entries (optional, triggered manually)
Scheduled Processes Monitoring Steps
Step 1: Flat View Analysis
Search: “Create Accounting”
Key columns to observe:
-
Status → Running / Completed / Error
-
Start & End Time → helps estimate performance
-
Submitted By → in case multiple teams run the job
Example output:
“Create Accounting completed with 15 errors.”
Step 2: Open Status Details
Here you find:
-
Number of events processed
-
Events in Error
-
Error description summary
Example entry:
“Invalid Distribution Combination – Cost Center not enabled.”
Step 3: View Report Output
The system generates:
-
Accounting Report
-
Subledger Accounting Error Report
These reports clearly show:
-
Invoice numbers that failed
-
Specific accounting rule violations
Bonus Tip — Hierarchy View
If Create Accounting triggers child jobs (e.g., for multiple ledgers), hierarchy view will show each ledger run separately.
Example:
Create Accounting (parent)
├── Ledger A - Subledger Accounting
└── Ledger B - Subledger Accounting
Useful for multi-ledger orgs.
3. Procurement Example – Requisition Import (Self Service Procurement / Purchasing)
Business Scenario
Requisitions are created externally (e.g., from an integration or third-party system) using FBDI.
ESS Jobs Involved
-
Load Interface File for Import
-
Import Requisitions
-
Process Requisitions (auto-triggered)
Monitoring Steps in Scheduled Processes
Step 1: Search for Requisition Import
Use filters:
-
Status = Error / Warning
-
Last 24 hours
Example status:
“Import Requisitions completed with 12 errors.”
Step 2: Use “Status of Items to Process”
Shows:
-
Interface rows processed
-
Rows that failed due to:
-
Missing charge account
-
Invalid supplier
-
Incorrect UOM
-
Missing requester
-
Example insight:
“Requester not active in Business Unit – 5 records failed.”
Step 3: Use Hierarchy View
Hierarchy view shows the subprocesses:
Requisition Import (parent)
├── Load Interface File for Import
├── Import Requisitions
└── Process Requisitions
If Process Requisitions failed, you know requisitions were imported but not converted into purchasable documents.
Step 4: Validate Final Output
From the Output tab of Process Requisitions, download:
-
Requisition creation summary
-
Error matrix
Example output:
-
45 requisitions created successfully
-
12 failed
