Search Results organization
The RCV_PARAMETERS
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for Receiving (RCV) module configurations. It stores system-wide and organization-specific parameters that govern the behavior of receiving transactions, approvals, tolerances, and other operational controls. This table is part of the Oracle Inventory and Purchasing modules, ensuring seamless integration between procurement and inventory management processes. Below is a detailed breakdown of its structure, key columns, and functional significance.
Table Structure and Key Columns
TheRCV_PARAMETERS
table consists of columns that define receiving policies, default values, and validation rules. Some of the most important columns include:
- ORGANIZATION_ID: Links to
HR_ORGANIZATION_UNITS
, specifying the inventory organization for which the parameters apply. - AUTO_RECEIVE_FLAG: Determines whether shipments are automatically received upon matching purchase orders.
- REQUIRE_DELIVERY_DATES_FLAG: Enforces mandatory delivery date entries during receipt creation.
- ALLOW_SUBSTITUTE_RECEIPTS_FLAG: Permits substitution of items during receiving if the original item is unavailable.
- QTY_RECEIPT_TOLERANCE: Defines the allowable over/under receipt percentage for quantity validations.
- AMOUNT_RECEIPT_TOLERANCE: Sets financial tolerances for invoice price variances against purchase orders.
- DEFAULT_RECEIPT_ROUTING_ID: References
RCV_ROUTING_HEADERS
to assign default routing (e.g., Direct Delivery, Inspection).
Functional Significance
TheRCV_PARAMETERS
table plays a pivotal role in standardizing receiving operations across the organization. Key functionalities influenced by its configurations include:
- Receipt Automation: Parameters like
AUTO_RECEIVE_FLAG
streamline inbound logistics by automating receipt creation, reducing manual intervention. - Tolerance Management: Columns such as
QTY_RECEIPT_TOLERANCE
enforce compliance with contractual terms, preventing excessive deviations in received quantities or costs. - Routing Controls: Default routing IDs ensure consistent handling of materials (e.g., inspection for quality-critical items).
- Substitution Rules: The
ALLOW_SUBSTITUTE_RECEIPTS_FLAG
facilitates flexibility in supply chain operations when primary items are unavailable.
Integration with Other Modules
The table interacts with several EBS components:- Purchasing (PO): Validates receipts against purchase order terms via tolerances and approval flags.
- Inventory (INV): Directs received items to appropriate subinventories based on routing rules.
- General Ledger (GL): Financial tolerances impact invoice accounting entries and variance reporting.
Customization and Extensions
Organizations often extend theRCV_PARAMETERS
table’s functionality through:
- Profile Options: Overriding defaults via system profiles (e.g.,
RCV: Allow Substitute Receipts
). - API Hooks: Using
RCV_PARAMETERS_PKG
APIs to programmatically adjust parameters for custom workflows. - Cross-Validation Rules: Adding constraints via database triggers to enforce business-specific policies.
Conclusion
In Oracle EBS 12.1.1 and 12.2.2, theRCV_PARAMETERS
table serves as the backbone for configuring receiving processes, ensuring alignment with organizational policies and supply chain requirements. Its structured design and integration capabilities make it indispensable for maintaining control over procurement-to-inventory workflows. Proper configuration of this table is essential to optimize operational efficiency, compliance, and data integrity in the Receiving module.
-
Lookup Type: ORGANIZATION TYPE
12.2.2
product: PO - Purchasing , meaning: Organization Types , description: Organization Types ,
-
Lookup Type: ORGANIZATION TYPE
12.1.1
product: PO - Purchasing , meaning: Organization Types , description: Organization Types ,
-
Lookup Type: SHIPPING CONTROL
12.2.2
product: PO - Purchasing , meaning: Transportation Arranged , description: Valid Transportation Arranged Values ,
-
Lookup Type: SHIPPING CONTROL
12.1.1
product: PO - Purchasing , meaning: Transportation Arranged , description: Valid Transportation Arranged Values ,
-
View: PO_SOURCE_SHIPMENT_NUM_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_SOURCE_SHIPMENT_NUM_V, object_name:PO_SOURCE_SHIPMENT_NUM_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.PO_SOURCE_SHIPMENT_NUM_V ,
-
View: PO_SOURCE_SHIPMENT_NUM_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_SOURCE_SHIPMENT_NUM_V, object_name:PO_SOURCE_SHIPMENT_NUM_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.PO_SOURCE_SHIPMENT_NUM_V ,
-
Table: RCV_PARAMETERS
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_PARAMETERS, object_name:RCV_PARAMETERS, status:VALID, product: PO - Purchasing , description: Organization-level receiving controls , implementation_dba_data: PO.RCV_PARAMETERS ,
-
Table: RCV_PARAMETERS
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_PARAMETERS, object_name:RCV_PARAMETERS, status:VALID, product: PO - Purchasing , description: Organization-level receiving controls , implementation_dba_data: PO.RCV_PARAMETERS ,
-
View: PO_REQUESTOR_LOCATIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_REQUESTOR_LOCATIONS_V, object_name:PO_REQUESTOR_LOCATIONS_V, status:VALID, product: PO - Purchasing , description: Employee's location, given employee ID and optionally organization , implementation_dba_data: APPS.PO_REQUESTOR_LOCATIONS_V ,
-
View: PO_REQUESTOR_LOCATIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_REQUESTOR_LOCATIONS_V, object_name:PO_REQUESTOR_LOCATIONS_V, status:VALID, product: PO - Purchasing , description: Employee's location, given employee ID and optionally organization , implementation_dba_data: APPS.PO_REQUESTOR_LOCATIONS_V ,
-
Table: PO_POSITION_CONTROLS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_POSITION_CONTROLS_ALL, object_name:PO_POSITION_CONTROLS_ALL, status:VALID, product: PO - Purchasing , description: Job/organization and position controls , implementation_dba_data: PO.PO_POSITION_CONTROLS_ALL ,
-
Table: PO_POSITION_CONTROLS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_POSITION_CONTROLS_ALL, object_name:PO_POSITION_CONTROLS_ALL, status:VALID, product: PO - Purchasing , description: Job/organization and position controls , implementation_dba_data: PO.PO_POSITION_CONTROLS_ALL ,
-
View: RCV_SOURCES_BOTH_VAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_SOURCES_BOTH_VAL_V, object_name:RCV_SOURCES_BOTH_VAL_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_SOURCES_BOTH_VAL_V ,
-
View: RCV_SOURCES_BOTH_VAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.RCV_SOURCES_BOTH_VAL_V, object_name:RCV_SOURCES_BOTH_VAL_V, status:VALID, product: PO - Purchasing , description: 10SC ONLY - Retrofitted , implementation_dba_data: APPS.RCV_SOURCES_BOTH_VAL_V ,
-
View: POS_RCV_REJECTED_ITEMS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POS_RCV_REJECTED_ITEMS_V POS.POS_RCV_REJECTED_ITEMS_V, object_name:POS_RCV_REJECTED_ITEMS_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POS_RCV_REJECTED_ITEMS_V ,
-
View: POS_RCV_REJECTED_ITEMS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POS_RCV_REJECTED_ITEMS_V, object_name:POS_RCV_REJECTED_ITEMS_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POS_RCV_REJECTED_ITEMS_V ,
-
View: POS_RCV_RETURNS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.POS_RCV_RETURNS_V POS.POS_RCV_RETURNS_V, object_name:POS_RCV_RETURNS_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POS_RCV_RETURNS_V ,
-
View: POS_RCV_RETURNS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.POS_RCV_RETURNS_V, object_name:POS_RCV_RETURNS_V, status:VALID, product: PO - Purchasing , implementation_dba_data: APPS.POS_RCV_RETURNS_V ,