csv

 Prompt Title,Category,Purpose,Prompt (for LLM)

Shift Handover Email,Email Communication,Summarize Oracle Apps DBA shift activity,"Write a professional Oracle Apps DBA shift handover email. Include ADOP cycles, patching status, concurrent request failures, and pending user requests."

Daily Status Email,Email Communication,Communicate daily progress,"Create a daily Oracle Apps DBA update email listing completed tasks (e.g., backup validation, patching, monitoring), open SRs, and pending approvals."

Patch Completion Notification,Email Communication,Notify team of patch cycle completion,"Write an internal email notifying completion of ADOP patching on EBS 12.2. Include downtime, steps performed, and post-patch checks."

Incident Summary Email,Email Communication,Report an Oracle EBS outage or incident,"Summarize a PROD EBS login failure incident, including timeline, root cause (e.g., WebLogic hang), resolution steps, and preventive action."

Pre-Clone Notification Email,Email Communication,Notify teams of an upcoming clone,"Draft an email informing stakeholders of a scheduled Oracle EBS cloning from PROD to TEST. Include timeline, impact, and credentials sharing plan."

Post-Clone Update Email,Email Communication,Inform completion of clone,"Write an email confirming successful clone of EBS PROD to DEV. Include system status, known issues, and post-clone action points."

SR Escalation Email,Email Communication,Escalate Oracle SRs,"Draft an escalation email for Oracle Support regarding a high-priority SR. Include SR number, impact on PROD, and requested action."

Change Request Approval Email,Email Communication,Formal approval request,"Write an email requesting approval for an EBS patch application in PROD. Include patch details, ADOP phase plan, and rollback strategy."

Concurrent Request Alert,Email Communication,Notify about failing concurrent programs,"Generate an alert email about repeated failure of a scheduled concurrent program in PROD. Include log snippet and suggested action."

Out-of-Office Reply,Email Communication,Auto-reply for Oracle Apps DBA role,"Write an out-of-office reply for an Oracle Apps DBA. Mention limited access to Oracle SRs and include alternate contact for urgent PROD issues."

Incident Timeline Generator,Incident Response,Create a detailed timeline of an incident,"Generate a detailed timeline of an Oracle EBS incident, including detection, impact (e.g. Forms not launching), DBA actions, and recovery completion time."

RCA Summary,Incident Response,Summarize root cause analysis,"Write an RCA for a PROD outage caused by Workflow Mailer failure. Include symptoms, root cause, resolution, and future prevention steps."

Post-Mortem Report,Incident Response,Document full incident analysis,"Draft a post-mortem report for an Oracle DB node eviction from a RAC cluster. Include timestamps, ASM/GRID impact, actions, and lessons learned."

Impact Assessment Email,Incident Response,Communicate business impact,"Write an email summarizing how the EBS outage affected users (e.g. PO entry delay), including total downtime and systems impacted."

Urgent SR Request Email,Incident Response,Request support escalation,"Generate an urgent escalation email for a P1 SR related to PROD EBS login issues. Include SR number, impact, and request for immediate response."

Incident Ticket Summary,Incident Response,Summarize ticket for team visibility,"Summarize this SR in bullet points: Issue, Affected Components (e.g. Concurrent Manager), RCA, Fix, and Follow-ups."

Severity Classification Prompt,Incident Response,Classify and justify severity,"Based on this issue (e.g. forms crashing in PROD), classify its severity (Sev1–Sev3) and justify the categorization."

Suggested Fix Generator,Incident Response,Generate fix ideas,"Suggest common fixes for Workflow Mailer not starting in Oracle EBS. Include log checks, listener status, and bounce steps."

Alert Log Analysis,Incident Response,Analyze repeating Oracle DB alerts,"Analyze repeated ORA-600 errors in alert log. Identify possible causes and recommend Oracle SR references if needed."

Executive Summary Email,Incident Response,Simplified leadership communication,"Write a one-paragraph incident summary suitable for leadership about PROD DB performance issues due to stats gathering delay."

Change Request Summary,Change & Release Management,Summarize patch or config change,"Generate a change request summary for applying Oracle Patch 32809584 (PRC Payables). Include why, when, risk, and rollback plan."

Stakeholder Notification Email,Change & Release Management,Notify users of a change,"Draft a user notification email for scheduled downtime for EBS patching. Include timeline, scope, and contact info."

Rollback Plan Generator,Change & Release Management,Prepare rollback plan,"Write a rollback plan for a failed EBS adop phase=apply. Include fs_clone steps, backup reference, and service restart."

