Search Results pricing uom code

The FTP_Tables.html file in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical document that outlines the structure and functionality of File Transfer Protocol (FTP) related tables within the Oracle EBS architecture. These tables are essential for managing file transfers between Oracle EBS and external systems, ensuring seamless data exchange, batch processing, and integration with third-party applications. Below is a detailed summary of the key aspects covered in FTP_Tables.html.

1. Purpose and Scope

The FTP_Tables.html document provides a comprehensive reference for database administrators, developers, and functional consultants working with Oracle EBS. It details the schema, relationships, and usage of tables involved in FTP operations, such as file uploads, downloads, and scheduled transfers. The document is particularly useful for troubleshooting, customization, and performance tuning of FTP-related processes.

2. Key Tables and Their Functions

The document typically includes descriptions of the following tables:

FND_FTP: Stores configuration details for FTP servers, including hostnames, ports, usernames, passwords, and connection parameters. This table is central to establishing secure FTP sessions.
FND_FTP_FILES: Tracks metadata of files transferred via FTP, such as filenames, sizes, timestamps, and statuses (e.g., pending, completed, or failed).
FND_FTP_LOG: Maintains audit logs of FTP transactions, recording success/failure statuses, error messages, and timestamps for debugging and compliance.
FND_FTP_DESTINATIONS: Defines destination paths for file transfers, including local and remote directories, and mappings to specific applications or modules.

3. Integration with Oracle EBS Modules

The FTP tables integrate with various Oracle EBS modules, such as:

Oracle Payables: For importing invoices or payment files via FTP.
Oracle Receivables: For exporting customer data or lockbox files.
Oracle Inventory: For exchanging inventory data with suppliers or warehouses.

4. Security and Performance Considerations

The document emphasizes security best practices, such as encrypting credentials in FND_FTP and restricting access via Oracle EBS responsibilities. It also covers performance optimizations, like indexing key columns (FILE_ID, STATUS) in FND_FTP_FILES to speed up queries.

5. Customization and Extensions

FTP_Tables.html may include guidelines for extending FTP functionality, such as:

Adding custom columns to FND_FTP_FILES for application-specific metadata.
Creating PL/SQL triggers or APIs to automate post-transfer processing.
Leveraging Oracle Workflow or Oracle Integration Broker for advanced FTP workflows.

6. Version-Specific Differences

For EBS 12.2.2, the document might highlight enhancements like:

Support for SFTP (SSH File Transfer Protocol) in addition to traditional FTP.
Improved logging in FND_FTP_LOG with detailed error codes.
Integration with Oracle Fusion Middleware for hybrid cloud scenarios.

Conclusion

The FTP_Tables.html file is an indispensable resource for managing FTP operations in Oracle EBS. By detailing table structures, integrations, and best practices, it enables efficient and secure file transfers, ensuring data consistency and operational reliability across the enterprise.

