Search Results comment avoir des abonnee telegramme gratuitement a partie de son laptop

The DK_ATP_TABLE Lookup Type in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical configuration element used within the Advanced Supply Chain Planning (ASCP) and Global Order Promising (GOP) modules to define Available-to-Promise (ATP) rules. ATP functionality enables organizations to determine product availability in real-time, ensuring accurate order promising and fulfillment. The DK_ATP_TABLE Lookup Type serves as a reference for defining ATP rule assignments at various levels, such as items, organizations, or customer segments, and plays a pivotal role in supply chain optimization.

Purpose and Functionality

The primary purpose of the DK_ATP_TABLE Lookup Type is to categorize and map ATP rules to specific business scenarios. It acts as a repository of predefined values that determine how ATP calculations are performed based on criteria like sourcing rules, lead times, and inventory policies. This Lookup Type is typically accessed via the Oracle Inventory or Order Management modules, where ATP rules are configured and applied during order entry, scheduling, or replenishment processes.

Key Components

The DK_ATP_TABLE Lookup Type consists of the following key components:

Lookup Code: A unique identifier for each ATP rule (e.g., "ATP_DEFAULT," "ATP_PRIORITY").
Meaning: A descriptive name explaining the ATP rule's purpose (e.g., "Default ATP Rule," "Priority Customer ATP").
Description: Detailed documentation of the rule's logic and applicability.
Enabled Flag: Indicates whether the rule is active for use in ATP calculations.

Configuration and Usage

In Oracle EBS 12.1.1 and 12.2.2, the DK_ATP_TABLE Lookup Type is configured via the Application Developer responsibility:

Navigate to Application Developer > Application > Lookups > Define.
Query the Lookup Type DK_ATP_TABLE to view or modify existing entries.
Add new codes as needed to reflect custom ATP rules.

Once defined, these rules are referenced in:

Inventory ATP Rules: Assign rules to items or categories via Inventory > Setup > ATP Rules.
Order Management: Apply rules during order entry to validate availability.
ASCP/GOP: Integrate with planning engines for supply-demand matching.

Technical Integration

The DK_ATP_TABLE Lookup Type integrates with underlying Oracle tables such as MTL_ATP_RULES and DOO_ATP_RULES, which store ATP rule assignments. It is also referenced in PL/SQL APIs like MRP_ATP_PUB.Call_ATP, which executes ATP checks during order processing.

Best Practices

Standardize naming conventions for Lookup Codes to ensure clarity.
Document each rule's business logic in the Description field.
Test new ATP rules in a non-production environment before deployment.
Monitor performance impacts of complex ATP rules on order processing.

Conclusion

The DK_ATP_TABLE Lookup Type is a foundational element in Oracle EBS 12.1.1 and 12.2.2 for managing ATP functionality. By providing a structured framework for ATP rule definition, it enables organizations to align supply chain operations with business priorities, ensuring accurate and efficient order fulfillment. Proper configuration and maintenance of this Lookup Type are essential for optimizing inventory visibility and customer service levels.

