You are browsing the archive for Setups.

Customer Profile Classes Setup

 

Form Application: Oracle Accounts Receivables
Form Name: ARXMACPC
Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/ar/12.0.0/forms/US/ARXMACPC.fmx

Customer Profile classes consists of setting up limits/rules for credit checks, payment terms etc. Once profile classes are setup they can be assigned to customers.

Customer Profile Classes Setup - Oracle Accounts Receivables
Description
Customer profile classes supports setting up rules for customers and later they can be assigned to customers.
For detailed tutorial on how to setup customer profile classes in Oracle Accounts Receivables visit us at http://oracleappscommunity.com/oracle/blog/9261/customer-profile-classes-setup/

 

Navigation: Login to Oracle Apps -> Select Accounts Receivables responsibility -> Setup

  • Navigate to  Customers -> Profile Classes
  • Query any existing profile class to modify or enter new profile class name
  • Enter the Profile Class Name
  • Enter Profile Class description
  • Check the ‘Active’ flag to make profile class active
  • Setup ‘Profile Class’ tab fields
  •     Balance forwarding enable
  •     Bill level
  •     Bill type
  •     Invoice Tax printing rule
  •     Invoice grouping rule
  •     Payment terms
  •     Allow discount
  •     Override terms
  •     Discount grace days
  •     Send statements
  •     Send credit balance
  •     Send dunning letters
  •     Collector name
  •     Collector classification
  •     Periodic review cycle
  •     Analyst
  •     Tolerance %
  •     Credit Check
  •     Match Receipts by
  •     Auto cash rule set
  •     Remainder rule set
  •     Auto receipts include disputed items
  • Setup ‘Late Charge Profile’ tab fields
  •     Enable late charges
  •     Charge calculation
  •     Additional Charges & Reductions – Credit items & disputed transactions
  •     Late charge type
  •     Payment term
  •     Message text
  •     Interest calculation formula
  •     Interest calculation period
  •     Days in period
  •     Receipt grace days
  •     Hold charged invoices
  •     Charge beginning date
  •     Use multiple interest dates
  • Setup ‘Profile Class Amounts’ tab fields
  •     Credit limit amount
  •     Order credit limit amount
  •     Minimum receipt amount
  •     Minimum statement amount
  •     Exchange rate type
  •     Minimum customer balance tolerance
  •     Minimum Invoice balance
  •     Minimum charge per invoice
  •     Interest charge type
  •     Interest charge value
  •     Charge schedule rule
  •     Penalty charge type
  •     Penalty charge value
  •     Penalty charge schedule rule

Save the changes

Receivables Profile Options

