Skip to main content
OracleOps AI

Browse the Knowledge Layer

The curated facts behind Ask Oracle — every collection and every topic, browsable directly. Counts are live.

Collections

188tables

Table Reference

Purpose, key columns, joins and related modules for each Oracle object.

110articles

PL/SQL Reference

Language reference — one focused, runnable example per construct.

8payloads

API Examples

Copy-ready SOAP web service payloads and REST API request bodies.

8answers

Answer Library

Common Oracle questions answered in the same structured format as Ask Oracle.

11procedures

Documentation

Step-by-step setup and process walkthroughs.

27guides

Learn Guides

Module and cycle guides — P2P, O2C, AP, AR, GL and more.

Topics

Browse by module & technology →

78 curated Oracle topics — click one to open it in Ask Oracle, or jump to its main table.

Financials

AP invoice holdsAP invoice data modelCreating an AR invoiceReceipt classes, receipt methods, and automatic receiptsThe Create Automatic Receipts processGL journal data modelGL period statusHow Subledger Accounting (SLA) generates journalsFixed Assets data modelBank statement reconciliationCash positioningOracle's shared tax engine (ZX_)Customer / Trading Community data modelParty contacts (people) for a customer/organizationHow a Payables payment is built and accountedSubledger Accounting (XLA) event modelWhere the open receivables balance livesGL ledgers, periods and journal importFixed Assets transaction and accounting modelCreditMemoService — create and apply an AR credit memo via SOAP

Procurement

Requisition-to-PO-to-receipt data modelSupplier data model: header vs. siteSupplier registration and qualificationPO line → schedule → distribution → receipt

Supply Chain

Tracing a sales orderDOO_FULFILL_LINES_ALLShipping data model: delivery detail, delivery, and tripPick release and ship confirmItem and on-hand data modelWarehouse structure: subinventories and locatorsInventory transaction typesLot and serial controlWork order data modelHow Fusion Cost Accounting values inventory transactionsInventory supply, demand and reservations

Manufacturing

Discrete job execution: routing, components and moves

Projects

Project costing data modelProject billing and contract invoicingProject foundation: projects, tasks and teamsProject budgets and forecasts

HCM

Fusion HCM person and employment data modelHCM work structures: jobs, grades, positions, organizationsFusion Payroll run results data model

Technical

Lookups, value sets and flexfieldsHow attachments are stored and linkedFinding scheduled job / concurrent request runsWhat Autonomous Transaction Processing (ATP) isAutonomous Transaction Processing vs. Autonomous Data WarehouseConnecting to Autonomous Database with a walletDatabase Actions and APEX on Autonomous DatabaseWhat Oracle REST Data Services (ORDS) isWhat Oracle APEX is

Integration

How a Fusion SOAP web service WSDL URL is formedErpIntegrationService — the Fusion bulk / ESS integration SOAP serviceErpObjectAttachmentService — attach documents to ERP transactions via SOAPChoosing SOAP vs REST vs FBDI for Fusion integrationWhat Oracle Integration Cloud (OIC) isOIC integration styles: App Driven vs. Scheduled vs. OrchestrationOIC adapters and connectionsError handling and fault aggregation in OICConnectivity Agent for on-premises systemsBusiness Events and the OIC subscriber patternFBDI-based bulk integration patternTroubleshooting and safely changing OIC connectionsWhat Visual Builder Cloud Service (VBCS) isVBCS application structure: pages, flows, and business objectsConnecting VBCS to Fusion or custom REST servicesAction chains and variables in VBCSExtending Fusion UI with Visual BuilderExtending an existing Fusion Redwood page with Visual BuilderBuilding a standalone app in the Redwood visual styleVBCS page structure under the hood and source controlWhat BI Cloud Connector (BICC) isIntegrating OIC with Autonomous DatabaseWhat OCI Streaming is and when to use itUsing OCI Streaming with OICOCI Streaming vs. OCI Queue

Security

EBS security: users and responsibilities