Lookup Type: PAY_MX_STATE_IDS 12.1.1
product: PAY - Payroll , meaning: State IDs for Mexico Year End Reporting ,
Lookup Type: PAY_MX_STATE_IDS 12.2.2
product: PAY - Payroll , meaning: State IDs for Mexico Year End Reporting ,
Lookup Type: PQP_FUEL_TYPE 12.2.2
product: PAY - Payroll , meaning: PQP_FUEL_TYPE , description: Fuel Types ,
Lookup Type: PAY_CA_DP_OR_DE 12.1.1
product: PAY - Payroll , meaning: PAY_CA_DP_OR_DE , description: Date Paid or Date Earned ,
Lookup Type: PAY_CA_DP_OR_DE 12.2.2
product: PAY - Payroll , meaning: PAY_CA_DP_OR_DE , description: Date Paid or Date Earned ,
Lookup Type: PQP_FUEL_TYPE 12.1.1
product: PAY - Payroll , meaning: PQP_FUEL_TYPE , description: Fuel Types ,
Lookup Type: BE_BANK 12.1.1
product: PAY - Payroll , meaning: BE BANK , description: Belgian bank names ,
Lookup Type: BE_BANK 12.2.2
product: PAY - Payroll , meaning: BE BANK , description: Belgian bank names ,
Lookup Type: PQP_US_COUNTRY_TRANSLATE 12.1.1
product: PAY - Payroll , meaning: PQP_US_COUNTRY_TRANSLATE , description: Translates country from Oracle application to IRS country codes ,
Lookup Type: PQP_US_COUNTRY_TRANSLATE 12.2.2
product: PAY - Payroll , meaning: PQP_US_COUNTRY_TRANSLATE , description: Translates country from Oracle application to IRS country codes ,
Lookup Type: PAY_US_OTF_PDF_LINK_W4 12.2.2
product: PAY - Payroll , meaning: W4 Tax Form PDF Links , description: W4 Form Links used in Self-Service Tax Form ,
Lookup Type: NO_EOY_REPORTING_CODE 12.1.1
product: PAY - Payroll , meaning: NO_EOY_REPORTING_CODE , description: Norwegian End of Year Reporting Codes ,
Lookup Type: PAY_CA_RL1_FOOTNOTES 12.2.2
product: PAY - Payroll , meaning: RL1 footnotes , description: Footnotes for RL1 slips ,
Lookup Type: NO_EOY_REPORTING_CODE 12.2.2
product: PAY - Payroll , meaning: NO_EOY_REPORTING_CODE , description: Norwegian End of Year Reporting Codes ,
Lookup Type: DK_ATP_TABLE 12.1.1
product: PAY - Payroll , meaning: DK_ATP_TABLE , description: Lookup to show list of pension schemes available for ATP pension calculation. ,
Lookup Type: DK_ATP_TABLE 12.2.2
product: PAY - Payroll , meaning: DK_ATP_TABLE , description: Lookup to show list of pension schemes available for ATP pension calculation. ,
Lookup Type: PAY_CA_RL1_FOOTNOTES 12.1.1
product: PAY - Payroll , meaning: RL1 footnotes , description: Footnotes for RL1 slips ,
Table: PAY_RUN_TYPE_ORG_METHODS_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_RUN_TYPE_ORG_METHODS_F_EFC, object_name:PAY_RUN_TYPE_ORG_METHODS_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_RUN_TYPE_ORG_METHODS_F_EFC ,
Table: PAY_RUN_TYPE_ORG_METHODS_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_RUN_TYPE_ORG_METHODS_F_EFC, object_name:PAY_RUN_TYPE_ORG_METHODS_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_RUN_TYPE_ORG_METHODS_F_EFC ,
Table: PAY_REPORT_FORMAT_MAPPINGS_F 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_REPORT_FORMAT_MAPPINGS_F, object_name:PAY_REPORT_FORMAT_MAPPINGS_F, status:VALID, product: PAY - Payroll , description: Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape. , implementation_dba_data: HR.PAY_REPORT_FORMAT_MAPPINGS_F ,
Table: PAY_PRE_PAYMENTS_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_PRE_PAYMENTS_EFC, object_name:PAY_PRE_PAYMENTS_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_PRE_PAYMENTS_EFC ,
Table: PAY_REPORT_FORMAT_MAPPINGS_F 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_REPORT_FORMAT_MAPPINGS_F, object_name:PAY_REPORT_FORMAT_MAPPINGS_F, status:VALID, product: PAY - Payroll , description: Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape. , implementation_dba_data: HR.PAY_REPORT_FORMAT_MAPPINGS_F ,
Table: PAY_PAYROLL_ACTIONS_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_PAYROLL_ACTIONS_EFC, object_name:PAY_PAYROLL_ACTIONS_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_PAYROLL_ACTIONS_EFC ,
Table: PAY_PRE_PAYMENTS_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_PRE_PAYMENTS_EFC, object_name:PAY_PRE_PAYMENTS_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_PRE_PAYMENTS_EFC ,
Table: PAY_PAYROLL_ACTIONS_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_PAYROLL_ACTIONS_EFC, object_name:PAY_PAYROLL_ACTIONS_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_PAYROLL_ACTIONS_EFC ,
Lookup Type: FR_DADS_BIRTH_DEPT_CODE 12.1.1
product: PAY - Payroll , meaning: Birth Department Code for DADS-U ,
Lookup Type: FR_DADS_BIRTH_DEPT_CODE 12.2.2
product: PAY - Payroll , meaning: Birth Department Code for DADS-U ,
Table: PAY_COSTS_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_COSTS_EFC, object_name:PAY_COSTS_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_COSTS_EFC ,
Table: PAY_COSTS_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_COSTS_EFC, object_name:PAY_COSTS_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_COSTS_EFC ,
Table: PAY_ELEMENT_ENTRY_VALUES_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ELEMENT_ENTRY_VALUES_F_EFC, object_name:PAY_ELEMENT_ENTRY_VALUES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_ELEMENT_ENTRY_VALUES_F_EFC ,
Table: PAY_PERSONAL_PAYMENT_METHO_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_PERSONAL_PAYMENT_METHO_EFC, object_name:PAY_PERSONAL_PAYMENT_METHO_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_PERSONAL_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_PERSONAL_PAYMENT_METHO_EFC ,
Table: PAY_ORG_PAYMENT_METHODS_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ORG_PAYMENT_METHODS_F_EFC, object_name:PAY_ORG_PAYMENT_METHODS_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_ORG_PAYMENT_METHODS_F_EFC ,
Table: PAY_GRADE_RULES_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_GRADE_RULES_F_EFC, object_name:PAY_GRADE_RULES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_GRADE_RULES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_GRADE_RULES_F_EFC ,
Table: PAY_PERSONAL_PAYMENT_METHO_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_PERSONAL_PAYMENT_METHO_EFC, object_name:PAY_PERSONAL_PAYMENT_METHO_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_PERSONAL_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_PERSONAL_PAYMENT_METHO_EFC ,
Table: PAY_ELEMENT_TYPES_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ELEMENT_TYPES_F_EFC, object_name:PAY_ELEMENT_TYPES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_ELEMENT_TYPES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_ELEMENT_TYPES_F_EFC ,
Table: PAY_LINK_INPUT_VALUES_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_LINK_INPUT_VALUES_F_EFC, object_name:PAY_LINK_INPUT_VALUES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_LINK_INPUT_VALUES_F_EFC ,
Table: PAY_BALANCE_TYPES_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_BALANCE_TYPES_EFC, object_name:PAY_BALANCE_TYPES_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_BALANCE_TYPES_EFC ,
Table: PAY_RUN_RESULT_VALUES_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_RUN_RESULT_VALUES_EFC, object_name:PAY_RUN_RESULT_VALUES_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_RUN_RESULT_VALUES_EFC ,
Table: PAY_ORG_PAYMENT_METHODS_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ORG_PAYMENT_METHODS_F_EFC, object_name:PAY_ORG_PAYMENT_METHODS_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_ORG_PAYMENT_METHODS_F_EFC ,
Table: PAY_INPUT_VALUES_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_INPUT_VALUES_F_EFC, object_name:PAY_INPUT_VALUES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_INPUT_VALUES_F_EFC ,
Table: PAY_RUN_RESULT_VALUES_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_RUN_RESULT_VALUES_EFC, object_name:PAY_RUN_RESULT_VALUES_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_RUN_RESULT_VALUES_EFC ,
Table: PAY_LINK_INPUT_VALUES_F_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_LINK_INPUT_VALUES_F_EFC, object_name:PAY_LINK_INPUT_VALUES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_LINK_INPUT_VALUES_F_EFC ,
Table: PAY_INPUT_VALUES_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_INPUT_VALUES_F_EFC, object_name:PAY_INPUT_VALUES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_INPUT_VALUES_F_EFC ,
Table: PAY_ELEMENT_ENTRY_VALUES_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ELEMENT_ENTRY_VALUES_F_EFC, object_name:PAY_ELEMENT_ENTRY_VALUES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_ELEMENT_ENTRY_VALUES_F_EFC ,
Table: PAY_BALANCE_TYPES_EFC 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_BALANCE_TYPES_EFC, object_name:PAY_BALANCE_TYPES_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_BALANCE_TYPES_EFC ,
Table: PAY_GRADE_RULES_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_GRADE_RULES_F_EFC, object_name:PAY_GRADE_RULES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_GRADE_RULES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_GRADE_RULES_F_EFC ,
Table: PAY_ELEMENT_TYPES_F_EFC 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ELEMENT_TYPES_F_EFC, object_name:PAY_ELEMENT_TYPES_F_EFC, status:VALID, product: PAY - Payroll , description: This is a copy of the PAY_ELEMENT_TYPES_F table which is populated by the EFC (Euro as a Functional Currency) process. , implementation_dba_data: HR.PAY_ELEMENT_TYPES_F_EFC ,
Concurrent Program: PYINVREQ 12.2.2
execution_filename: PAY_FLOW_REQUESTS_PKG.invoke_request , product: PAY - Payroll , user_name: PYINVREQ , description: Invokes the parent request for a process flow , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAYRPACT 12.1.1
execution_filename: PAYRPACT , product: PAY - Payroll , user_name: PAYRPACT , description: List Payroll Actions for a Person , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PAYRPACT 12.2.2
execution_filename: PAYRPACT , product: PAY - Payroll , user_name: PAYRPACT , description: List Payroll Actions for a Person , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,