Infor O2C process configuration Insight for Oracle
The following table lists the rule books and rules impacted if a table is excluded from extraction. No reports will be impacted.
| Excluded table | Rule book name | Rule name |
|---|---|---|
| AP_BANK_ACCOUNTS_ALL | ||
| AP_BANK_BRANCHES | ||
| AP_BANK_CHARGES | ||
| AP_PAYMENT_PROGRAMS | ||
| AP_REPORTING_ENTITIES_
ALL |
||
| AP_REPORTING_ENTITY_
LINES_ALL |
||
| AR_AGING_BUCKET_LINES_
B |
||
| AR_AGING_BUCKETS | ||
| AR_APP_RULE_DETAILS | ||
| AR_APP_RULE_SETS | ||
| AR_APPROVAL_USER_
LIMITS |
ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the Approval Limits baseline attributes |
| AR_AUTOCASH_
HIERARCHIES |
||
| AR_AUTOCASH_RULES | ||
| AR_BATCH_SOURCES_ALL | ||
| AR_COLLECTORS | ||
| AR_CUST_PROF_CLASS_
AMOUNTS |
||
| AR_DISTRIBUTION_SET_
LINES_ALL |
||
| AR_DISTRIBUTION_SETS_
ALL |
||
| AR_DUNNING_LETTER_SET_
LINES |
||
| AR_DUNNING_LETTER_SETS | ||
| AR_DUNNING_LETTERS_B | ||
| AR_DUNNING_LETTERS_
CUSTOM_TL |
||
| AR_LOCATION_
COMBINATIONS |
||
| AR_LOCATION_RATES | ||
| AR_LOCATION_VALUES | ||
| AR_LOCKBOXES_ALL | ||
| AR_MEMO_LINES_ALL_B | ||
| AR_RECEIPT_CLASSES | ||
| AR_RECEIPT_METHOD_
ACCOUNTS_ALL |
||
| AR_RECEIPT_METHODS | ||
| AR_RECEIVABLES_TRX_ALL | ||
| AR_SALES_TAX | ||
| AR_STATEMENT_CYCLE_
DATES_ALL |
||
| AR_STATEMENT_CYCLES | ||
| AR_SYSTEM_PARAMETERS
_ALL |
ORCL_CI_O2C_Process_
Configurations |
Assess whether 'Address Validation' is set to 'No Validation' in the home country Assess whether 'Allow Payment of Unrelated Transactions' option is enabled Assess whether 'Allow Transaction Deletion' flag is enabled Assess whether the 'Allow Change to Printed Transaction' box is enabled Assess whether the 'Allow Override' option is not enabled in the Receivable System Options for tax related setup Assess whether the 'Inclusive Tax Used' option is not checked in the Receivable System Options for tax related setup |
| AR_TAX_CONDITION_ACTIONS_ALL | ||
| AR_TAX_CONDITIONS_ALL | ||
| AR_TAX_GROUP_CODES_
ALL |
||
| AR_TRANS_FIELD_
FORMATS |
||
| AR_TRANS_RECORD_
FORMATS |
||
| AR_TRANSMISSION_
FORMATS |
||
| AR_VAT_TAX_ALL_B | ORCL_CI_O2C_Process_
Configurations |
Assess whether the tax codes defined in the system are not enabled |
| BOM_PARAMETERS | ||
| BOM_RESOURCES | ||
| CST_CG_WIP_ACCT_
CLASSES |
||
| CST_COST_GROUP_
ACCOUNTS |
||
| CST_COST_GROUPS | ||
| CST_COST_TYPES | ||
| CST_ITEM_OVERHEAD_
DEFAULTS |
||
| ENG_CHANGE_ORDER_
TYPES |
||
| ENG_CHANGE_PRIORITIES | ||
| ENG_CHANGE_TYPE_
PROCESSES |
||
| FND_APPLICATION | ||
| FND_COLUMNS | ||
| FND_CURRENCIES | ||
| FND_DEFAULT_CONTEXT_
FIELDS |
||
| FND_DESCRIPTIVE_FLEXS | ||
| FND_DOC_SEQUENCE_
ASSIGNMENTS |
||
| FND_DOC_SEQUENCE_
CATEGORIES |
||
| FND_DOCUMENT_
CATEGORIES |
||
| FND_DOCUMENT_
DATATYPES |
||
| FND_DOCUMENT_
SEQUENCES |
ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of Document Sequences baseline attributes |
| FND_DOCUMENTS | ||
| FND_GRANTS | ||
| FND_ID_FLEX_STRUCTURES | ORCL_CI_O2C_Process_
Configurations |
Assess whether the 'Cross-Validate Segments' option is not enabled in the Define Key Flexfields form Assess whether the 'Enabled' option is not checked in the Key Flexfields form Assess whether the 'Freeze Flexfield Definition' box is not checked in the Define Key Flexfields form Detect changes made to any of the 'Key Flexfields' baseline attributes Assess whether the access level is not set to 'User' in the lookup types Assess whether the 'Enabled' Checkbox is not checked in the Lookup types form |
| FND_LOOKUP_TYPES | ||
| FND_LOOKUP_VALUES | ||
| FND_MENUS | ||
| FND_PRODUCT_GROUPS | ||
| FND_PROFILE_OPTIONS | ||
| FND_RESPONSIBILITY | ||
| FND_USER | ||
| GL_CODE_COMBINATIONS | ORCL_CI_O2C_Process_
Configurations |
Assess whether the 'Enabled' option is not checked in the GL Accounts form Detect changes made to the GL Accounts form baseline attributes |
| GL_DAILY_CONVERSION_
TYPES |
||
| GL_DAILY_RATES | ||
| GL_NET_INCOME_
ACCOUNTS |
||
| GL_PERIOD_SETS | ||
| GL_PERIOD_STATUSES | ||
| GL_PERIOD_TYPES | ||
| GL_PERIODS | ||
| GL_SETS_OF_BOOKS | ||
| GL_SUSPENSE_ACCOUNTS | ||
| GL_TAX_OPTION_
ACCOUNTS |
||
| GL_TAX_OPTIONS | ||
| GL_TRANSACTION_
CALENDAR |
||
| GL_TRANSLATION_RATES | ||
| HZ_CUST_PROFILE_
CLASSES |
ORCL_CI_O2C_Process_
Configurations |
Assess whether the credit check box in the Credit Profile is not enabled Detect changes made to any of Customer Profile class baseline attributes |
| MTL_ATP_RULES | ||
| MTL_CATEGORIES_B | ||
| MTL_CATEGORY_
ACCOUNTS |
||
| MTL_CATEGORY_SET_
VALID_CATS |
||
| MTL_CATEGORY_SETS_B | ||
| MTL_COMMODITY_CODES | ||
| MTL_COUNTRY_
ASSIGNMENTS |
||
| MTL_DEFAULT_
CATEGORY_SETS |
||
| MTL_DESCRIPTIVE_
ELEMENTS |
||
| MTL_ECONOMIC_ZONES_B | ||
| MTL_FORECAST_RULES | ||
| MTL_GENERIC_
DISPOSITIONS |
||
| MTL_INTERCOMPANY_
PARAMETERS |
||
| MTL_INTERFACE_PROC_
CONTROLS |
||
| MTL_INTERORG_
PARAMETERS |
||
| MTL_INTERORG_SHIP_
METHODS |
||
| MTL_ITEM_ATTRIBUTES | ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the Item Attribute Controls baseline attributes |
| MTL_ITEM_CATEGORIES | ||
| MTL_ITEM_LOCATIONS | ||
| MTL_ITEM_SUB_DEFAULTS | ||
| MTL_ITEM_SUB_
INVENTORIES |
||
| MTL_ITEM_TEMPL_
ATTRIBUTES |
||
| MTL_ITEM_TEMPLATES | ||
| MTL_LE_ECONOMIC_ZONES | ||
| MTL_MATERIAL_STATUSES_
TL |
||
| MTL_MVT_STATS_RULE_
SETS_B |
||
| MTL_MVT_STATS_RULES | ||
| MTL_PARAMETERS | ORCL_CI_O2C_Process_
Configurations |
Assess whether 'allow negative balances' option is enabled |
| MTL_PICKING_RULES | ||
| MTL_PLANNERS | ||
| MTL_SECONDARY_
INVENTORIES |
||
| MTL_STATUS_ATTRIBUTE_
VALUES |
||
| MTL_SYSTEM_ITEMS_B | ||
| MTL_TRANSACTION_
REASONS |
||
| MTL_TRANSACTION_TYPES | ||
| MTL_TXN_SOURCE_TYPES | ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the transaction types defined for respective Source Types baseline attributes |
| MTL_UNITS_OF_MEASURE_
TL |
||
| MTL_UOM_CLASS_
CONVERSIONS |
||
| MTL_UOM_CLASSES_TL | ||
| MTL_UOM_CONVERSIONS | ||
| OE_CREDIT_CHECK_RULES | ||
| OE_CUST_ITEM_SETTINGS | ORCL_CI_O2C_Process_
Configurations |
Assess whether the Over Shipment tolerance is not entered Assess whether the Under Shipment tolerance is not entered |
| OE_DEF_ATTR_CONDNS | ||
| OE_DEF_CONDN_ELEMS | ||
| OE_HOLD_
AUTHORIZATIONS |
ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the setup for various types of holds for orders or return line baseline attributes |
| OE_ORDER_SOURCES | ||
| OE_PC_ASSIGNMENTS | ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the processing constraints baseline attributes |
| OE_PC_RSET_SEL_COLS | ||
| OE_PC_RSETS | ||
| OE_SALES_CREDIT_TYPES | ||
| OE_SYSTEM_PARAMETERS
_ALL |
||
| OE_TRANSACTION_TYPES_
ALL |
||
| ORG_ACCESS | ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the Organization Access baseline attributes |
| PER_ORG_STRUCTURE_
ELEMENTS |
||
| PER_ORG_STRUCTURE_
VERSIONS |
||
| PER_ORGANIZATION_
STRUCTURES |
||
| RA_ACCOUNT_DEFAULT_
SEGMENTS |
||
| RA_ACCOUNT_DEFAULTS_
ALL |
||
| RA_BATCH_SOURCES_
ALL |
||
| RA_CUST_TRX_TYPES_ALL | ORCL_CI_O2C_Process_
Configurations |
Assess whether 'Over Application' box is enabled in the Transaction types form Assess whether the 'Open receivable' option is not enabled for transaction types Assess whether the 'tax calculation' option is not enabled the for transaction types Detect changes made to any of the Transaction types baseline attributes Detect changes made to any of the Auto Invoice Line Ordering Lines baseline attributes Detect changes made to any of the Grouping Rules baseline attributes |
| RA_GROUP_BYS | ||
| RA_GROUPING_RULES | ||
| RA_ITEM_EXCEPTION_
RATES |
||
| RA_LINE_ORDER_BYS | ||
| RA_LINE_ORDERING_RULES | ||
| RA_RULE_SCHEDULES | ||
| RA_TAX_EXEMPTIONS_ALL | ||
| RA_TERMS_B | ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the standard Payment terms for customers baseline attributes |
| RA_TERMS_LINES | ||
| RA_TERMS_LINES_
DISCOUNTS |
||
| RCV_PARAMETERS | ORCL_CI_O2C_Process_
Configurations |
Assess whether blind receiving is enabled Assess whether substitute receipts are allowed Assess whether the over receipt option is established at greater than 10% Assess whether unordered receipts are allowed Detect changes made to any of the Receiving Option baseline attributes |
| RCV_ROUTING_HEADERS | ||
| WSH_CALENDAR_
ASSIGNMENTS |
||
| WSH_DOC_SEQUENCE_
CATEGORIES |
||
| WSH_EXCEPTION_
DEFINITIONS_B |
||
| WSH_FREIGHT_COST_
TYPES |
||
| WSH_GRANTS | ||
| WSH_PICK_GROUPING_
RULES |
||
| WSH_PICK_SEQUENCE_
RULES |
ORCL_CI_O2C_Process_
Configurations |
Detect changes made to any of the 'Release Sequence Rules' baseline attributes |
| WSH_REPORT_SET_LINES | ||
| WSH_ROLES | ||
| WSH_SHIPPING_
PARAMETERS |