Search Results create bank




The POS_ACNT_GEN_REQ table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Procurement (iProcurement) module, specifically supporting the Account Generator functionality. Account Generator is a key feature in Oracle EBS that dynamically determines accounting flexfield combinations (e.g., Cost Center, Account, Natural Account) for transactions based on predefined rules. This table stores requests for generating accounting entries, ensuring proper financial posting during procurement processes such as requisitions, purchase orders, and invoices.

Table Purpose and Functional Context

The POS_ACNT_GEN_REQ table acts as a staging area for account generation requests. When a user creates a requisition or modifies a procurement document, the system triggers the Account Generator engine to derive the appropriate accounting segments. This table temporarily holds metadata and contextual data required for the Account Generator to process these requests before posting to the general ledger.

Key Columns and Structure

The table typically includes the following columns:
  • REQUEST_ID: Primary key, uniquely identifying each account generation request.
  • DOCUMENT_TYPE: Specifies the procurement document type (e.g., REQUISITION, PO, INVOICE).
  • DOCUMENT_ID: References the document (e.g., requisition header ID or line ID).
  • STATUS: Tracks the processing state (PENDING, PROCESSED, ERROR).
  • CREATION_DATE: Timestamp of request creation.
  • LAST_UPDATE_DATE: Timestamp of the last modification.
  • ATTRIBUTE_CATEGORY/ATTRIBUTE1-15: Flexfield columns for custom attributes.

Integration with Account Generator Workflow

The table integrates with Oracle's Account Generator workflow as follows:
  1. A procurement transaction (e.g., requisition line) triggers an account generation request.
  2. The system inserts a record into POS_ACNT_GEN_REQ with contextual data.
  3. The Account Generator engine reads the request, applies rules from FND_FLEX_RULES, and computes accounting segments.
  4. Upon successful processing, the status updates to PROCESSED, and accounting flexfields are populated in the transaction tables (e.g., PO_REQ_DISTRIBUTIONS_ALL).

Technical Considerations

  • Indexing: The table is indexed on REQUEST_ID, DOCUMENT_TYPE, and DOCUMENT_ID for performance.
  • Purge Mechanism: Processed records may be archived or purged periodically to maintain performance.
  • Concurrency: The Account Generator processes requests asynchronously, allowing parallel processing.

Customization and Extensions

Organizations can extend the table's functionality by:
  • Leveraging flexfield attributes to pass custom data to Account Generator rules.
  • Creating triggers or workflows based on status changes.
  • Integrating with custom PL/SQL logic for complex accounting scenarios.

Common Issues and Troubleshooting

  • Stalled Requests: Check for records with PENDING status and verify concurrent manager logs.
  • Incorrect Accounting: Validate Account Generator rules and ensure source data (e.g., item categories, supplier data) is accurate.
  • Performance Bottlenecks: Monitor table growth and consider partitioning for high-volume environments.
In summary, POS_ACNT_GEN_REQ is a foundational table enabling dynamic accounting in Oracle iProcurement, ensuring financial integrity across procurement operations. Its design supports scalability, auditability, and integration with Oracle's flexible Account Generator framework.