Oracle Account Receivables Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
AR_ENABLE_CREDIT_CARD_PREPROC AR: Enable Credit Card Preprocessor
AR_ENABLE_CROSS_CURRENCY AR: Enable Cross Currency
AR_ENABLE_DEBUG_OUTPUT AR: Enable Debug Message Output
AR_ENABLE_SQL_TRACE AR: Enable SQL trace
AR_GLPOST_BALANCE_CHECK_FLAG AR: GL Transfer Balance Test
AR_INCL_RECEIPTS_AT_RISK AR: Include Receipts At Risk In Customer Balance
AR_ITEM_FLEXFIELD_MODE AR: Item Flexfield Mode
AR_JG_CREATE_BANK_CHARGES AR: Create Bank Charges
AR_MASK_BANK_ACCOUNT_NUMBERS AR: Mask Bank Account Numbers
AR_OVERRIDE_ADJUSTMENT_ACTIVITY_ACCOUNT AR: Override Adjustment Activity Account Option
AR_PA_CODE AR: Transaction Flexfield QuickPick Attribute
AR_POWERCASH_ALLOW_ACTIONS AR: Cash – Allow Actions
AR_RA_BATCH_SOURCE AR: Transaction Batch Source
AR_SHOW_BILLING_NUMBER AR: Show Billing Number
AR_TAX_USE_PLSQL_VENDOR Tax: Use Tax PL/SQL Vendor
AR_TAX_USE_VENDOR Tax: Use Tax Vendor
AR_UPDATE_DUE_DATE AR: Update Due Date
AR_USE_INV_ACCT_FOR_CM_FLAG AR: Use Invoice Accounting For Credit Memos
AR_ZENGIN_CHAR_SET AR: Zengin Character Set
HZ_SEARCH_RULE DQM Match Rule for Search
HZ_SPECIAL_CHARACTERS_ENABLED HZ: Special Characters Enabled
HZ_API_DBMS_DEBUG_ON HZ: Turn On Development Debug
HZ_API_DEBUG_FILE_NAME HZ: API Debug File Name
HZ_API_DEBUG_FILE_PATH HZ: API Debug File Directory
HZ_API_ERR_ON_OBSOLETE_COLUMN HZ: Report Error on Obsolete Columns
HZ_ADDRESS_KEY_INDEX HZ: Address Key Index
HZ_ADDRESS_KEY_LENGTH HZ: Address Key Length
HZ_DUPLICATE_ALLOWED HZ: Duplicate Allowed
HZ_KEY_WORD_COUNT HZ: Key Word Count
HZ_POSTAL_CODE_KEY_LENGTH HZ: Postal Code Key Length
AR_BR_BATCH_SOURCE AR: Bills Receivable Batch Source
AR_BR_WO_RECOURSE AR: Factor / Endorse Bills Receivables without Recourse
HZ_INTERNAL_PARTY HZ: Internal Party
ARTACCSY_CRSUMM_RATIO ARTA: Use deposit or apply date in customer credit summary ratios
AR_TA_CASHENG_LOGFILE_DIR ARTA: Directory path for TA log files
AR_TA_INC_DED_IN_TOTEXP ARTA:Include deductions in total exposure
AR_TA_MSG_LEVEL_THRESHOLD ARTA: Message level threshold
AR_TA_SYS_ESS_INST ARTA: System ESS Installed
HZ_EXECUTE_API_CALLOUTS HZ: Raise API Events
HZ_GENERATE_CONTACT_NUMBER HZ: Generate Contact Number
AR_IREC_ADMIN_EMAIL AR: iReceivables System Administrator Email
AR_CREDIT_LIMIT_SELECTION AR: Credit Limit Selection
RA_CUSTOMERS_ENTER_PHONETICS AR: Customers – Enter Alternate Fields
RA_CUSTOMERS_SORT_BY_PHONETICS AR: Sort Customer Reports by Alternate Fields
SERVER_TIMEZONE_ID Server Timezone
TAXVDR_CASESENSITIVE Tax Vertex: Case Sensitive
TAXVDR_SECTAXS Tax Vertex: Secondary Taxes
TAXVDR_SERVICEIND Tax Taxware: Service Indicator
TAXVDR_TAXSELPARAM Tax Taxware: Tax Selection
TAXVDR_TAXTYPE Tax Taxware: Tax Type
TAXVDR_USENEXPRO Tax Taxware: Use Nexpro
TAX_DEBUG_FILE_LOCATION Tax: Debug File Directory
TAX_DEBUG_FLAG Tax: Debug Flag
AR_TA_EXCHANGE_RATE_FOR_DEDUCTION AR: Exchange rate details for deductions
CLIENT_TIMEZONE_ID Client Timezone
HZ_GENERATE_PARTY_NUMBER HZ: Generate Party Number
HZ_GENERATE_PARTY_SITE_NUMBER HZ: Generate Party Site Number
AR_ADJUST_CREDIT_UNCONFIRMED_INVOICE AR: Invoices with Unconfirmed Receipts
AR_ALLOW_MANUAL_TAX_LINES Tax: Allow Manual Tax Lines
AR_ALLOW_OVERAPPLICATION_IN_LOCKBOX AR: Allow Overapplication In Lockbox
AR_ALLOW_SALESCREDIT_UPDATE AR: Allow Update Of Existing Sales Credits
AR_ALLOW_TAX_CODE_OVERRIDE Tax: Allow Override of Tax Code
AR_ALLOW_TAX_UPDATE Tax: Allow Ad Hoc Tax Changes
AR_ALLOW_TRX_LINE_EXEMPTIONS Tax: Allow Override of Customer Exemptions
AR_ALT_NAME_SEARCH AR: Alternate Name Search
AR_APPLICATION_GL_DATE_DEFAULT AR: Application GL Date Default
AR_ARCABP_DEBUG_LEVEL AR: Debug Level for Lockbox and PostBatch
AR_ARDLP_REMIT_SIZE AR: Dunning Letter Remit-To Address Label Size
AR_ARLPLB_COMMIT_OPTION AR: Commit between validations in Lockbox
AR_AUTOMATIC_CONTACT_NUMBERING AR: Automatic Contact Numbering
AR_AUTOMATIC_RECEIPT_CREATION_ACTION AR: Automatic Receipt Creation Authority
AR_AUTOMATIC_REMITTANCE_CREATION_ACTION AR: Automatic Remittance Creation Authority
AR_AUTO_ARXCER_FLAG AR: Close Periods – Run Collections Effectiveness Report
AR_BATCH_SOURCE AR: Receipt Batch Source
AR_CALCULATE_TAX_ON_CM Tax: Calculate tax on credit memos
AR_CHANGE_CUST_NAME HZ: Change Party Name
AR_CHANGE_CUST_ON_TRX AR: Change Customer on Transaction
AR_CMERGE_SET_SIZE AR: Customer Merge Commit Size
AR_CROSS_CURRENCY_RATE_TYPE AR: Cross Currency Rate Type
AR_CUSTOMER_TEXT_LAST_SUCCESSFUL_RUN AR:Customer Text Last Successful Run
AR_DEFAULT_AMOUNT_APPLIED AR: Cash – Default Amount Applied
AR_DEFAULT_EXCHANGE_RATE_TYPE AR: Default Exchange Rate Type
AR_DOC_SEQ_GEN_LEVEL AR: Document Number Generation Level
ARI_REG_HOLD_DURATION OIR: Registration Hold Duration
HZ_RM_MATCH_RULE_ID HZ: Match Rule for Relationship Manager Search
HZ_DSS_ENABLED HZ: Data Sharing and Security Enabled
HZ_UPDATE_LOCATION HZ: Location Updatable
HZ_SUGG_ADDR_MATCH_RULE HZ: Match Rule for Address Mapping Suggestions
HZ_SUGG_RELN_MATCH_RULE HZ: Match Rule for Relationship Mapping Suggestions
HZ_SHOW_SUGG_ADDR HZ: Show Address Mapping Suggestions
HZ_SHOW_SUGG_RELN HZ: Show Relationship Mapping Suggestions
AR_REQUIRE_ADJUSTMENT_REASON AR: Require Adjustment Reason
AR_USE_STATEMENTS_AND_DUNNING_SITE_PROFILE AR: Use Statement, Dunning, and Late Charges Site Profiles
AR_COMMITMENT_DEFAULT_ACCOUNTING AR: Deposit Offset Account Source
AR_EBS_AUTOINV_PREPROCESSOR AR: EBS Autoinvoice Preprocessor
AR_BANK_DIRECTORY_URL AR: Bank Directory URL
AR_BANK_DIRECTORY_SOURCE OIR: Bank Directory Source
HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE HZ: Banking Group Member Validation Procedure
HZ_BANKING_GROUP_VALIDATION_PROCEDURE HZ: Banking Group Validation Procedure
HZ_BANK_BRANCH_CONTACT_POINT_VALIDATION_PROCEDURE HZ: Bank Branch Contact Point Validation Procedure
HZ_BANK_BRANCH_CONTACT_VALIDATION_PROCEDURE HZ: Bank Branch Contact Validation Procedure
HZ_BANK_BRANCH_LOCATION_VALIDATION_PROCEDURE HZ: Bank Branch Location Validation Procedure
HZ_BANK_BRANCH_SITE_VALIDATION_PROCEDURE HZ: Bank Branch Site Validation Procedure
HZ_BANK_BRANCH_VALIDATION_PROCEDURE HZ: Bank Branch Validation Procedure
HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE HZ: Bank Contact Point Validation Procedure
HZ_BANK_CONTACT_VALIDATION_PROCEDURE HZ: Bank Contact Validation Procedure
HZ_BANK_LOCATION_VALIDATION_PROCEDURE HZ: Bank Location Validation Procedure
HZ_BANK_SITE_VALIDATION_PROCEDURE HZ: Bank Site Validation Procedure
HZ_BANK_VALIDATION_PROCEDURE HZ: Bank Validation Procedure
HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE HZ: Clearinghouse Assignment Validation Procedure
HZ_CP_DETAIL HZ: Detailed Concurrent Program Output
HZ_DEFAULT_ADDR_STYLE HZ: Default Address Style
HZ_DEFAULT_NAME_STYLE HZ: Default Name Style
HZ_FMT_BKWD_COMPATIBLE HZ: Name/Address Backwards Compatability
HZ_GEOCODE_WEBSITE HZ: Spatial Provider URL
HZ_LANG_FOR_COUNTRY_DISPLAY HZ: Language for Country Display
HZ_ORG_PROF_MIXNMATCH_ENABLED HZ: Third Party Data Integration Enabled for Organization Profile Entity
HZ_PER_PROF_MIXNMATCH_ENABLED HZ: Third Party Data Integration Enabled for Person Profile Entity
HZ_REF_LANG HZ: Reference Language
HZ_REF_TERRITORY HZ: Reference Territory
HZ_SHOW_ONLY_ACTIVE_ADDRESSES HZ: Show Only Active Addresses
HZ_UPDATE_THIRD_PARTY_DATA HZ: Allow User to Update Third Party Data
HZ_USER_DATA_CREATION_RULE HZ: User Create and Update Rule for Other Entities
HZ_USER_OVERWRITE_RULE HZ: User Overwrite Rule
HZ_ALL_ORG HZ: Display Accounts for All Operating Units
OIR_PMT_APPROVER_STATUS OIR: Payment Approver Status
HZ_CLEANSE_FUZZY_KEY HZ: Cleanse Fuzzy Key
HZ_WEBPROXY_NAME HZ: Web Server Proxy Host Name
HZ_WEBPROXY_PORT HZ: Web Server Proxy Port
HZ_WEBPROXY_PWD HZ: Web Server Proxy Password
HZ_WEBPROXY_UID HZ: Web Server Proxy User Name
HZ_BYPASS_FIND_ENTER HZ: Bypass Find/Enter Window
HZ_DNB_DISPLAY_BUTTON HZ: Display D&B Button in Customer Form
HZ_DNB_PWD HZ: D&B Password
HZ_DNB_UID HZ: D&B User Name
HZ_DNB_URL HZ: D&B URL
AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION AR:Disable Receivable Activity Balancing Segment Substitution
HZ_API_FILE_DEBUG_ON HZ: Turn On File Debug
AR_MAX_LINES_PER_AI_WORKER AR:Maximum lines per AutoInvoice worker
HZ_CINTERFACE_NUM_OF_WORKERS HZ: Number of Workers Used by Customer Interface
HZ_CREATED_BY_MODULE HZ: Created By Module
HZ_DNB_POLICY_EXIST HZ: D&B Policy Function Exists
HZ_DQM_INDEX_MEMORY HZ: DQM Index Creation Memory
HZ_DQM_INDEX_PARALLEL HZ: DQM Index Creation Workers
ORACLE_EXCHANGE_DATABASE_LINK AR: Oracle Exchange Database Link Name
HZ_DUPLICATE_IDENTIFICATION_RULE DQM Match Rule for Batch Duplicate Identification
HZ_DUPLICATE_PREVENTION_RULE DQM Match Rule for Online Duplicate Identification
HZ_IMP_G_MISS_CHAR HZ: Character Value to Indicate NULL During Import
HZ_IMP_G_MISS_DATE HZ: Date Value (DD-MM-YYYY) to Indicate NULL During Import
HZ_IMP_G_MISS_NUM HZ: Numeric Value to Indicate NULL During Import
HZ_IMP_HR_SECURITY HZ: Use HR Security During Import
HZ_IMP_NUM_OF_WORKERS HZ: Number of Workers for Import
HZ_IMP_PREVIEW_PROFILE HZ: Preview Import Process Results
HZ_IMP_REG_DEDUP_PROFILE HZ: Import Registry De-Duplication Match Rule
HZ_IMP_RUN_ADDRVALID_PROFILE HZ: Run Import Address Validation
HZ_IMP_RUN_BATCHDQM_PROFILE HZ: Run Import Batch De-Duplication
HZ_IMP_RUN_REGDQM_PROFILE HZ: Run Import Registry De-Duplication
HZ_IMP_WORK_UNIT_SIZE HZ: Work Unit Size for Import
HZ_MARK_DUPLICATES_ENABLED_FLAG HZ: Allow Access to Submit Merge Requests
HZ_ORG_DUP_PREV_MATCHRULE HZ: Match Rule for Organization Duplicate Prevention
HZ_PER_DUP_PREV_MATCHRULE HZ: Match Rule for Person Duplicate Prevention
HZ_HIER_COPY_ENABLED_FLAG HZ: Allow Hierarchy Copy
HZ_PROFILE_VERSION HZ: Profile Version Method for Updates
HZ_DQM_ENABLED_FLAG HZ: Enable DQM Party Search
HZ_SSM_VIEW_UPDATE_STATE HZ: Source System Mapping Access
HZ_DEFAULT_LOC_ADAPTER HZ: Default Location Service Adapter
HZ_UPDATE_STD_ADDRESS HZ: Allow Update to Standardized Address
HZ_DNB_ACCESS_ENABLED_FLAG HZ: Allow Access to D&B Online Purchase
HZ_MAINTAIN_LOC_HISTORY HZ: Maintain Location History
HZ_WRITE_ADAPTER_LOG HZ: Create Log for Adapters
HZ_AUTOMERGE_WINNER_SELECT_RULE HZ: Automerge Master Party Selection
HZ_DQM_OPT_MAXTIME HZ: DQM Maximum Index Optimization Time
HZ_DQM_ORG_ADV_MATCHRULE HZ: Match Rule for Organization Advanced Search
HZ_DQM_ORG_SIMPLE_MATCHRULE HZ: Match Rule for Organization Simple Search
HZ_DQM_CON_ADV_MATCHRULE HZ: Match Rule for Contact Advanced Search
HZ_DQM_CON_SIMPLE_MATCHRULE HZ: Match Rule for Contact Simple Search
HZ_CON_DUP_PREV_MATCHRULE HZ: Match Rule for Contact Duplicate Prevention
AR_BPA_DETAIL_ACCESS_ENABLED AR: BPA Detail Access Enabled
AR_APP_ALL_DFT_REM_AMT AR: Always Default Transaction Balance for Applications
HZ_DISPLAY_CERT_LEVEL HZ: Display Certification Level
AR_KEEP_REPLACE_PROF_AMT AR: Keep or Replace Existing Profile Amounts
HZ_DQM_PER_ADV_MATCHRULE HZ: Match Rule for Person Advanced Search
HZ_DQM_PER_SIMPLE_MATCHRULE HZ: Match Rule for Person Simple Search
HZ_DQM_SCORE_UNTIL_THRESH HZ: Stop Scoring After Reaching DQM Automerge Threshold
HZ_DUP_PREVENTION_STATE HZ: Enable Duplicate Prevention at Party Creation
HZ_IMP_ALLOW_ADDR_CORRECTION HZ: Allow Updates of Address Records During Import
HZ_IMP_ALLOW_DISABLED_LOOKUP HZ: Allow Import of Records with Disabled Lookups
HZ_IMP_BATCH_DEDUP_PROFILE HZ: Import Batch De-Duplication Match Rule
HZ_GNR_NUM_OF_WORKERS HZ: Number of workers for a given Geography Name Referencing request
HZ_GNR_COMMIT_SIZE HZ: Batch Size for committing records in Geography Name Referencing process
HZ_DQM_REL_PARTY_MATCH HZ: Do not use contact addresses and contact points for DQM Duplicate identification.
HZ_DQM_MAX_EVAL_THRESH HZ: Maximum Number of Match Results
OIR_AGING_BUCKETS OIR: Aging Buckets
OIR_INVOICE_BPA_ENABLED OIR: Bill Presentment Architecture Enabled
HZ_LOC_TIMEOUT HZ: Timeout Limit for Address Validation
HZ_DQM_PM_NUM_OF_WORKERS HZ: Number of Workers Used by Party Merge Program
HZ_QUALITY_WEIGHTING_USER_HOOK HZ: Enable Quality Weighting for DQM Match Scores
HZ_DQM_ENABLE_REALTIME_SYNC HZ: DQM Synchronization Method
HZ_SYS_DUP_NUM_OF_WORKERS HZ: Number of Workers for DQM Duplicate Identification Program
HZ_DL_ADDR_SRCH_MATCH_RULE_ID HZ: Match Rule for Address Search
HZ_DL_IDENTIFY_DUP_RULE HZ: Match Rule for Identifying Duplicates with Smart Search
HZ_DL_RELAT_SRCH_MATCH_RULE_ID HZ: Match Rule for Relationship Search
HZ_PROTECT_HR_PERSON_INFO HZ: Protect HR Person Information
HZ_AUDIT_ACCT_MERGE HZ: Audit Customer Account Merge
HZ_DEFAULT_DSS_GROUP HZ: Default Data Sharing Group
AR_GATHER_STATS AR: AutoInvoice Gather Statistics
AR_USE_OAM_IN_CMWF AR: Use Oracle Approvals Management in Credit Memo Workflow
AR_ALLOW_BATCHING AR: Allow Transaction Batching
AR_CMGT_HIERARCHY_TYPE AR: Credit Hierarchy Type
AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH AR: Allow summary table refresh
ARI_REG_HOLD_DOMAIN OIR: Registration Hold Domain
HZ_DL_DQM_MERGE_SUGG Enable DQM Merge Suggestion
AR_LB_QC_GATHER_STATS AR: Lockbox and Quickcash Gather Statistics
AR_USE_PARALLEL_HINT AR: Use Parallel Hints
AR_BPA_IGNORE_OPEN_REC_FLAG AR: BPA Ignore Open Receivables
HZ_VAL_FIRST_5_DIGIT_US_ZIP HZ: Validate first 5 Digits of US ZIP code
HZ_RETURN_USER_NAME HZ: Return User Name in GET APIs
HZ_BO_ENABLE_DQ HZ: Enable DQM for Integration Services
HZ_BO_ORG_MATCH_RULE HZ: Match Rule for Organization Services
AR_CMGT_WF_DEBUG AR: Workflow Debug Flag
AR_CMGT_WF_DEBUG_FILE AR: Workflow Debug File
AR_CMGT_WF_DEBUG_PATH AR: Workflow Debug File Path
OIR_BPA_TEMPLATE_SELECTION OIR: BPA Template Selection
HZ_BO_PERSON_MATCH_RULE HZ: Match Rule for Person Services
AR_RECALC_TAX_ON_UPDATE_OF_TAX_INFO AR: Recalculate tax on update of tax information
OIR_ACCOUNT_GROUPING OIR: Account Grouping
OIR_DEFAULT_CURRENCY_CODE OIR: Default currency code
OIR_BA_PMT_METHOD OIR: Bank Account Payment Method
OIR_CC_PMT_METHOD OIR: Credit Card Payment Method
AR_DEFAULT_OPEN_RECEIPTS AR: Default Open Receipts for Applications
AR_REQ_PAY_METHOD AR: Require Payment Method on Remittance Batch
AR_CMWF_TIME_OUT AR: Credit Memo Workflow timeout notification
AR_STATEMENT_GATHER_STATS AR: Statement Generation Gather Statistics
OIR_CROSS_CUSTOMER_PAYMENT OIR: Cross Customer Payments
OIR_APPLY_CREDITS OIR: Apply Credits
OIR_ENABLE_DISCOUNT_GRACE_DAYS OIR: Enable Discount Grace Days
OIR_ENABLE_SERVICE_CHARGE OIR: Enable Service Charge
OIR_MAX_FUTURE_PAYMENT_DAYS_ALLOWED OIR: Maximum Future Payment Days Allowed
OIR_BPA_MULTI_PRINT_LIMIT OIR: Multi Print Limit
OIR_SAVE_PAYMENT_INSTR_INFO OIR: Save Payment Instrument Information
OIR_SERVICE_CHARGE_ACTIVITY_ID OIR: Service Charge Activity Id
OIR_VERIFY_CREDIT_CARD_DETAILS OIR: Verify Credit Card Details
OIR_ACTIVE_CONTACTS_DISP_LIMIT OIR: Active Contacts Display Limit
AR_QRY_CRITERIA_CHK AR: Query Criteria check
AR_ENABLE_JOURNAL_BAL_CHECK AR:Enable Journal Balance Check
AR_MFAR_ACTIVATED AR: Activate Multi Fund Accounting Extract
HZ_DL_PROTECT_PARTY_MODELING HZ: Protect Party Modeling Before Merge
HZ_PROF_ATTR_DEFAULT_NEXT HZ: Default Secondary Profile Attributes for Merge Mapping
HZ_PARTY_MASTER_DEFAULT HZ: Merge Master Party Defaulting
HZ_DQM_INDEX_BUILD_TYPE HZ: DQM Text Index Build Type
HZ_GATHER_TABLE_STATS HZ:  Gather Table Stats
HZ_ACCOUNT_MERGE_LOGGING HZ: Log Customer Merge
HZ_DEFAULT_PARTY_TYPE HZ: Default Party Type
HZ_PUI_DEFAULT_PHONE_PURPOSE HZ: Default Phone Number Purpose
HZ_AM_SUGG_GROUPINGS HZ: Use DQM Suggested Groupings for Automerge
AR_REC_APP_CROSS_CUR_RATE_CHG AR: Receipt Application keep cross currency rate unchanged
AR_BPA_ATTACH_UPDATE_ENABLED AR: BPA Attachment Update Enabled
AR_BPA_PRINT_ATTACH_CATEGORY AR: BPA Print Attachment Document Category
AR_CMGT_DEFAULT_CURRENCY_CODE AR: Default Credit Management Currency
HZ_PARTY_USAGE_DEFAULT HZ: Party Usage Default
HZ_RELATED_SEARCH_PREFERENCE HZ: Related Party and Account Search Method
HZ_APP_ADDR_VAL HZ: Address Validation Level for Application
HZ_TAX_ADDRESS_VALIDATION HZ: Validate US Addresses
HZ_DL_CREATE_SUGG_MERGE_REQ HZ: Create Suggested Merges from Party Merge
HZ_DQM_PN_THRESH_RESOLUTION HZ: DQM Resolution for Party Name Searches that Exceed Maximum Number of Results
HZ_DQM_MAX_EVAL_THRESH_BATCH HZ: Maximum Number of Match Results for Batch
HZ_BO_EVENTS_FORMAT_BULK HZ: Format Business Object Business Events as Bulk
HZ_BO_EVENTS_PRESERVE_DAYS HZ: Number of Days to Preserve Business Object Business Event Information
HZ_PROF_ATTR_DEFAULT HZ: Default Profile Attributes for Merge Mapping
HZ_DQM_IGNORE_CONC_LIMITS HZ: Ignore Concurrent Request Limits for DQM Synchronization
HZ_FLEX_ADDRESS_FORMAT HZ: Default Flexible Address Format
HZ_DL_DISPLAY_LOCK HZ: Data Sharing and Security Rules for Data Librarians
HZ_IMP_DSS_SECURITY HZ: Use Data Sharing and Security During Import
HZ_IMP_ERROR_LIMIT HZ: Error Limit for Import
HZ_IMP_FLEX_VALIDATION HZ: Validate Flexfields During Import

