Authoritative architectural blueprints, subledger reconciliation guides, dictionary tables, and performance diagnostic playbooks curated for OAG AI Consultant.
End-to-end O2C flow with navigation, OM tables, shipping execution, and auto-invoicing.
P2P lifecycle: requisition, PO approval hierarchy, receipt, 3-way matching, and payment.
Common Oracle Apps schema tables, join relationships, and dictionary lookups.
Core FND foundation tables used across EBS security, concurrent requests, and profiles.
Trace subledger transactions across AP, XLA_EVENTS, AE_LINES, and GL_JE_LINES.
How to manage, sequence, and troubleshoot period open/close across subledgers.
Configure GL accounting calendars, period patterns, and adjusting period rules.
Intercompany and internal supply flow mapping between inventory organizations.
ATO configuration, discrete job creation, demand classes, and final assembly order fulfillment.
Direct procurement fulfillment flow, supply chain synchronization, and reservations.
Drop ship order process, supplier direct-ship controls, and automated AP invoice creation.
Customer returns processing, RMA order lines, receiving, and credit memo issuance.
Production DBA diagnostic SQL to identify enqueue locks, blocking sessions, and row contention.
SQL diagnostics to verify PO buyer definitions, HR employee linkage, and approval limits.
Isolate and resolve uncosted inventory transactions and pending SLA accounting lines.
Root cause analysis and resolution for inventory lot/serial quantity discrepancies.
TNS listener and sqlnet.ora setup guide for secure local workstation connectivity.
Advanced analytical functions, hints, execution plan analysis, and indexing strategies.
Essential enterprise glossary covering Multi-Org, Ledgers, Operating Units, and Flexfields.
ECO lifecycle, revision management, bill of materials updates, and approval workflows.
Complete procurement architecture: requisitions, standard POs, blanket agreements, and receipts.
Standard, User, and Extensible lookup types, FND tables, and validation mechanisms.
Multi-Org Access Control security profiles, operating unit initialization, and VPD policies.
Payables System Options, Financials Options, Payment Terms, and distribution sets.
Step-by-step month-end close checklist across AP, AR, PO, INV, and General Ledger.
Asset workbench, corporate books, CIP additions, depreciation runs, and retirements.
Item Master, child orgs, locators, subinventories, and organization parameters.
Approval Management Engine (AME) transaction types, conditions, attributes, and groups.
Cash Management bank statement format loading, tolerance rules, and auto-reconciliation.
Custom accounting definitions, event models, journal line types, and account derivation rules.
Price lists, dynamic modifiers, pricing formulas, and pricing phase execution order.
Discrete job lifecycle, component issue, operation moves, scrap handling, and assembly completion.
Bills of Material components, substitute items, departments, standard operations, and resources.
Regimes-to-rate hierarchy, tax status, jurisdiction, and determining factor rules.
User definitions, responsibilities, menu hierarchies, function security, and profile options.
Business Groups, Jobs, Positions, Grades, and Key Flexfield configurations.
Trading Community Architecture: HZ_PARTIES, HZ_CUST_ACCOUNTS, party relationships, and sites.
Material Requirements Planning engines, forecast consumption, master production scheduling, and ASCP.
Payables withholding tax regimes, tax groups, calculation timing, and certificate exemptions.
Invoice line tracking from Payables into FA_MASS_ADDITIONS, queue preparation, and posting.
System-level configuration for System Items, Item Categories, Stock Locators, and Account Aliases.
Configure MOAC security profiles, organization hierarchies, and assign to responsibilities.
Formula building blocks, factor lists, API calls, and real-time order pricing recalculations.
End-to-end statement loading via BAI2/SWIFT MT940, GL cash account clearing, and exception logs.
Memory-based planning engine, ODS data collection, constraint-based scheduling, and pegging.
Application accounting definitions, event entities, source assignments, and custom derivation logic.
Configure parallel approver groups, dynamic SQL voting methods, and production exception triage.