Search Results po location

The OIE_POL_LOC_TABLE_COLS Lookup Type in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component within the Oracle Internet Expenses (OIE) module, specifically designed to manage and define the columns that appear in the Policy Location tables. This lookup type plays a pivotal role in configuring and customizing the display of location-based policy attributes, ensuring compliance with organizational travel and expense policies. Below is a detailed exploration of its functionality, significance, and implementation within Oracle EBS.

Overview of OIE_POL_LOC_TABLE_COLS

The OIE_POL_LOC_TABLE_COLS Lookup Type is part of the Oracle Internet Expenses module, which facilitates the management of employee expense reports, travel reimbursements, and corporate policy enforcement. This lookup type is specifically tied to the Policy Location functionality, where administrators define which columns (attributes) are displayed in the Policy Location tables. These tables are used to enforce location-specific policies, such as per diem rates, mileage allowances, or lodging limits based on geographic criteria.

Purpose and Functionality

The primary purpose of OIE_POL_LOC_TABLE_COLS is to provide a configurable framework for displaying and managing location-based policy attributes. Key functionalities include:

Column Configuration: Defines which columns (e.g., city, country, currency, rate) are visible in the Policy Location tables, allowing administrators to tailor the interface to organizational needs.
Policy Enforcement: Ensures that location-specific policies are accurately reflected in the system by controlling the display of relevant attributes.
Flexibility: Supports customization to accommodate regional or organizational variations in expense policies.

Technical Implementation

In Oracle EBS 12.1.1 and 12.2.2, OIE_POL_LOC_TABLE_COLS is implemented as a standard Lookup Type, accessible via the Application Developer responsibility. The lookup values are stored in the FND_LOOKUP_VALUES table, with the Lookup Type code OIE_POL_LOC_TABLE_COLS. Each lookup value represents a column that can be displayed in the Policy Location table. Administrators can add, modify, or disable values to control the table's appearance.

Key Lookup Values

Typical values defined under this Lookup Type include:

LOCATION_NAME: Displays the name of the location (e.g., city or region).
COUNTRY: Shows the country associated with the location.
CURRENCY_CODE: Indicates the currency applicable to the location.
RATE: Displays the per diem or mileage rate for the location.
START_DATE/END_DATE: Defines the validity period for the policy.

Configuration Steps

To configure OIE_POL_LOC_TABLE_COLS, follow these steps:

Navigate to Application Developer > Application > Lookups > Define.
Query the Lookup Type OIE_POL_LOC_TABLE_COLS.
Add or modify lookup values as needed, specifying the display sequence and enabling/disabling values.
Save the changes and restart the Oracle EBS application server if required.

Impact on Policy Management

Proper configuration of OIE_POL_LOC_TABLE_COLS ensures that expense policies are accurately enforced and visible to users. For example, if a company has different meal allowances for New York and London, this lookup type ensures the correct rates are displayed and applied based on the employee's expense location. Misconfiguration can lead to policy violations or incorrect reimbursements.

Conclusion

The OIE_POL_LOC_TABLE_COLS Lookup Type is a powerful tool within Oracle Internet Expenses, enabling organizations to customize and enforce location-based expense policies effectively. Its configuration directly impacts the usability and accuracy of policy enforcement, making it an essential component for administrators managing travel and expense workflows in Oracle EBS 12.1.1 and 12.2.2.