Receivables Descriptive Flex Field

Oracle Accounts Receivables Module DFF list

DFF View DFF CODE NAME DFF name
AR_IREC_SELFREG_CUST_QS_DFV AR_IREC_SELFREG_CUST_QS iReceivables Customer Verification Question
AR_ADJUSTMENTS_ALL_DFV AR_ADJUSTMENTS Adjustment Information
AR_ADJUSTMENTS_ALL1_DFV AR_ADJUSTMENTS_GOV Government Adjustment Information
AR_AGING_BUCKETS_DFV AR_AGING_BUCKETS Aging Bucket Information
AR_AGING_BUCKET_LINES_B_DFV AR_AGING_BUCKET_LINES Aging Bucket Line Information
AR_APPROVAL_ACTION_HISTORY_DFV AR_APPROVAL_ACTION_HISTORY Approval Action History Information
AR_APPROVAL_USER_LIMITS_DFV AR_APPROVAL_USER_LIMITS User Approval Limit Information
AR_APP_RULES_DFV AR_APP_RULES Application Rules Information
AR_APP_RULE_DETAILS_DFV AR_APP_RULE_DETAILS Application Rule Details Information
AR_APP_RULE_SETS_DFV AR_APP_RULE_SETS Application Rule Sets Information
AR_AUTOCASH_HIERARCHIES_DFV AR_AUTOCASH_HIERARCHIES AutoCash Hierarchies Information
AR_AUTOCASH_RULES_DFV AR_AUTOCASH_RULES AutoCash Rules Information
AR_BATCHES_ALL_DFV AR_BATCHES Batch Information
AR_BATCH_SOURCES_ALL_DFV AR_BATCH_SOURCES Batch Source Information
AR_CASH_RECEIPTS_ALL_DFV AR_CASH_RECEIPTS Receipt Information
AR_CASH_RECEIPTS_ALL1_DFV AR_CASH_RECEIPTS_GOV Government Receipt Information
AR_COLLECTORS_DFV AR_COLLECTORS Collector Information
AR_CREDIT_HISTORIES_DFV AR_CREDIT_HISTORIES Credit History Information
AR_CUSTOMER_CALLS_ALL_DFV AR_CUSTOMER_CALLS Customer Call Information
AR_CUSTOMER_CALL_TOPICS_AL_DFV AR_CUSTOMER_CALL_TOPICS Call Topic Information
AR_CUSTOMER_PROFILES_DFV AR_CUSTOMER_PROFILES Customer Credit Profile Information OLD
AR_CUSTOMER_PROFILE_AMOUNT_DFV AR_CUSTOMER_PROFILE_AMOUNTS Customer Profile Amounts OLD
AR_CUSTOMER_PROFILE_CLASSE_DFV AR_CUSTOMER_PROFILE_CLASSES Credit Profile Class Information OLD
AR_CUST_PROF_CLASS_AMOUNTS_DFV AR_CUST_PROF_CLASS_AMOUNTS Customer Profile Class Amounts OLD
AR_DUNNING_LETTERS_B_DFV AR_DUNNING_LETTERS Dunning Letter Information
AR_DUNNING_LETTER_SETS_DFV AR_DUNNING_LETTER_SETS Dunning Letter Set Information
AR_DUNNING_LETTER_SET_LINE_DFV AR_DUNNING_LETTER_SET_LINES Dunning Letter Sequence Information
AR_INTERIM_CASH_RECEIPTS_1_DFV AR_INTERIM_CASH_RECEIPTS_GOV Government QuickCash Information
AR_INTERIM_CASH_RCPT_LINES_DFV AR_INTERIM_CASH_RECEIPT_LINES Quickcash Line Information
AR_INTERIM_CASH_RCPT_LINE1_DFV AR_INT_CASH_RECEIPT_LINES_GOV Government QuickCash Line Information
AR_LOCATION_COMBINATIONS_DFV AR_LOCATION_COMBINATIONS Location Combination Information
AR_LOCATION_RATES_DFV AR_LOCATION_RATES Sales Tax Rate Information
AR_LOCATION_RATES1_DFV AR_LOCATION_RATES_OVERRIDE Override Sales Tax Rates
AR_LOCATION_VALUES_DFV AR_LOCATION_VALUES Location Information
AR_LOCKBOXES_ALL_DFV AR_LOCKBOXES Lockbox Information
AR_MEMO_LINES_ALL_B_DFV AR_MEMO_LINES Memo Line Information
AR_MISC_CASH_DISTRIBUTIONS_DFV AR_MISC_CASH_DISTRIBUTIONS Accounting Distribution Information
AR_MISC_CASH_DISTRIBUTION1_DFV AR_MISC_CASH_DISTRIBUTIONS_GOV Government Distribution Information
AR_PAYMENTS_INTERFACE_ALL_DFV AR_PAYMENTS_INTERFACE Payment Interface Information
AR_PAYMENT_SCHEDULES_ALL_DFV AR_PAYMENT_SCHEDULES Payment Schedule Information
AR_RATE_ADJUSTMENTS_ALL_DFV AR_RATE_ADJUSTMENTS Rate Adjustment Information
AR_RECEIPT_CLASSES_DFV AR_RECEIPT_CLASSES Receipt Class Information
AR_RECEIPT_METHODS_DFV AR_RECEIPT_METHODS Payment Method Information
AR_RECEIPT_METHOD_ACCOUNTS_DFV AR_RECEIPT_METHOD_ACCOUNTS Remittance Bank Information
AR_RECEIVABLES_TRX_ALL_DFV AR_RECEIVABLES_TRX Receivables Activity Information
AR_RECEIVABLE_APPLICATIONS_DFV AR_RECEIVABLE_APPLICATIONS Receipt Application Information
AR_RECEIVABLE_APPLICATION1_DFV AR_RECEIVABLE_APPLICATIONS_GOV Government Application Information
AR_SALES_TAX_DFV AR_SALES_TAX Sales Tax Information
AR_SALES_TAX1_DFV AR_SALES_TAX_RATES Sales Tax Rate Assignment
AR_STANDARD_TEXT_B_DFV AR_STANDARD_TEXT Standard Text Information
AR_STATEMENT_CYCLES_DFV AR_STATEMENT_CYCLES Statement Cycle Information
AR_SYSTEM_PARAMETERS_ALL_DFV AR_SYSTEM_PARAMETERS System Parameter Information
AR_TAX_CONDITIONS_ALL_DFV AR_TAX_CONDITIONS Tax Condition Information
AR_TAX_CONDITION_ACTIONS_A_DFV AR_TAX_CONDITION_ACTIONS_ALL Tax Condition Action Information
AR_TAX_CONDITION_LINES_ALL_DFV AR_TAX_CONDITION_LINES Tax Condition Line Information
AR_TAX_GROUP_CODES_ALL_DFV AR_TAX_GROUP_CODES %Item Exception%
AR_TRANSMISSIONS_ALL_DFV AR_TRANSMISSIONS Transmission Information
AR_TRANSMISSION_FORMATS_DFV AR_TRANSMISSION_FORMATS Transmission Format Information
AR_TRANS_RECORD_FORMATS_DFV AR_TRANS_RECORD_FORMATS Transmission Records
AR_VAT_TAX_ALL_B_DFV AR_VAT_TAX VAT Rate Information
RA_TAX_EXEMPTIONS_ALL_DFV AR_VDR_EXEMPT_RATES Vendor Exempt Rates
RA_ACCOUNT_COMBINATIONS_DFV RA_ACCOUNT_COMBINATIONS Account Combination Information
RA_ACCOUNT_DEFAULTS_ALL_DFV RA_ACCOUNT_DEFAULTS Account Default Information
RA_ACCOUNT_DEFAULT_SEGMENT_DFV RA_ACCOUNT_DEFAULT_SEGMENTS Default Segment Information
RA_ADDRESSES_ALL_DFV RA_ADDRESSES Address Information OLD
RA_BATCHES_ALL_DFV RA_BATCHES Revenue Batch Information
RA_BATCH_SOURCES_ALL_DFV RA_BATCH_SOURCES Revenue Batch Source Information
RA_CONTACTS_DFV RA_CONTACTS Contact Information OLD
RA_CONTACT_ROLES_DFV RA_CONTACT_ROLES Contact Role Information OLD
RA_CUSTOMERS_DFV RA_CUSTOMERS Customer Information OLD
RA_CUSTOMER_MERGES_DFV RA_CUSTOMER_MERGES Customer Merge Information
RA_CUSTOMER_RELATIONSHIPS__DFV RA_CUSTOMER_RELATIONSHIPS Customer Relationship Information OLD
RA_CUSTOMER_TRX_ALL1_DFV RA_CUSTOMER_TRX_GOV Government Transaction Information
RA_CUSTOMER_TRX_LINES_ALL_DFV RA_CUSTOMER_TRX_LINES Invoice Line Information
RA_CUSTOMER_TRX_LINES_ALL1_DFV RA_CUSTOMER_TRX_LINES_GOV Government Transaction Line Information
RA_CUSTOMER_TRX_LINES_ALL2_DFV RA_CUSTOMER_TRX_LINES_ITEMS Items Information
RA_CUST_RECEIPT_METHODS_DFV RA_CUST_RECEIPT_METHODS Customer Payment Method Information
RA_CUST_TRX_LINE_GL_DIST_A_DFV RA_CUST_TRX_LINE_GL_DIST Line Distribution Information
RA_CUST_TRX_LINE_GL_DIST_1_DFV RA_CUST_TRX_LINE_GL_DIST_GOV Government Line Distribution Information
RA_CUST_TRX_LINE_SALESREPS_DFV RA_CUST_TRX_LINE_SALESREPS Sales Representative Line Information
RA_CUST_TRX_TYPES_ALL_DFV RA_CUST_TRX_TYPES Transaction Type Information
RA_GROUPING_RULES_DFV RA_GROUPING_RULES Grouping Rule Information
RA_GROUPING_TRX_TYPES_DFV RA_GROUPING_TRX_TYPES Grouping Transaction Type Information
RA_GROUP_BYS_DFV RA_GROUP_BYS Group By Information
RA_INTERFACE_DISTRIBUTIONS_DFV RA_INTERFACE_DISTRIBUTIONS Interface Distribution Information
RA_CUSTOMER_TRX_ALL2_DFV RA_INTERFACE_HEADER Invoice Transaction Flexfield
RA_INTERFACE_LINES_ALL_DFV RA_INTERFACE_LINES Line Transaction Flexfield
RA_INTERFACE_LINES_ALL1_DFV RA_INTERFACE_LINES_GOV Government Interface Line Information
RA_INTERFACE_LINES_ALL2_DFV RA_INTERFACE_LINK_TO Link-to Transaction Flexfield
RA_INTERFACE_LINES_ALL3_DFV RA_INTERFACE_REFERENCE Reference Transaction Flexfield
RA_INTERFACE_SALESCREDITS__DFV RA_INTERFACE_SALESCREDITS Interface Salescredits Information
RA_ITEM_EXCEPTION_RATES_DFV RA_ITEM_EXCEPTION_RATES Item Exception Rate Information
RA_ITEM_EXCEPTION_RATES1_DFV RA_ITEM_EXCEPTION_RATES_LOC Item Exception Rate Location
RA_ITEM_EXCEPTION_RATES2_DFV RA_ITEM_EXCEPTION_RATES_RATES Item Exception Rate Assignment
RA_LINE_ORDERING_RULES_DFV RA_LINE_ORDERING_RULES Line Ordering Rule Information
RA_LINE_ORDER_BYS_DFV RA_LINE_ORDER_BYS Line Order By Information
RA_PHONES_DFV RA_PHONES Telephone Number Information OLD
RA_REMIT_TOS_ALL_DFV RA_REMIT_TOS Remit Address Information
RA_RULES_DFV RA_RULES Invoice and Accounting Rule Information
RA_RULE_SCHEDULES_DFV RA_RULE_SCHEDULES Rule Schedule Information
RA_SALESREPS_ALL_DFV RA_SALESREPS Sales Representative Information
RA_SALESREP_TERRITORIES_DFV RA_SALESREP_TERRITORIES Salesrep/Agent Territory Information
RA_SITE_USES_ALL_DFV RA_SITE_USES Site Use Information OLD
RA_TAX_EXEMPTIONS_ALL1_DFV RA_TAX_EXEMPTIONS Tax Exemption Information
RA_TAX_EXEMPTIONS_ALL2_DFV RA_TAX_EXEMPTION_REGIONS Exempt Regions
RA_TERMS_B_DFV RA_TERMS Payment Term Information
RA_TERMS_LINES_DFV RA_TERMS_LINES Payment Term Line Information
RA_TERMS_LINES_DISCOUNTS_DFV RA_TERMS_LINES_DISCOUNTS Payment Term Line Discount Information
RA_TERRITORIES_DFV RA_TERRITORIES Territory Information
RA_ADDRESSES_ALL1_DFV Remit Address Address OLD
RA_CUSTOMER_MERGE_HEADERS_DFV RA_CUSTOMER_MERGE_HEADERS Customer Merge Header Information
RA_CUSTOMER_TRX_ALL_DFV RA_CUSTOMER_TRX Transaction Information
HZ_PARTY_SITES_DFV HZ_PARTY_SITES Party Site Information
HZ_ORG_CONTACTS_DFV HZ_ORG_CONTACTS Organization Contact Information
HZ_PARTY_USG_ASSIGNMENTS_DFV HZ_PARTY_USG_ASSIGNMENTS Party Usage Assignments Information
HZ_PARTIES_DFV HZ_PARTIES Party Information
AR_REVENUE_ADJUSTMENTS_ALL_DFV AR_REVENUE_ADJUSTMENTS Revenue Adjustment Information
HZ_CUSTOMER_PROFILES_DFV AR_CUSTOMER_PROFILES_HZ Customer Credit Profile Information
HZ_CUST_PROFILE_AMTS_DFV AR_CUSTOMER_PROFILE_AMOUNTS_HZ Customer Profile Amounts
HZ_CUST_PROFILE_CLASSES_DFV AR_CUSTOMER_PROFILE_CLASSES_HZ Credit Profile Class Information
HZ_CUST_PROF_CLASS_AMTS_DFV AR_CUST_PROF_CLASS_AMOUNTS_HZ Customer Profile Class Amounts
HZ_LOCATIONS1_DFV Remit Address HZ Address
HZ_CUST_ACCT_SITES_ALL_DFV RA_ADDRESSES_HZ Address Information
HZ_CUST_ACCOUNT_ROLES_DFV RA_CONTACTS_HZ Contact Information
HZ_ROLE_RESPONSIBILITY_DFV RA_CONTACT_ROLES_HZ Contact Role Information
HZ_CUST_ACCOUNTS_DFV RA_CUSTOMERS_HZ Customer Information
HZ_CUST_ACCT_RELATE_ALL_DFV RA_CUSTOMER_RELATIONSHIPS_HZ Customer Relationship Information
HZ_CONTACT_POINTS_DFV RA_PHONES_HZ Telephone Number Information
HZ_CUST_SITE_USES_ALL_DFV RA_SITE_USES_HZ Site Use Information
AR_BR_STAMP_VALUES_ALL_DFV AR_BR_STAMP_VALUES Bills Receivable Stamp Values
AR_TRANSACTION_HISTORY_ALL_DFV AR_TRANSACTION_HISTORY Transaction history
AR_INTERIM_CASH_RECEIPTS_A_DFV AR_INTERIM_CASH_RECEIPTS QuickCash Receipt
HZ_RELATIONSHIPS_DFV HZ_RELATIONSHIPS Relationship Information
HZ_PERSON_PROFILES_DFV HZ_PERSON_PROFILES Person Information
HZ_LOCATIONS_DFV HZ_LOCATIONS TCA Location Information
HZ_ORGANIZATION_PROFILES_DFV HZ_ORGANIZATION_PROFILES Organization Information
HZ_CREDIT_USAGE_RULES_DFV HZ_CREDIT_USAGE_RULES Credit Usage Rules
HZ_CREDIT_USAGES_DFV HZ_CREDIT_USAGES Credit Usages
HZ_CREDIT_PROFILE_AMTS_DFV HZ_CREDIT_PROFILE_AMTS Credit Profile Amounts
HZ_ORIG_SYS_MAPPING_DFV HZ_ORIG_SYS_MAPPING Source System Entity Mapping
HZ_ORIG_SYS_REFERENCES_DFV HZ_ORIG_SYS_REFERENCES Source System References
AR_GTA_TRX_LINES_ALL_DFV AR_GTA_TRX_LINES_ALL GTA Workbench: Line
AR_ACTIVITY_DETAILS_DFV AR_ACTIVITY_DETAILS Line Level Receipt Application Information
HZ_CREDIT_RATINGS_EXT_B_DFV HZ_CREDIT_RATINGS_GROUP Credit Ratings Extension
HZ_FIN_NUMBERS_EXT_B_DFV HZ_FIN_NUMBERS_GROUP Financial Numbers Extension
HZ_FIN_REPORTS_EXT_B_DFV HZ_FIN_REPORTS_GROUP Financial Reports Extension
HZ_LOCATIONS_EXT_B_DFV HZ_LOCATIONS_GROUP Locations Extension
HZ_ORG_PROFILES_EXT_B_DFV HZ_ORG_PROFILES_GROUP Organization Profiles Extension
HZ_PARTY_SITES_EXT_B_DFV HZ_PARTY_SITES_GROUP Party Sites Extension
HZ_PER_PROFILES_EXT_B_DFV HZ_PERSON_PROFILES_GROUP Person Profiles Extension
RA_CUSTOMER_TRX_LINES_ALL3_DFV RA_CUST_TRX_TAX_EXEMPT_DDF Tax Exemption