Search Results currency
The RCV_SHIPMENT_LINES_EFC
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical entity within the Receiving (RCV) module, primarily used for storing Electronic Funds Transfer (EFT) or Electronic Commerce (EC) related data for shipment lines. This table serves as an extension to the core receiving functionality, enabling organizations to manage electronic payment and invoicing processes associated with received shipments. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.
Purpose and Functional Context
TheRCV_SHIPMENT_LINES_EFC
table is designed to store supplementary information for shipment lines that involve electronic transactions. It acts as a child table to RCV_SHIPMENT_LINES
, capturing attributes specific to electronic payments, such as payment references, authorization details, and transaction identifiers. This table is particularly relevant in procure-to-pay (P2P) workflows where electronic invoicing or automated payment processing is implemented. Its data is leveraged during the matching of receipts to invoices and the subsequent payment approval process.
Key Columns and Data Structure
The table comprises several columns that facilitate electronic transaction tracking:- SHIPMENT_LINE_ID: Foreign key linking to
RCV_SHIPMENT_LINES
, establishing the relationship with the parent shipment line. - TRANSACTION_ID: Unique identifier for the electronic transaction, often used for reconciliation.
- PAYMENT_REFERENCE: Stores payment-specific references like bank transaction IDs or payment authorization codes.
- STATUS_FLAG: Indicates the processing status (e.g., 'P' for Pending, 'C' for Complete).
- CREATION_DATE and LAST_UPDATE_DATE: Audit columns for tracking record lifecycle.
Integration with Oracle EBS Modules
TheRCV_SHIPMENT_LINES_EFC
table integrates with multiple Oracle EBS modules:
- Purchasing (PO): Links to purchase order lines via
PO_LINE_ID
to validate receipt against ordered quantities. - Payables (AP): Provides payment details during invoice matching, reducing manual entry errors.
- General Ledger (GL): Contributes to financial reporting by ensuring accurate posting of electronic payment transactions.
Customization and Extensions
Organizations often extend this table to include custom fields for industry-specific requirements, such as regulatory compliance tags or third-party system references. Oracle's Open Interface Tables allow for data imports/exports, enabling seamless integration with external fintech platforms.Performance Considerations
Given its transactional nature, the table should be indexed on frequently queried columns likeSHIPMENT_LINE_ID
and TRANSACTION_ID
. Partitioning strategies may be employed for high-volume environments to optimize query performance during financial closings.
Conclusion
TheRCV_SHIPMENT_LINES_EFC
table is a pivotal component in Oracle EBS's electronic commerce framework, bridging physical receipts with financial transactions. Its structured design supports automated workflows, reduces manual intervention, and enhances data accuracy in procure-to-pay cycles. For implementations leveraging electronic payments, understanding this table's schema and relationships is essential for configuring efficient receiving and payment processes.
-
Lookup Type: CURRENCY SOURCE
12.1.1
product: PO - Purchasing , meaning: Currency source , description: Currency source ,
-
Lookup Type: CURRENCY SOURCE
12.2.2
product: PO - Purchasing , meaning: Currency source , description: Currency source ,
-
Lookup Type: RQMRQ HEADER OPTION
12.1.1
product: PO - Purchasing , meaning: Options for Req Entry form (Header) , description: Options for Req Entry form (Header) ,
-
Lookup Type: VIEW OPTION
12.1.1
product: PO - Purchasing , meaning: Valid view options for the PO Creation form , description: Valid view options for the PO Creation form ,
-
Lookup Type: PO RELEASE
12.1.1
product: PO - Purchasing , meaning: PO Release Navigation , description: PO Release Navigation ,
-
Lookup Type: RQMRQ HEADER OPTION
12.2.2
product: PO - Purchasing , meaning: Options for Req Entry form (Header) , description: Options for Req Entry form (Header) ,
-
Lookup Type: RQMRQ LINES OPTION
12.2.2
product: PO - Purchasing , meaning: Options for Req Entry form , description: Options for Req Entry form ,
-
Lookup Type: VIEW OPTION
12.2.2
product: PO - Purchasing , meaning: Valid view options for the PO Creation form , description: Valid view options for the PO Creation form ,
-
Lookup Type: QUOTE HEADER INFO
12.1.1
product: PO - Purchasing , meaning: Additional information options for headers in Enter Quotations form , description: Additional information options for headers in Enter Quotations form ,
-
Lookup Type: QUOTE HEADER INFO
12.2.2
product: PO - Purchasing , meaning: Additional information options for headers in Enter Quotations form , description: Additional information options for headers in Enter Quotations form ,
-
Lookup Type: AUTOCREATE QUOTE HEADER INFO
12.1.1
product: PO - Purchasing , meaning: Additional information options for headers in AutoCreate Quotations form , description: Additional information options for headers in AutoCreate Quotations form ,
-
Lookup Type: AUTOCREATE QUOTE HEADER INFO
12.2.2
product: PO - Purchasing , meaning: Additional information options for headers in AutoCreate Quotations form , description: Additional information options for headers in AutoCreate Quotations form ,
-
Lookup Type: PO RELEASE
12.2.2
product: PO - Purchasing , meaning: PO Release Navigation , description: PO Release Navigation ,
-
Lookup Type: RQMRQ LINES OPTION
12.1.1
product: PO - Purchasing , meaning: Options for Req Entry form , description: Options for Req Entry form ,
-
Lookup Type: RFQ HEADER INFO
12.1.1
product: PO - Purchasing , meaning: Additional information options for headers in Enter RFQs form , description: Additional information options for headers in Enter RFQs form ,
-
Lookup Type: RFQ HEADER INFO
12.2.2
product: PO - Purchasing , meaning: Additional information options for headers in Enter RFQs form , description: Additional information options for headers in Enter RFQs form ,
-
Lookup Type: POXZMPHD
12.1.1
product: PO - Purchasing , meaning: Additional PO header detail information. , description: Additional PO header detail information. ,
-
Lookup Type: POXZMPHD
12.2.2
product: PO - Purchasing , meaning: Additional PO header detail information. , description: Additional PO header detail information. ,
-
Lookup Type: PO HEADER
12.1.1
product: PO - Purchasing , meaning: PO Header Navigation , description: PO Header Navigation ,
-
Lookup Type: PO HEADER
12.2.2
product: PO - Purchasing , meaning: PO Header Navigation , description: PO Header Navigation ,
-
Lookup Type: QUOTE APPROVAL INFO
12.1.1
product: PO - Purchasing , meaning: Additional options for headers in Enter Quotation Approvals form , description: Additional options for headers in Enter Quotation Approvals form ,
-
Lookup Type: QUOTE APPROVAL INFO
12.2.2
product: PO - Purchasing , meaning: Additional options for headers in Enter Quotation Approvals form , description: Additional options for headers in Enter Quotation Approvals form ,
-
View: POA_PURCHASE_SALES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POA_PURCHASE_SALES_V, object_name:POA_PURCHASE_SALES_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POA_PURCHASE_SALES_V ,
-
View: POA_PURCHASE_SALES_V
12.2.2
product: PO - Purchasing , implementation_dba_data: Not implemented in this database ,
-
Lookup Type: SRS ORDER BY
12.1.1
product: PO - Purchasing , meaning: Sort By Options for Reports , description: Sort By Options for Reports ,
-
Lookup Type: SRS ORDER BY
12.2.2
product: PO - Purchasing , meaning: Sort By Options for Reports , description: Sort By Options for Reports ,
-
View: PO_NOTIFICATION_DETAILS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_NOTIFICATION_DETAILS_V, object_name:PO_NOTIFICATION_DETAILS_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.PO_NOTIFICATION_DETAILS_V ,
-
View: PO_NOTIFICATION_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_NOTIFICATION_DETAILS_V, object_name:PO_NOTIFICATION_DETAILS_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.PO_NOTIFICATION_DETAILS_V ,
-
View: FND_NOTIFICATIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.FND_NOTIFICATIONS_V, object_name:FND_NOTIFICATIONS_V, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.FND_NOTIFICATIONS_V ,
-
View: FND_NOTIFICATIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.FND_NOTIFICATIONS_V, object_name:FND_NOTIFICATIONS_V, status:VALID, product: PO - Purchasing , description: - Retrofitted , implementation_dba_data: APPS.FND_NOTIFICATIONS_V ,
-
Table: RCV_SHIPMENT_LINES_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_LINES_EFC, object_name:RCV_SHIPMENT_LINES_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.RCV_SHIPMENT_LINES_EFC ,
-
Table: PO_REQUISITIONS_INT_ALL_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQUISITIONS_INT_ALL_EFC, object_name:PO_REQUISITIONS_INT_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQUISITIONS_INT_ALL_EFC ,
-
Table: POA_BIS_SUPPLIER_PERFORMAN_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.POA_BIS_SUPPLIER_PERFORMAN_EFC, object_name:POA_BIS_SUPPLIER_PERFORMAN_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.POA_BIS_SUPPLIER_PERFORMAN_EFC ,
-
Table: PO_REQUISITIONS_INT_ALL_EFC
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQUISITIONS_INT_ALL_EFC, object_name:PO_REQUISITIONS_INT_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQUISITIONS_INT_ALL_EFC ,
-
Table: PO_CONTROL_RULES_EFC
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_CONTROL_RULES_EFC, object_name:PO_CONTROL_RULES_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_CONTROL_RULES_EFC ,
-
Table: PO_REQ_DISTRIBUTIONS_ALL_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQ_DISTRIBUTIONS_ALL_EFC, object_name:PO_REQ_DISTRIBUTIONS_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQ_DISTRIBUTIONS_ALL_EFC ,
-
Table: PO_CONTROL_RULES_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_CONTROL_RULES_EFC, object_name:PO_CONTROL_RULES_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_CONTROL_RULES_EFC ,
-
Table: PO_ACCRUAL_WRITE_OFFS_ALL_EFC
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCRUAL_WRITE_OFFS_ALL_EFC, object_name:PO_ACCRUAL_WRITE_OFFS_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_ACCRUAL_WRITE_OFFS_ALL_EFC ,
-
Table: PO_REQUISITION_LINES_ALL_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQUISITION_LINES_ALL_EFC, object_name:PO_REQUISITION_LINES_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQUISITION_LINES_ALL_EFC ,
-
Table: POA_BIS_SAVINGS_RPT_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.POA_BIS_SAVINGS_RPT_EFC, object_name:POA_BIS_SAVINGS_RPT_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.POA_BIS_SAVINGS_RPT_EFC ,
-
Table: PO_REQ_DISTRIBUTIONS_ALL_EFC
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQ_DISTRIBUTIONS_ALL_EFC, object_name:PO_REQ_DISTRIBUTIONS_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQ_DISTRIBUTIONS_ALL_EFC ,
-
Table: POA_BIS_SAVINGS_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.POA_BIS_SAVINGS_EFC, object_name:POA_BIS_SAVINGS_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.POA_BIS_SAVINGS_EFC ,
-
Table: PO_ACCRUAL_WRITE_OFFS_ALL_EFC
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_ACCRUAL_WRITE_OFFS_ALL_EFC, object_name:PO_ACCRUAL_WRITE_OFFS_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_ACCRUAL_WRITE_OFFS_ALL_EFC ,
-
Table: RCV_SHIPMENT_LINES_EFC
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_LINES_EFC, object_name:RCV_SHIPMENT_LINES_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.RCV_SHIPMENT_LINES_EFC ,
-
Table: POA_BIS_SAVINGS_RPT_EFC
12.2.2
product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: Not implemented in this database ,
-
Table: POA_BIS_SUPPLIER_PERFORMAN_EFC
12.2.2
product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: Not implemented in this database ,
-
Table: PO_REQUISITION_LINES_ALL_EFC
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_REQUISITION_LINES_ALL_EFC, object_name:PO_REQUISITION_LINES_ALL_EFC, status:VALID, product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: PO.PO_REQUISITION_LINES_ALL_EFC ,
-
Table: POA_BIS_SAVINGS_EFC
12.2.2
product: PO - Purchasing , description: archive for euro functional currency project , implementation_dba_data: Not implemented in this database ,
-
View: PO_BY_BUYER_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_BY_BUYER_V, object_name:PO_BY_BUYER_V, status:VALID, product: PO - Purchasing , description: Purchase order information by buyer , implementation_dba_data: APPS.PO_BY_BUYER_V ,
-
View: PO_BY_BUYER_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_BY_BUYER_V, object_name:PO_BY_BUYER_V, status:VALID, product: PO - Purchasing , description: Purchase order information by buyer , implementation_dba_data: APPS.PO_BY_BUYER_V ,