Impact Analysis Prompt,Change & Release Management,Define application impact,"Describe how applying patch 32809584 impacts AP module workflows, concurrent programs, and APIs."

Internal Summary Brief,Change & Release Management,Internal DBA team communication,"Summarize the change plan for team: patch ID, expected downtime, patch stage, testing steps, and owner."

CAB Meeting Summary,Change & Release Management,Document CAB discussions,"Summarize the CAB meeting outcomes for EBS changes: approved patches, rejections, risks, and action items."

Pre-Change Checklist,Change & Release Management,Ensure readiness,"Generate a pre-change checklist for EBS PROD patching: fs_backup, adop cleanup, service checks, notification plan."

Approval Request Email,Change & Release Management,Formal approval ask,"Write an email to request manager approval for EBS patching in PROD. Include justification, risk level, and patch scope."

Post-Change Validation Summary,Change & Release Management,Confirm post-patch system state,"Write a summary after patching: modules tested, login success, concurrent manager status, and workflow checks."

Deployment Completion Email,Change & Release Management,Inform users of success,"Write an email announcing successful patching of Oracle EBS PROD. Include modules impacted and verification status."

SQL Script Generator,Task Automation & Scripts,Create SQL for DBA tasks,"Generate a SQL script to list all concurrent programs scheduled to run in the next 24 hours in Oracle EBS."

Backup Script Builder,Task Automation & Scripts,Generate backup script,"Write a shell script to perform RMAN backup of Oracle PROD DB and log output with timestamp."

Concurrent Monitor Script,Task Automation & Scripts,Monitor running jobs,"Create a SQL script to check long-running concurrent programs and their statuses."

Cronjob Example (Maintenance),Task Automation & Scripts,Automate EBS task via cron,"Generate a cron entry that runs an EBS concurrent request monitoring script every 15 mins."

Patch Analyzer Tool,Task Automation & Scripts,Analyze patch impact,"Write a PL/SQL script to check applied patches related to AP module in EBS."

Clone Precheck Script,Task Automation & Scripts,Verify clone readiness,"Generate a shell script to verify space, DB status, and app tier for upcoming PROD to TEST clone."

Alert Log Monitor Script,Task Automation & Scripts,Monitor for critical DB alerts,"Create a script that tails Oracle alert log and triggers email if ORA-00600 or ORA-07445 appears."

SQL Formatter,Task Automation & Scripts,Format SQL for readability,"Format and optimize this SQL for Oracle EBS reporting: [insert SQL]"

Password Expiry Checker,Task Automation & Scripts,Check for expiring users,"Write a SQL query to list Oracle DB users whose passwords expire in next 7 days."

Workflow Error Extractor,Task Automation & Scripts,Extract WF errors,"Create a script that pulls last 50 Workflow Mailer errors from WF_NOTIFICATIONS for troubleshooting."

Alert Summary Email,Monitoring & Alerts,Summarize current alerts,"Summarize today's Oracle DB alerts, including ORA errors, tablespace warnings, and listener status."

Anomaly Detection Prompt,Monitoring & Alerts,Explain deviation,"Explain why PROD EBS login response time is high compared to baseline. Use available AWR and system stats."

Alert Escalation Email,Monitoring & Alerts,Raise persistent issues,"Draft an email escalating high undo tablespace usage in PROD for 3+ hours."

Monitoring Rule Generator,Monitoring & Alerts,Define alert threshold,"Create an alert rule in OEM for failed concurrent requests > 10 in 1 hour in EBS PROD."

Standard Alert Template,Monitoring & Alerts,Template for alert emails,"Generate a standard alert email format: subject, alert ID, system, time, impact, and next step."

Performance Threshold Advisor,Monitoring & Alerts,Define safe limits,"Suggest Oracle DB alert thresholds for CPU > 90%, session waits > 100, and I/O over 50ms latency."

DB Health Check Summary,Monitoring & Alerts,Overall environment status,"Summarize daily DB health: archive logs, backups, listener, FRA usage, and services."

Weekly Metrics Comparison,Monitoring & Alerts,Compare usage trends,"Compare AWR metrics for last week vs this week: DB time, wait classes, top SQLs."

Alert Correlation Prompt,Monitoring & Alerts,Identify related issues,"Analyze alerts and correlate DB locks, long jobs, and listener issues from same time frame."

Non-Technical Status Update,Monitoring & Alerts,Write for business users,"Write a simplified DB health update email for functional users — 'All systems green' or mention known slowness."