Search Results jai_cmn_boe_agents




Overview
Explore in AI Chat

Overview

The JAI_CMN_BOE_AGENTS table is a core setup entity within the Asia/Pacific Localizations (product JA) of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master repository for agent information specifically utilized in the generation and processing of Banker's Order of Exchange (BOE) invoices. As a BOE is a critical financial instrument in many Asia-Pacific jurisdictions, this table enables the system to correctly associate authorized agents or representatives with these transactional documents, ensuring compliance with localized invoicing and regulatory requirements.

Key Information Stored

The table's primary function is to store unique agent records, enforced by its defined primary and unique keys. The key columns, as documented, are AGENT_ID and AGENT_CODE. AGENT_ID serves as the primary technical identifier for each record, supporting the primary key constraint JAI_CMN_BOE_AGENTS_PK. AGENT_CODE is a unique business identifier for the agent, enforced by the unique key constraint JAI_CMN_BOE_AGENTS_UK1. While the full column list is not detailed in the provided metadata, typical data stored would include the agent's name, address, contact details, tax registration numbers, and status, forming a complete profile necessary for legal and financial documentation on BOE invoices.

Common Use Cases and Queries

The primary use case is the setup and maintenance of agents authorized for BOE transactions within the EBS localization. This data is referenced during the creation of a BOE invoice header. Common operational queries include retrieving an agent's details for invoice generation or validation, and listing all active agents for setup purposes. A sample SQL pattern to fetch agent information for a specific BOE invoice would involve joining with the JAI_CMN_BOE_HDRS table:

  • SELECT agt.* FROM jai_cmn_boe_agents agt, jai_cmn_boe_hdrs hdr WHERE hdr.agent_id = agt.agent_id AND hdr.boe_number = '<BOE_NUM>';

Reporting use cases often involve generating master lists of agents or analyzing BOE invoice volumes by agent.

Related Objects

The table has a direct and documented relationship with the BOE transaction headers table. As per the provided metadata, the JAI_CMN_BOE_AGENTS table is referenced by a foreign key from the JAI_CMN_BOE_HDRS table. The specific relationship is:

  • Foreign Key Relationship: The column JAI_CMN_BOE_HDRS.AGENT_ID references JAI_CMN_BOE_AGENTS.AGENT_ID. This ensures that every BOE header is linked to a valid, pre-defined agent from the setup table.

This relationship is fundamental, as it ties the transactional data (the BOE invoice) directly to the foundational setup data (the Agent), maintaining referential integrity throughout the BOE invoicing process.