Lookup Type: PO DIST MATCH 12.1.1
product: AP - Payables , meaning: Po Dist Match , description: Matching Options for PO distribution matching ,
Lookup Type: PO DIST MATCH 12.2.2
product: AP - Payables , meaning: Po Dist Match , description: Matching Options for PO distribution matching ,
Lookup Type: INVOICE IMPORT REJECTION 12.1.1
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: REJECT CODE 12.1.1
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: INVOICE IMPORT REJECTION 12.2.2
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: REJECT CODE 12.2.2
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: OIE_LOCATION_TYPE 12.1.1
product: AP - Payables , meaning: Expenses Location Types , description: Expenses Location Types ,
Lookup Type: OIE_MULTI_DEST_RULE_TYPES 12.2.2
product: AP - Payables , meaning: Multiple Destination Rules , description: The types of multiple location rules that can be implemented ,
Lookup Type: OIE_LOCATION_TYPE 12.2.2
product: AP - Payables , meaning: Expenses Location Types , description: Expenses Location Types ,
Lookup Type: OIE_MULTI_DEST_RULE_TYPES 12.1.1
product: AP - Payables , meaning: Multiple Destination Rules , description: The types of multiple location rules that can be implemented ,
Lookup Type: OIE_POL_LOC_TABLE_COLS 12.1.1
product: AP - Payables , meaning: Policy Location Tables Columns , description: Policy Location Tables Columns ,
Lookup Type: OIE_LOCATION_SEARCH_BY 12.2.2
product: AP - Payables , meaning: Policy Location Search By , description: Policy Location Search By columns ,
Lookup Type: OIE_POL_LOC_TABLE_COLS 12.2.2
product: AP - Payables , meaning: Policy Location Tables Columns , description: Policy Location Tables Columns ,
Lookup Type: XML TOKEN NAME 12.1.1
product: AP - Payables , meaning: XML Token Name , description: Stores contextual information for Rejected Invoices in Invoice Interface tables ,
Lookup Type: XML TOKEN NAME 12.2.2
product: AP - Payables , meaning: XML Token Name , description: Stores contextual information for Rejected Invoices in Invoice Interface tables ,
Lookup Type: OIE_LOCATION_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Policy Location Search By , description: Policy Location Search By columns ,
Lookup Type: COMPANY DERIVATION 12.2.2
product: AP - Payables , meaning: Company Derivation , description: Payee Name Source ,
Lookup Type: SHIPMENT MATCH 12.2.2
product: AP - Payables , meaning: Shipment Match , description: Matching Options for Shipment matching ,
Lookup Type: SHIPMENT MATCH 12.1.1
product: AP - Payables , meaning: Shipment Match , description: Matching Options for Shipment matching ,
Lookup Type: COMPANY DERIVATION 12.1.1
product: AP - Payables , meaning: Company Derivation , description: Payee Name Source ,
Lookup Type: OIE_CAT_FIELDS_SEARCH_BY 12.2.2
product: AP - Payables , meaning: Category Options Search By , description: Category Options Search By columns ,
Lookup Type: SHIPMENT MORE 12.1.1
product: AP - Payables , meaning: Shipment More , description: More options for shipment zone of invoice entry ,
Lookup Type: SHIPMENT MORE 12.2.2
product: AP - Payables , meaning: Shipment More , description: More options for shipment zone of invoice entry ,
Lookup Type: OIE_CAT_FIELDS_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Category Options Search By , description: Category Options Search By columns ,
Lookup Type: HOLD CODE 12.1.1
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Lookup Type: HOLD CODE 12.2.2
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Lookup Type: OIE_MERCHANT_FIELDS 12.1.1
product: AP - Payables , meaning: Merchant Fields , description: Merchant Fields used by policy compliance ,
Lookup Type: EMPLOYEE_LISTING_ORDERS 12.2.2
product: AP - Payables , meaning: Employee Listing Orders , description: Method of sorting output on Employee Listing ,
Lookup Type: OIE_MERCHANT_FIELDS 12.2.2
product: AP - Payables , meaning: Merchant Fields , description: Merchant Fields used by policy compliance ,
Lookup Type: EMPLOYEE_LISTING_ORDERS 12.1.1
product: AP - Payables , meaning: Employee Listing Orders , description: Method of sorting output on Employee Listing ,
Lookup Type: MATCH_STATUS 12.1.1
product: AP - Payables , meaning: Match Status , description: Type of Distribution Match ,
Lookup Type: MATCH_STATUS 12.2.2
product: AP - Payables , meaning: Match Status , description: Type of Distribution Match ,
Lookup Type: DISTRIBUTION MORE 12.2.2
product: AP - Payables , meaning: Distribution More , description: More options for distribution zone of invoice entry ,
Lookup Type: INVOICE TYPE 12.1.1
product: AP - Payables , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE TYPE 12.2.2
product: AP - Payables , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: DISTRIBUTION MORE 12.1.1
product: AP - Payables , meaning: Distribution More , description: More options for distribution zone of invoice entry ,
Lookup Type: HOLD TYPE 12.1.1
product: AP - Payables , meaning: Hold Type , description: The hold types are also stored as lookups for NLS translations ,
Concurrent Program: APXVDLET 12.2.2
execution_filename: APXVDLET , product: AP - Payables , user_name: APXVDLET , description: Invalid PO Vendor Notice , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: HOLD TYPE 12.2.2
product: AP - Payables , meaning: Hold Type , description: The hold types are also stored as lookups for NLS translations ,
Concurrent Program: APXVDLET 12.1.1
execution_filename: APXVDLET , product: AP - Payables , user_name: APXVDLET , description: Invalid PO Vendor Notice , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: LINE SOURCE 12.2.2
product: AP - Payables , meaning: Line Source , description: Defines possible sources to capture source of creation of a line ,
Lookup Type: OIE_LOCATION_STATUS 12.1.1
product: AP - Payables , meaning: Policy Location Status , description: Policy Location Statuses ,
Lookup Type: OIE_LOCATION_STATUS 12.2.2
product: AP - Payables , meaning: Policy Location Status , description: Policy Location Statuses ,
Lookup Type: LINE SOURCE 12.1.1
product: AP - Payables , meaning: Line Source , description: Defines possible sources to capture source of creation of a line ,
Lookup Type: OIE_POL_CUR_RULES 12.1.1
product: AP - Payables , meaning: Currency Rules , description: Currency Rules for policy compliance ,
Lookup Type: OIE_POL_CUR_RULES 12.2.2
product: AP - Payables , meaning: Currency Rules , description: Currency Rules for policy compliance ,
Lookup Type: OIE_LINE_HISTORY_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Policy Line History Search By , description: Policy Line History Search By columns ,
Lookup Type: OIEDETAILMILEAGE 12.1.1
product: AP - Payables , meaning: Mileage Detail , description: Mileage Detail ,
Lookup Type: INVOICE CORRECTION OPTION 12.2.2
product: AP - Payables , meaning: Invoice Correction Option , description: Invoice Correction Option ,
Lookup Type: INVOICE CORRECTION OPTION 12.1.1
product: AP - Payables , meaning: Invoice Correction Option , description: Invoice Correction Option ,