File: Transfer Pricing 11i10 ERD.pdf 12.1.1
product: FTP - Transfer Pricing , size: 36.009 KBytes , file_type: PDF Diagram ,
Lookup Type: FTP_ADJR_ADJUSTMENT_TYPE 12.1.1
product: FTP - Transfer Pricing , meaning: Adjustment Type , description: Adjustment Type ,
Lookup Type: FTP_TP_CALC_METHOD_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Transfer Pricing Methods ,
Concurrent Program: FTPIRCRATE 12.1.1
execution_filename: FTP_IRC_ADI_MIGRATE.migratehistrates , product: FTP - Transfer Pricing , user_name: FTPIRCRATE , description: Transfer Pricing IRC Web ADI Import Rate , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: FTP_PATTERN_SEARCH_TYPE 12.1.1
product: FTP - Transfer Pricing , meaning: Pattern Search Type , description: Pattern Search Type ,
Lookup Type: FTP_PAYMENT_PATTERN_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Payment Pattern Type Code , description: Payment Pattern Type Code ,
Concurrent Program: FTP 12.1.1
execution_filename: OFSTP , product: FTP - Transfer Pricing , user_name: Transfer Pricing Engine , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Lookup Type: FTP_TPP_CURRENCY_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Currency Code ,
Lookup Type: FTP_PAYMENT_TYPE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Payment Type Code , description: Payment Type Code ,
Lookup Type: FTP_IRC_VIEW_TYPE 12.1.1
product: FTP - Transfer Pricing , meaning: Interest Rate Code Manager View Type , description: Interest Rate Code Manager View Type ,
Lookup Type: FTP_PAYMENT_METHOD_CONV_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Payment Method Code (Conventional) , description: Payment Method Code (Conventional) ,
Lookup Type: FTP_ADJR_LOOKUP_METHOD_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Range / Interpolation , description: Range / Interpolation ,
Lookup Type: FTP_REPRICE_EVENT_TYPE 12.1.1
product: FTP - Transfer Pricing , meaning: Repricing Type , description: Repricing Type ,
Lookup Type: FTP_COND_COMPARE_TYPE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Condition Compare Type Code ,
Lookup Type: FTP_PPR_CASH_FLOW_TREATMENT 12.1.1
product: FTP - Transfer Pricing , meaning: PPR_CASH_FLOW , description: PPR_CASH_FLOW_TREATMENT ,
Lookup Type: FTP_TIME_MULTIPLIER 12.1.1
product: FTP - Transfer Pricing , meaning: Multiplier , description: Multiplier ,
Lookup Type: FTP_TPP_RND_NUM_METHOD 12.1.1
product: FTP - Transfer Pricing , meaning: Random Number Generation Method ,
Lookup Type: FTP_PPTB_METHOD_TYPE 12.1.1
product: FTP - Transfer Pricing , meaning: Interpolation Flag , description: Dimension Option Interpolation Flag ,
Lookup Type: FTP_TPP_CALC_MODE 12.1.1
product: FTP - Transfer Pricing , meaning: Calculation Mode ,
Lookup Type: FTP_REPRICE_PATTERN_TYPE 12.1.1
product: FTP - Transfer Pricing , meaning: Repricing Pattern Type , description: Repricing Pattern Type ,
Lookup Type: FTP_TP_OPT_CODE_METHOD 12.1.1
product: FTP - Transfer Pricing , meaning: Option Cost Method , description: Option Cost Method ,
Lookup Type: FTP_DATA_SOURCE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Data Source , description: Data Source ,
Lookup Type: FTP_TPP_ACCRL_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Accrual Code ,
Lookup Type: FTP_CONDITION_DATA_TYPE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Condition Data Type Code ,
Lookup Type: FTP_ADJR_REF_TERM_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Reference Term , description: Reference Term ,
Lookup Type: FTP_DEFINED_NOTDEFINED_CD 12.1.1
product: FTP - Transfer Pricing , meaning: Defined or Not Defined Status , description: Defined or Not Defined Status ,
Lookup Type: FTP_ADJR_ASSIGN_DATE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Origination Date , description: Origination Date ,
Lookup Type: FTP_PPR_RATE_TERM_CD 12.1.1
product: FTP - Transfer Pricing , meaning: PPR_RATE_TERM_CODE , description: PPR_RATE_TERM_CODE ,
Lookup Type: FTP_PAYMENT_PATTERN_SPLIT_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Payment Pattern Type (Split) , description: Payment Pattern Type (Split) ,
Lookup Type: FTP_IRCS_FORMAT_ID 12.1.1
product: FTP - Transfer Pricing , meaning: FTP_IRCS_FORMAT ,
Lookup Type: FTP_TP_OPT_COST_METHOD_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Transfer Price Option Cost Method , description: Transfer Price Option Cost Method ,
Lookup Type: FTP_TPP_CALC_RECORDS 12.1.1
product: FTP - Transfer Pricing , meaning: CALC_RECORDS ,
Lookup Type: FTP_YES_NO_CD 12.1.1
product: FTP - Transfer Pricing , meaning: Yes or No , description: Yes or No ,
Lookup Type: FTP_PAYMENT_METHOD_LVLP_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Payment Method Code (Level Principal) , description: Payment Method Code (Level Principal) ,
Lookup Type: FTP_PPR_CAL_METHOD 12.1.1
product: FTP - Transfer Pricing , meaning: Prepayment Rule Calculation Method , description: Prepayment Calculatiom Method ,
Concurrent Program: FTPPAYMTSCLLDR 12.1.1
execution_filename: FTP_PAYMENT_SCHEDULE_PKG.TRANSFERDATA , product: FTP - Transfer Pricing , user_name: FTPPAYMENTSCHEDULE , description: Payment Schedule Data Loader Program , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: FTP_TPP_SMOOTHING_METHOD 12.1.1
product: FTP - Transfer Pricing , meaning: Smoothing Method ,
Concurrent Program: FTPIRCPARAM 12.1.1
execution_filename: FTP_IRC_ADI_MIGRATE.migrateparameters , product: FTP - Transfer Pricing , user_name: FTPIRCPARAM , description: IRC Parameter Loader , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: FTP_TP_DATA_SOURCE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Transfer Price Data Source , description: Transfer Price Data Source ,
Lookup Type: FTP_ADJR_CALC_METHOD_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Adjustment Method , description: Adjustment Method ,
Lookup Type: FTP_TP_ASSIGN_DATE_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Assignment Date , description: Assignment Date ,
Lookup Type: FTP_IRC_EFFECTIVE_DATE_FILTERS 12.1.1
product: FTP - Transfer Pricing , meaning: Interest Rate Code Effective Date Filters , description: Interest Rate Code Effective Date Filters ,
Lookup Type: FTP_TPP_TERM_STRUCT_MODEL 12.1.1
product: FTP - Transfer Pricing , meaning: Term Structure Model ,
Lookup Type: FTP_TP_TARGET_BAL_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: Target Balance , description: Target Balance ,
Lookup Type: FTP_INST_TYPES_CODE 12.1.1
product: FTP - Transfer Pricing , meaning: INSTRUMENT_TYPES_CODE ,
Lookup Type: FTP_COMPOUND_BASIS_ID 12.1.1
product: FTP - Transfer Pricing , meaning: COMPOUND_BASIS_ID ,
Lookup Type: FTP_MONTH 12.1.1
product: FTP - Transfer Pricing , meaning: Month , description: Month ,
Lookup Type: FTP_PPTB_DIMENSION_DES 12.1.1
product: FTP - Transfer Pricing , meaning: Dimension Options ,
File: FTPProduct_Dependencies.html 12.1.1
product: FTP - Transfer Pricing , size: 15.329 KBytes , file_type: HTML Report , description: FTPProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the FTP product. ,
File: FTP_Tables.html 12.1.1
product: FTP - Transfer Pricing , size: 14.473 KBytes , file_type: HTML Report , description: FTP_Tables.html is an html report that documents the table and view definitions for the FTP product. ,