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/
Keywords
customer profile classes customer credit check rules setting up customers oracle order management OM ONT AR accounts receivables

 

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 CODEPROFILE OPTION NAME
AR_ENABLE_CREDIT_CARD_PREPROCAR: Enable Credit Card Preprocessor
AR_ENABLE_CROSS_CURRENCYAR: Enable Cross Currency
AR_ENABLE_DEBUG_OUTPUTAR: Enable Debug Message Output
AR_ENABLE_SQL_TRACEAR: Enable SQL trace
AR_GLPOST_BALANCE_CHECK_FLAGAR: GL Transfer Balance Test
AR_INCL_RECEIPTS_AT_RISKAR: Include Receipts At Risk In Customer Balance
AR_ITEM_FLEXFIELD_MODEAR: Item Flexfield Mode
AR_JG_CREATE_BANK_CHARGESAR: Create Bank Charges
AR_MASK_BANK_ACCOUNT_NUMBERSAR: Mask Bank Account Numbers
AR_OVERRIDE_ADJUSTMENT_ACTIVITY_ACCOUNTAR: Override Adjustment Activity Account Option
AR_PA_CODEAR: Transaction Flexfield QuickPick Attribute
AR_POWERCASH_ALLOW_ACTIONSAR: Cash – Allow Actions
AR_RA_BATCH_SOURCEAR: Transaction Batch Source
AR_SHOW_BILLING_NUMBERAR: Show Billing Number
AR_TAX_USE_PLSQL_VENDORTax: Use Tax PL/SQL Vendor
AR_TAX_USE_VENDORTax: Use Tax Vendor
AR_UPDATE_DUE_DATEAR: Update Due Date
AR_USE_INV_ACCT_FOR_CM_FLAGAR: Use Invoice Accounting For Credit Memos
AR_ZENGIN_CHAR_SETAR: Zengin Character Set
HZ_SEARCH_RULEDQM Match Rule for Search
HZ_SPECIAL_CHARACTERS_ENABLEDHZ: Special Characters Enabled
HZ_API_DBMS_DEBUG_ONHZ: Turn On Development Debug
HZ_API_DEBUG_FILE_NAMEHZ: API Debug File Name
HZ_API_DEBUG_FILE_PATHHZ: API Debug File Directory
HZ_API_ERR_ON_OBSOLETE_COLUMNHZ: Report Error on Obsolete Columns
HZ_ADDRESS_KEY_INDEXHZ: Address Key Index
HZ_ADDRESS_KEY_LENGTHHZ: Address Key Length
HZ_DUPLICATE_ALLOWEDHZ: Duplicate Allowed
HZ_KEY_WORD_COUNTHZ: Key Word Count
HZ_POSTAL_CODE_KEY_LENGTHHZ: Postal Code Key Length
AR_BR_BATCH_SOURCEAR: Bills Receivable Batch Source
AR_BR_WO_RECOURSEAR: Factor / Endorse Bills Receivables without Recourse
HZ_INTERNAL_PARTYHZ: Internal Party
ARTACCSY_CRSUMM_RATIOARTA: Use deposit or apply date in customer credit summary ratios
AR_TA_CASHENG_LOGFILE_DIRARTA: Directory path for TA log files
AR_TA_INC_DED_IN_TOTEXPARTA:Include deductions in total exposure
AR_TA_MSG_LEVEL_THRESHOLDARTA: Message level threshold
AR_TA_SYS_ESS_INSTARTA: System ESS Installed
HZ_EXECUTE_API_CALLOUTSHZ: Raise API Events
HZ_GENERATE_CONTACT_NUMBERHZ: Generate Contact Number
AR_IREC_ADMIN_EMAILAR: iReceivables System Administrator Email
AR_CREDIT_LIMIT_SELECTIONAR: Credit Limit Selection
RA_CUSTOMERS_ENTER_PHONETICSAR: Customers – Enter Alternate Fields
RA_CUSTOMERS_SORT_BY_PHONETICSAR: Sort Customer Reports by Alternate Fields
SERVER_TIMEZONE_IDServer Timezone
TAXVDR_CASESENSITIVETax Vertex: Case Sensitive
TAXVDR_SECTAXSTax Vertex: Secondary Taxes
TAXVDR_SERVICEINDTax Taxware: Service Indicator
TAXVDR_TAXSELPARAMTax Taxware: Tax Selection
TAXVDR_TAXTYPETax Taxware: Tax Type
TAXVDR_USENEXPROTax Taxware: Use Nexpro
TAX_DEBUG_FILE_LOCATIONTax: Debug File Directory
TAX_DEBUG_FLAGTax: Debug Flag
AR_TA_EXCHANGE_RATE_FOR_DEDUCTIONAR: Exchange rate details for deductions
CLIENT_TIMEZONE_IDClient Timezone
HZ_GENERATE_PARTY_NUMBERHZ: Generate Party Number
HZ_GENERATE_PARTY_SITE_NUMBERHZ: Generate Party Site Number
AR_ADJUST_CREDIT_UNCONFIRMED_INVOICEAR: Invoices with Unconfirmed Receipts
AR_ALLOW_MANUAL_TAX_LINESTax: Allow Manual Tax Lines
AR_ALLOW_OVERAPPLICATION_IN_LOCKBOXAR: Allow Overapplication In Lockbox
AR_ALLOW_SALESCREDIT_UPDATEAR: Allow Update Of Existing Sales Credits
AR_ALLOW_TAX_CODE_OVERRIDETax: Allow Override of Tax Code
AR_ALLOW_TAX_UPDATETax: Allow Ad Hoc Tax Changes
AR_ALLOW_TRX_LINE_EXEMPTIONSTax: Allow Override of Customer Exemptions
AR_ALT_NAME_SEARCHAR: Alternate Name Search
AR_APPLICATION_GL_DATE_DEFAULTAR: Application GL Date Default
AR_ARCABP_DEBUG_LEVELAR: Debug Level for Lockbox and PostBatch
AR_ARDLP_REMIT_SIZEAR: Dunning Letter Remit-To Address Label Size
AR_ARLPLB_COMMIT_OPTIONAR: Commit between validations in Lockbox
AR_AUTOMATIC_CONTACT_NUMBERINGAR: Automatic Contact Numbering
AR_AUTOMATIC_RECEIPT_CREATION_ACTIONAR: Automatic Receipt Creation Authority
AR_AUTOMATIC_REMITTANCE_CREATION_ACTIONAR: Automatic Remittance Creation Authority
AR_AUTO_ARXCER_FLAGAR: Close Periods – Run Collections Effectiveness Report
AR_BATCH_SOURCEAR: Receipt Batch Source
AR_CALCULATE_TAX_ON_CMTax: Calculate tax on credit memos
AR_CHANGE_CUST_NAMEHZ: Change Party Name
AR_CHANGE_CUST_ON_TRXAR: Change Customer on Transaction
AR_CMERGE_SET_SIZEAR: Customer Merge Commit Size
AR_CROSS_CURRENCY_RATE_TYPEAR: Cross Currency Rate Type
AR_CUSTOMER_TEXT_LAST_SUCCESSFUL_RUNAR:Customer Text Last Successful Run
AR_DEFAULT_AMOUNT_APPLIEDAR: Cash – Default Amount Applied
AR_DEFAULT_EXCHANGE_RATE_TYPEAR: Default Exchange Rate Type
AR_DOC_SEQ_GEN_LEVELAR: Document Number Generation Level
ARI_REG_HOLD_DURATIONOIR: Registration Hold Duration
HZ_RM_MATCH_RULE_IDHZ: Match Rule for Relationship Manager Search
HZ_DSS_ENABLEDHZ: Data Sharing and Security Enabled
HZ_UPDATE_LOCATIONHZ: Location Updatable
HZ_SUGG_ADDR_MATCH_RULEHZ: Match Rule for Address Mapping Suggestions
HZ_SUGG_RELN_MATCH_RULEHZ: Match Rule for Relationship Mapping Suggestions
HZ_SHOW_SUGG_ADDRHZ: Show Address Mapping Suggestions
HZ_SHOW_SUGG_RELNHZ: Show Relationship Mapping Suggestions
AR_REQUIRE_ADJUSTMENT_REASONAR: Require Adjustment Reason
AR_USE_STATEMENTS_AND_DUNNING_SITE_PROFILEAR: Use Statement, Dunning, and Late Charges Site Profiles
AR_COMMITMENT_DEFAULT_ACCOUNTINGAR: Deposit Offset Account Source
AR_EBS_AUTOINV_PREPROCESSORAR: EBS Autoinvoice Preprocessor
AR_BANK_DIRECTORY_URLAR: Bank Directory URL
AR_BANK_DIRECTORY_SOURCEOIR: Bank Directory Source
HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDUREHZ: Banking Group Member Validation Procedure
HZ_BANKING_GROUP_VALIDATION_PROCEDUREHZ: Banking Group Validation Procedure
HZ_BANK_BRANCH_CONTACT_POINT_VALIDATION_PROCEDUREHZ: Bank Branch Contact Point Validation Procedure
HZ_BANK_BRANCH_CONTACT_VALIDATION_PROCEDUREHZ: Bank Branch Contact Validation Procedure
HZ_BANK_BRANCH_LOCATION_VALIDATION_PROCEDUREHZ: Bank Branch Location Validation Procedure
HZ_BANK_BRANCH_SITE_VALIDATION_PROCEDUREHZ: Bank Branch Site Validation Procedure
HZ_BANK_BRANCH_VALIDATION_PROCEDUREHZ: Bank Branch Validation Procedure
HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDUREHZ: Bank Contact Point Validation Procedure
HZ_BANK_CONTACT_VALIDATION_PROCEDUREHZ: Bank Contact Validation Procedure
HZ_BANK_LOCATION_VALIDATION_PROCEDUREHZ: Bank Location Validation Procedure
HZ_BANK_SITE_VALIDATION_PROCEDUREHZ: Bank Site Validation Procedure
HZ_BANK_VALIDATION_PROCEDUREHZ: Bank Validation Procedure
HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDUREHZ: Clearinghouse Assignment Validation Procedure
HZ_CP_DETAILHZ: Detailed Concurrent Program Output
HZ_DEFAULT_ADDR_STYLEHZ: Default Address Style
HZ_DEFAULT_NAME_STYLEHZ: Default Name Style
HZ_FMT_BKWD_COMPATIBLEHZ: Name/Address Backwards Compatability
HZ_GEOCODE_WEBSITEHZ: Spatial Provider URL
HZ_LANG_FOR_COUNTRY_DISPLAYHZ: Language for Country Display
HZ_ORG_PROF_MIXNMATCH_ENABLEDHZ: Third Party Data Integration Enabled for Organization Profile Entity
HZ_PER_PROF_MIXNMATCH_ENABLEDHZ: Third Party Data Integration Enabled for Person Profile Entity
HZ_REF_LANGHZ: Reference Language
HZ_REF_TERRITORYHZ: Reference Territory
HZ_SHOW_ONLY_ACTIVE_ADDRESSESHZ: Show Only Active Addresses
HZ_UPDATE_THIRD_PARTY_DATAHZ: Allow User to Update Third Party Data
HZ_USER_DATA_CREATION_RULEHZ: User Create and Update Rule for Other Entities
HZ_USER_OVERWRITE_RULEHZ: User Overwrite Rule
HZ_ALL_ORGHZ: Display Accounts for All Operating Units
OIR_PMT_APPROVER_STATUSOIR: Payment Approver Status
HZ_CLEANSE_FUZZY_KEYHZ: Cleanse Fuzzy Key
HZ_WEBPROXY_NAMEHZ: Web Server Proxy Host Name
HZ_WEBPROXY_PORTHZ: Web Server Proxy Port
HZ_WEBPROXY_PWDHZ: Web Server Proxy Password
HZ_WEBPROXY_UIDHZ: Web Server Proxy User Name
HZ_BYPASS_FIND_ENTERHZ: Bypass Find/Enter Window
HZ_DNB_DISPLAY_BUTTONHZ: Display D&B Button in Customer Form
HZ_DNB_PWDHZ: D&B Password
HZ_DNB_UIDHZ: D&B User Name
HZ_DNB_URLHZ: D&B URL
AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTIONAR:Disable Receivable Activity Balancing Segment Substitution
HZ_API_FILE_DEBUG_ONHZ: Turn On File Debug
AR_MAX_LINES_PER_AI_WORKERAR:Maximum lines per AutoInvoice worker
HZ_CINTERFACE_NUM_OF_WORKERSHZ: Number of Workers Used by Customer Interface
HZ_CREATED_BY_MODULEHZ: Created By Module
HZ_DNB_POLICY_EXISTHZ: D&B Policy Function Exists
HZ_DQM_INDEX_MEMORYHZ: DQM Index Creation Memory
HZ_DQM_INDEX_PARALLELHZ: DQM Index Creation Workers
ORACLE_EXCHANGE_DATABASE_LINKAR: Oracle Exchange Database Link Name
HZ_DUPLICATE_IDENTIFICATION_RULEDQM Match Rule for Batch Duplicate Identification
HZ_DUPLICATE_PREVENTION_RULEDQM Match Rule for Online Duplicate Identification
HZ_IMP_G_MISS_CHARHZ: Character Value to Indicate NULL During Import
HZ_IMP_G_MISS_DATEHZ: Date Value (DD-MM-YYYY) to Indicate NULL During Import
HZ_IMP_G_MISS_NUMHZ: Numeric Value to Indicate NULL During Import
HZ_IMP_HR_SECURITYHZ: Use HR Security During Import
HZ_IMP_NUM_OF_WORKERSHZ: Number of Workers for Import
HZ_IMP_PREVIEW_PROFILEHZ: Preview Import Process Results
HZ_IMP_REG_DEDUP_PROFILEHZ: Import Registry De-Duplication Match Rule
HZ_IMP_RUN_ADDRVALID_PROFILEHZ: Run Import Address Validation
HZ_IMP_RUN_BATCHDQM_PROFILEHZ: Run Import Batch De-Duplication
HZ_IMP_RUN_REGDQM_PROFILEHZ: Run Import Registry De-Duplication
HZ_IMP_WORK_UNIT_SIZEHZ: Work Unit Size for Import
HZ_MARK_DUPLICATES_ENABLED_FLAGHZ: Allow Access to Submit Merge Requests
HZ_ORG_DUP_PREV_MATCHRULEHZ: Match Rule for Organization Duplicate Prevention
HZ_PER_DUP_PREV_MATCHRULEHZ: Match Rule for Person Duplicate Prevention
HZ_HIER_COPY_ENABLED_FLAGHZ: Allow Hierarchy Copy
HZ_PROFILE_VERSIONHZ: Profile Version Method for Updates
HZ_DQM_ENABLED_FLAGHZ: Enable DQM Party Search
HZ_SSM_VIEW_UPDATE_STATEHZ: Source System Mapping Access
HZ_DEFAULT_LOC_ADAPTERHZ: Default Location Service Adapter
HZ_UPDATE_STD_ADDRESSHZ: Allow Update to Standardized Address
HZ_DNB_ACCESS_ENABLED_FLAGHZ: Allow Access to D&B Online Purchase
HZ_MAINTAIN_LOC_HISTORYHZ: Maintain Location History
HZ_WRITE_ADAPTER_LOGHZ: Create Log for Adapters
HZ_AUTOMERGE_WINNER_SELECT_RULEHZ: Automerge Master Party Selection
HZ_DQM_OPT_MAXTIMEHZ: DQM Maximum Index Optimization Time
HZ_DQM_ORG_ADV_MATCHRULEHZ: Match Rule for Organization Advanced Search
HZ_DQM_ORG_SIMPLE_MATCHRULEHZ: Match Rule for Organization Simple Search
HZ_DQM_CON_ADV_MATCHRULEHZ: Match Rule for Contact Advanced Search
HZ_DQM_CON_SIMPLE_MATCHRULEHZ: Match Rule for Contact Simple Search
HZ_CON_DUP_PREV_MATCHRULEHZ: Match Rule for Contact Duplicate Prevention
AR_BPA_DETAIL_ACCESS_ENABLEDAR: BPA Detail Access Enabled
AR_APP_ALL_DFT_REM_AMTAR: Always Default Transaction Balance for Applications
HZ_DISPLAY_CERT_LEVELHZ: Display Certification Level
AR_KEEP_REPLACE_PROF_AMTAR: Keep or Replace Existing Profile Amounts
HZ_DQM_PER_ADV_MATCHRULEHZ: Match Rule for Person Advanced Search
HZ_DQM_PER_SIMPLE_MATCHRULEHZ: Match Rule for Person Simple Search
HZ_DQM_SCORE_UNTIL_THRESHHZ: Stop Scoring After Reaching DQM Automerge Threshold
HZ_DUP_PREVENTION_STATEHZ: Enable Duplicate Prevention at Party Creation
HZ_IMP_ALLOW_ADDR_CORRECTIONHZ: Allow Updates of Address Records During Import
HZ_IMP_ALLOW_DISABLED_LOOKUPHZ: Allow Import of Records with Disabled Lookups
HZ_IMP_BATCH_DEDUP_PROFILEHZ: Import Batch De-Duplication Match Rule
HZ_GNR_NUM_OF_WORKERSHZ: Number of workers for a given Geography Name Referencing request
HZ_GNR_COMMIT_SIZEHZ: Batch Size for committing records in Geography Name Referencing process
HZ_DQM_REL_PARTY_MATCHHZ: Do not use contact addresses and contact points for DQM Duplicate identification.
HZ_DQM_MAX_EVAL_THRESHHZ: Maximum Number of Match Results
OIR_AGING_BUCKETSOIR: Aging Buckets
OIR_INVOICE_BPA_ENABLEDOIR: Bill Presentment Architecture Enabled
HZ_LOC_TIMEOUTHZ: Timeout Limit for Address Validation
HZ_DQM_PM_NUM_OF_WORKERSHZ: Number of Workers Used by Party Merge Program
HZ_QUALITY_WEIGHTING_USER_HOOKHZ: Enable Quality Weighting for DQM Match Scores
HZ_DQM_ENABLE_REALTIME_SYNCHZ: DQM Synchronization Method
HZ_SYS_DUP_NUM_OF_WORKERSHZ: Number of Workers for DQM Duplicate Identification Program
HZ_DL_ADDR_SRCH_MATCH_RULE_IDHZ: Match Rule for Address Search
HZ_DL_IDENTIFY_DUP_RULEHZ: Match Rule for Identifying Duplicates with Smart Search
HZ_DL_RELAT_SRCH_MATCH_RULE_IDHZ: Match Rule for Relationship Search
HZ_PROTECT_HR_PERSON_INFOHZ: Protect HR Person Information
HZ_AUDIT_ACCT_MERGEHZ: Audit Customer Account Merge
HZ_DEFAULT_DSS_GROUPHZ: Default Data Sharing Group
AR_GATHER_STATSAR: AutoInvoice Gather Statistics
AR_USE_OAM_IN_CMWFAR: Use Oracle Approvals Management in Credit Memo Workflow
AR_ALLOW_BATCHINGAR: Allow Transaction Batching
AR_CMGT_HIERARCHY_TYPEAR: Credit Hierarchy Type
AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESHAR: Allow summary table refresh
ARI_REG_HOLD_DOMAINOIR: Registration Hold Domain
HZ_DL_DQM_MERGE_SUGGEnable DQM Merge Suggestion
AR_LB_QC_GATHER_STATSAR: Lockbox and Quickcash Gather Statistics
AR_USE_PARALLEL_HINTAR: Use Parallel Hints
AR_BPA_IGNORE_OPEN_REC_FLAGAR: BPA Ignore Open Receivables
HZ_VAL_FIRST_5_DIGIT_US_ZIPHZ: Validate first 5 Digits of US ZIP code
HZ_RETURN_USER_NAMEHZ: Return User Name in GET APIs
HZ_BO_ENABLE_DQHZ: Enable DQM for Integration Services
HZ_BO_ORG_MATCH_RULEHZ: Match Rule for Organization Services
AR_CMGT_WF_DEBUGAR: Workflow Debug Flag
AR_CMGT_WF_DEBUG_FILEAR: Workflow Debug File
AR_CMGT_WF_DEBUG_PATHAR: Workflow Debug File Path
OIR_BPA_TEMPLATE_SELECTIONOIR: BPA Template Selection
HZ_BO_PERSON_MATCH_RULEHZ: Match Rule for Person Services
AR_RECALC_TAX_ON_UPDATE_OF_TAX_INFOAR: Recalculate tax on update of tax information
OIR_ACCOUNT_GROUPINGOIR: Account Grouping
OIR_DEFAULT_CURRENCY_CODEOIR: Default currency code
OIR_BA_PMT_METHODOIR: Bank Account Payment Method
OIR_CC_PMT_METHODOIR: Credit Card Payment Method
AR_DEFAULT_OPEN_RECEIPTSAR: Default Open Receipts for Applications
AR_REQ_PAY_METHODAR: Require Payment Method on Remittance Batch
AR_CMWF_TIME_OUTAR: Credit Memo Workflow timeout notification
AR_STATEMENT_GATHER_STATSAR: Statement Generation Gather Statistics
OIR_CROSS_CUSTOMER_PAYMENTOIR: Cross Customer Payments
OIR_APPLY_CREDITSOIR: Apply Credits
OIR_ENABLE_DISCOUNT_GRACE_DAYSOIR: Enable Discount Grace Days
OIR_ENABLE_SERVICE_CHARGEOIR: Enable Service Charge
OIR_MAX_FUTURE_PAYMENT_DAYS_ALLOWEDOIR: Maximum Future Payment Days Allowed
OIR_BPA_MULTI_PRINT_LIMITOIR: Multi Print Limit
OIR_SAVE_PAYMENT_INSTR_INFOOIR: Save Payment Instrument Information
OIR_SERVICE_CHARGE_ACTIVITY_IDOIR: Service Charge Activity Id
OIR_VERIFY_CREDIT_CARD_DETAILSOIR: Verify Credit Card Details
OIR_ACTIVE_CONTACTS_DISP_LIMITOIR: Active Contacts Display Limit
AR_QRY_CRITERIA_CHKAR: Query Criteria check
AR_ENABLE_JOURNAL_BAL_CHECKAR:Enable Journal Balance Check
AR_MFAR_ACTIVATEDAR: Activate Multi Fund Accounting Extract
HZ_DL_PROTECT_PARTY_MODELINGHZ: Protect Party Modeling Before Merge
HZ_PROF_ATTR_DEFAULT_NEXTHZ: Default Secondary Profile Attributes for Merge Mapping
HZ_PARTY_MASTER_DEFAULTHZ: Merge Master Party Defaulting
HZ_DQM_INDEX_BUILD_TYPEHZ: DQM Text Index Build Type
HZ_GATHER_TABLE_STATSHZ:  Gather Table Stats
HZ_ACCOUNT_MERGE_LOGGINGHZ: Log Customer Merge
HZ_DEFAULT_PARTY_TYPEHZ: Default Party Type
HZ_PUI_DEFAULT_PHONE_PURPOSEHZ: Default Phone Number Purpose
HZ_AM_SUGG_GROUPINGSHZ: Use DQM Suggested Groupings for Automerge
AR_REC_APP_CROSS_CUR_RATE_CHGAR: Receipt Application keep cross currency rate unchanged
AR_BPA_ATTACH_UPDATE_ENABLEDAR: BPA Attachment Update Enabled
AR_BPA_PRINT_ATTACH_CATEGORYAR: BPA Print Attachment Document Category
AR_CMGT_DEFAULT_CURRENCY_CODEAR: Default Credit Management Currency
HZ_PARTY_USAGE_DEFAULTHZ: Party Usage Default
HZ_RELATED_SEARCH_PREFERENCEHZ: Related Party and Account Search Method
HZ_APP_ADDR_VALHZ: Address Validation Level for Application
HZ_TAX_ADDRESS_VALIDATIONHZ: Validate US Addresses
HZ_DL_CREATE_SUGG_MERGE_REQHZ: Create Suggested Merges from Party Merge
HZ_DQM_PN_THRESH_RESOLUTIONHZ: DQM Resolution for Party Name Searches that Exceed Maximum Number of Results
HZ_DQM_MAX_EVAL_THRESH_BATCHHZ: Maximum Number of Match Results for Batch
HZ_BO_EVENTS_FORMAT_BULKHZ: Format Business Object Business Events as Bulk
HZ_BO_EVENTS_PRESERVE_DAYSHZ: Number of Days to Preserve Business Object Business Event Information
HZ_PROF_ATTR_DEFAULTHZ: Default Profile Attributes for Merge Mapping
HZ_DQM_IGNORE_CONC_LIMITSHZ: Ignore Concurrent Request Limits for DQM Synchronization
HZ_FLEX_ADDRESS_FORMATHZ: Default Flexible Address Format
HZ_DL_DISPLAY_LOCKHZ: Data Sharing and Security Rules for Data Librarians
HZ_IMP_DSS_SECURITYHZ: Use Data Sharing and Security During Import
HZ_IMP_ERROR_LIMITHZ: Error Limit for Import
HZ_IMP_FLEX_VALIDATIONHZ: Validate Flexfields During Import

Receivables Descriptive Flex Field

Oracle Accounts Receivables Module DFF list

DFF ViewDFF CODE NAMEDFF name
AR_IREC_SELFREG_CUST_QS_DFVAR_IREC_SELFREG_CUST_QSiReceivables Customer Verification Question
AR_ADJUSTMENTS_ALL_DFVAR_ADJUSTMENTSAdjustment Information
AR_ADJUSTMENTS_ALL1_DFVAR_ADJUSTMENTS_GOVGovernment Adjustment Information
AR_AGING_BUCKETS_DFVAR_AGING_BUCKETSAging Bucket Information
AR_AGING_BUCKET_LINES_B_DFVAR_AGING_BUCKET_LINESAging Bucket Line Information
AR_APPROVAL_ACTION_HISTORY_DFVAR_APPROVAL_ACTION_HISTORYApproval Action History Information
AR_APPROVAL_USER_LIMITS_DFVAR_APPROVAL_USER_LIMITSUser Approval Limit Information
AR_APP_RULES_DFVAR_APP_RULESApplication Rules Information
AR_APP_RULE_DETAILS_DFVAR_APP_RULE_DETAILSApplication Rule Details Information
AR_APP_RULE_SETS_DFVAR_APP_RULE_SETSApplication Rule Sets Information
AR_AUTOCASH_HIERARCHIES_DFVAR_AUTOCASH_HIERARCHIESAutoCash Hierarchies Information
AR_AUTOCASH_RULES_DFVAR_AUTOCASH_RULESAutoCash Rules Information
AR_BATCHES_ALL_DFVAR_BATCHESBatch Information
AR_BATCH_SOURCES_ALL_DFVAR_BATCH_SOURCESBatch Source Information
AR_CASH_RECEIPTS_ALL_DFVAR_CASH_RECEIPTSReceipt Information
AR_CASH_RECEIPTS_ALL1_DFVAR_CASH_RECEIPTS_GOVGovernment Receipt Information
AR_COLLECTORS_DFVAR_COLLECTORSCollector Information
AR_CREDIT_HISTORIES_DFVAR_CREDIT_HISTORIESCredit History Information
AR_CUSTOMER_CALLS_ALL_DFVAR_CUSTOMER_CALLSCustomer Call Information
AR_CUSTOMER_CALL_TOPICS_AL_DFVAR_CUSTOMER_CALL_TOPICSCall Topic Information
AR_CUSTOMER_PROFILES_DFVAR_CUSTOMER_PROFILESCustomer Credit Profile Information OLD
AR_CUSTOMER_PROFILE_AMOUNT_DFVAR_CUSTOMER_PROFILE_AMOUNTSCustomer Profile Amounts OLD
AR_CUSTOMER_PROFILE_CLASSE_DFVAR_CUSTOMER_PROFILE_CLASSESCredit Profile Class Information OLD
AR_CUST_PROF_CLASS_AMOUNTS_DFVAR_CUST_PROF_CLASS_AMOUNTSCustomer Profile Class Amounts OLD
AR_DUNNING_LETTERS_B_DFVAR_DUNNING_LETTERSDunning Letter Information
AR_DUNNING_LETTER_SETS_DFVAR_DUNNING_LETTER_SETSDunning Letter Set Information
AR_DUNNING_LETTER_SET_LINE_DFVAR_DUNNING_LETTER_SET_LINESDunning Letter Sequence Information
AR_INTERIM_CASH_RECEIPTS_1_DFVAR_INTERIM_CASH_RECEIPTS_GOVGovernment QuickCash Information
AR_INTERIM_CASH_RCPT_LINES_DFVAR_INTERIM_CASH_RECEIPT_LINESQuickcash Line Information
AR_INTERIM_CASH_RCPT_LINE1_DFVAR_INT_CASH_RECEIPT_LINES_GOVGovernment QuickCash Line Information
AR_LOCATION_COMBINATIONS_DFVAR_LOCATION_COMBINATIONSLocation Combination Information
AR_LOCATION_RATES_DFVAR_LOCATION_RATESSales Tax Rate Information
AR_LOCATION_RATES1_DFVAR_LOCATION_RATES_OVERRIDEOverride Sales Tax Rates
AR_LOCATION_VALUES_DFVAR_LOCATION_VALUESLocation Information
AR_LOCKBOXES_ALL_DFVAR_LOCKBOXESLockbox Information
AR_MEMO_LINES_ALL_B_DFVAR_MEMO_LINESMemo Line Information
AR_MISC_CASH_DISTRIBUTIONS_DFVAR_MISC_CASH_DISTRIBUTIONSAccounting Distribution Information
AR_MISC_CASH_DISTRIBUTION1_DFVAR_MISC_CASH_DISTRIBUTIONS_GOVGovernment Distribution Information
AR_PAYMENTS_INTERFACE_ALL_DFVAR_PAYMENTS_INTERFACEPayment Interface Information
AR_PAYMENT_SCHEDULES_ALL_DFVAR_PAYMENT_SCHEDULESPayment Schedule Information
AR_RATE_ADJUSTMENTS_ALL_DFVAR_RATE_ADJUSTMENTSRate Adjustment Information
AR_RECEIPT_CLASSES_DFVAR_RECEIPT_CLASSESReceipt Class Information
AR_RECEIPT_METHODS_DFVAR_RECEIPT_METHODSPayment Method Information
AR_RECEIPT_METHOD_ACCOUNTS_DFVAR_RECEIPT_METHOD_ACCOUNTSRemittance Bank Information
AR_RECEIVABLES_TRX_ALL_DFVAR_RECEIVABLES_TRXReceivables Activity Information
AR_RECEIVABLE_APPLICATIONS_DFVAR_RECEIVABLE_APPLICATIONSReceipt Application Information
AR_RECEIVABLE_APPLICATION1_DFVAR_RECEIVABLE_APPLICATIONS_GOVGovernment Application Information
AR_SALES_TAX_DFVAR_SALES_TAXSales Tax Information
AR_SALES_TAX1_DFVAR_SALES_TAX_RATESSales Tax Rate Assignment
AR_STANDARD_TEXT_B_DFVAR_STANDARD_TEXTStandard Text Information
AR_STATEMENT_CYCLES_DFVAR_STATEMENT_CYCLESStatement Cycle Information
AR_SYSTEM_PARAMETERS_ALL_DFVAR_SYSTEM_PARAMETERSSystem Parameter Information
AR_TAX_CONDITIONS_ALL_DFVAR_TAX_CONDITIONSTax Condition Information
AR_TAX_CONDITION_ACTIONS_A_DFVAR_TAX_CONDITION_ACTIONS_ALLTax Condition Action Information
AR_TAX_CONDITION_LINES_ALL_DFVAR_TAX_CONDITION_LINESTax Condition Line Information
AR_TAX_GROUP_CODES_ALL_DFVAR_TAX_GROUP_CODES%Item Exception%
AR_TRANSMISSIONS_ALL_DFVAR_TRANSMISSIONSTransmission Information
AR_TRANSMISSION_FORMATS_DFVAR_TRANSMISSION_FORMATSTransmission Format Information
AR_TRANS_RECORD_FORMATS_DFVAR_TRANS_RECORD_FORMATSTransmission Records
AR_VAT_TAX_ALL_B_DFVAR_VAT_TAXVAT Rate Information
RA_TAX_EXEMPTIONS_ALL_DFVAR_VDR_EXEMPT_RATESVendor Exempt Rates
RA_ACCOUNT_COMBINATIONS_DFVRA_ACCOUNT_COMBINATIONSAccount Combination Information
RA_ACCOUNT_DEFAULTS_ALL_DFVRA_ACCOUNT_DEFAULTSAccount Default Information
RA_ACCOUNT_DEFAULT_SEGMENT_DFVRA_ACCOUNT_DEFAULT_SEGMENTSDefault Segment Information
RA_ADDRESSES_ALL_DFVRA_ADDRESSESAddress Information OLD
RA_BATCHES_ALL_DFVRA_BATCHESRevenue Batch Information
RA_BATCH_SOURCES_ALL_DFVRA_BATCH_SOURCESRevenue Batch Source Information
RA_CONTACTS_DFVRA_CONTACTSContact Information OLD
RA_CONTACT_ROLES_DFVRA_CONTACT_ROLESContact Role Information OLD
RA_CUSTOMERS_DFVRA_CUSTOMERSCustomer Information OLD
RA_CUSTOMER_MERGES_DFVRA_CUSTOMER_MERGESCustomer Merge Information
RA_CUSTOMER_RELATIONSHIPS__DFVRA_CUSTOMER_RELATIONSHIPSCustomer Relationship Information OLD
RA_CUSTOMER_TRX_ALL1_DFVRA_CUSTOMER_TRX_GOVGovernment Transaction Information
RA_CUSTOMER_TRX_LINES_ALL_DFVRA_CUSTOMER_TRX_LINESInvoice Line Information
RA_CUSTOMER_TRX_LINES_ALL1_DFVRA_CUSTOMER_TRX_LINES_GOVGovernment Transaction Line Information
RA_CUSTOMER_TRX_LINES_ALL2_DFVRA_CUSTOMER_TRX_LINES_ITEMSItems Information
RA_CUST_RECEIPT_METHODS_DFVRA_CUST_RECEIPT_METHODSCustomer Payment Method Information
RA_CUST_TRX_LINE_GL_DIST_A_DFVRA_CUST_TRX_LINE_GL_DISTLine Distribution Information
RA_CUST_TRX_LINE_GL_DIST_1_DFVRA_CUST_TRX_LINE_GL_DIST_GOVGovernment Line Distribution Information
RA_CUST_TRX_LINE_SALESREPS_DFVRA_CUST_TRX_LINE_SALESREPSSales Representative Line Information
RA_CUST_TRX_TYPES_ALL_DFVRA_CUST_TRX_TYPESTransaction Type Information
RA_GROUPING_RULES_DFVRA_GROUPING_RULESGrouping Rule Information
RA_GROUPING_TRX_TYPES_DFVRA_GROUPING_TRX_TYPESGrouping Transaction Type Information
RA_GROUP_BYS_DFVRA_GROUP_BYSGroup By Information
RA_INTERFACE_DISTRIBUTIONS_DFVRA_INTERFACE_DISTRIBUTIONSInterface Distribution Information
RA_CUSTOMER_TRX_ALL2_DFVRA_INTERFACE_HEADERInvoice Transaction Flexfield
RA_INTERFACE_LINES_ALL_DFVRA_INTERFACE_LINESLine Transaction Flexfield
RA_INTERFACE_LINES_ALL1_DFVRA_INTERFACE_LINES_GOVGovernment Interface Line Information
RA_INTERFACE_LINES_ALL2_DFVRA_INTERFACE_LINK_TOLink-to Transaction Flexfield
RA_INTERFACE_LINES_ALL3_DFVRA_INTERFACE_REFERENCEReference Transaction Flexfield
RA_INTERFACE_SALESCREDITS__DFVRA_INTERFACE_SALESCREDITSInterface Salescredits Information
RA_ITEM_EXCEPTION_RATES_DFVRA_ITEM_EXCEPTION_RATESItem Exception Rate Information
RA_ITEM_EXCEPTION_RATES1_DFVRA_ITEM_EXCEPTION_RATES_LOCItem Exception Rate Location
RA_ITEM_EXCEPTION_RATES2_DFVRA_ITEM_EXCEPTION_RATES_RATESItem Exception Rate Assignment
RA_LINE_ORDERING_RULES_DFVRA_LINE_ORDERING_RULESLine Ordering Rule Information
RA_LINE_ORDER_BYS_DFVRA_LINE_ORDER_BYSLine Order By Information
RA_PHONES_DFVRA_PHONESTelephone Number Information OLD
RA_REMIT_TOS_ALL_DFVRA_REMIT_TOSRemit Address Information
RA_RULES_DFVRA_RULESInvoice and Accounting Rule Information
RA_RULE_SCHEDULES_DFVRA_RULE_SCHEDULESRule Schedule Information
RA_SALESREPS_ALL_DFVRA_SALESREPSSales Representative Information
RA_SALESREP_TERRITORIES_DFVRA_SALESREP_TERRITORIESSalesrep/Agent Territory Information
RA_SITE_USES_ALL_DFVRA_SITE_USESSite Use Information OLD
RA_TAX_EXEMPTIONS_ALL1_DFVRA_TAX_EXEMPTIONSTax Exemption Information
RA_TAX_EXEMPTIONS_ALL2_DFVRA_TAX_EXEMPTION_REGIONSExempt Regions
RA_TERMS_B_DFVRA_TERMSPayment Term Information
RA_TERMS_LINES_DFVRA_TERMS_LINESPayment Term Line Information
RA_TERMS_LINES_DISCOUNTS_DFVRA_TERMS_LINES_DISCOUNTSPayment Term Line Discount Information
RA_TERRITORIES_DFVRA_TERRITORIESTerritory Information
RA_ADDRESSES_ALL1_DFVRemit AddressAddress OLD
RA_CUSTOMER_MERGE_HEADERS_DFVRA_CUSTOMER_MERGE_HEADERSCustomer Merge Header Information
RA_CUSTOMER_TRX_ALL_DFVRA_CUSTOMER_TRXTransaction Information
HZ_PARTY_SITES_DFVHZ_PARTY_SITESParty Site Information
HZ_ORG_CONTACTS_DFVHZ_ORG_CONTACTSOrganization Contact Information
HZ_PARTY_USG_ASSIGNMENTS_DFVHZ_PARTY_USG_ASSIGNMENTSParty Usage Assignments Information
HZ_PARTIES_DFVHZ_PARTIESParty Information
AR_REVENUE_ADJUSTMENTS_ALL_DFVAR_REVENUE_ADJUSTMENTSRevenue Adjustment Information
HZ_CUSTOMER_PROFILES_DFVAR_CUSTOMER_PROFILES_HZCustomer Credit Profile Information
HZ_CUST_PROFILE_AMTS_DFVAR_CUSTOMER_PROFILE_AMOUNTS_HZCustomer Profile Amounts
HZ_CUST_PROFILE_CLASSES_DFVAR_CUSTOMER_PROFILE_CLASSES_HZCredit Profile Class Information
HZ_CUST_PROF_CLASS_AMTS_DFVAR_CUST_PROF_CLASS_AMOUNTS_HZCustomer Profile Class Amounts
HZ_LOCATIONS1_DFVRemit Address HZAddress
HZ_CUST_ACCT_SITES_ALL_DFVRA_ADDRESSES_HZAddress Information
HZ_CUST_ACCOUNT_ROLES_DFVRA_CONTACTS_HZContact Information
HZ_ROLE_RESPONSIBILITY_DFVRA_CONTACT_ROLES_HZContact Role Information
HZ_CUST_ACCOUNTS_DFVRA_CUSTOMERS_HZCustomer Information
HZ_CUST_ACCT_RELATE_ALL_DFVRA_CUSTOMER_RELATIONSHIPS_HZCustomer Relationship Information
HZ_CONTACT_POINTS_DFVRA_PHONES_HZTelephone Number Information
HZ_CUST_SITE_USES_ALL_DFVRA_SITE_USES_HZSite Use Information
AR_BR_STAMP_VALUES_ALL_DFVAR_BR_STAMP_VALUESBills Receivable Stamp Values
AR_TRANSACTION_HISTORY_ALL_DFVAR_TRANSACTION_HISTORYTransaction history
AR_INTERIM_CASH_RECEIPTS_A_DFVAR_INTERIM_CASH_RECEIPTSQuickCash Receipt
HZ_RELATIONSHIPS_DFVHZ_RELATIONSHIPSRelationship Information
HZ_PERSON_PROFILES_DFVHZ_PERSON_PROFILESPerson Information
HZ_LOCATIONS_DFVHZ_LOCATIONSTCA Location Information
HZ_ORGANIZATION_PROFILES_DFVHZ_ORGANIZATION_PROFILESOrganization Information
HZ_CREDIT_USAGE_RULES_DFVHZ_CREDIT_USAGE_RULESCredit Usage Rules
HZ_CREDIT_USAGES_DFVHZ_CREDIT_USAGESCredit Usages
HZ_CREDIT_PROFILE_AMTS_DFVHZ_CREDIT_PROFILE_AMTSCredit Profile Amounts
HZ_ORIG_SYS_MAPPING_DFVHZ_ORIG_SYS_MAPPINGSource System Entity Mapping
HZ_ORIG_SYS_REFERENCES_DFVHZ_ORIG_SYS_REFERENCESSource System References
AR_GTA_TRX_LINES_ALL_DFVAR_GTA_TRX_LINES_ALLGTA Workbench: Line
AR_ACTIVITY_DETAILS_DFVAR_ACTIVITY_DETAILSLine Level Receipt Application Information
HZ_CREDIT_RATINGS_EXT_B_DFVHZ_CREDIT_RATINGS_GROUPCredit Ratings Extension
HZ_FIN_NUMBERS_EXT_B_DFVHZ_FIN_NUMBERS_GROUPFinancial Numbers Extension
HZ_FIN_REPORTS_EXT_B_DFVHZ_FIN_REPORTS_GROUPFinancial Reports Extension
HZ_LOCATIONS_EXT_B_DFVHZ_LOCATIONS_GROUPLocations Extension
HZ_ORG_PROFILES_EXT_B_DFVHZ_ORG_PROFILES_GROUPOrganization Profiles Extension
HZ_PARTY_SITES_EXT_B_DFVHZ_PARTY_SITES_GROUPParty Sites Extension
HZ_PER_PROFILES_EXT_B_DFVHZ_PERSON_PROFILES_GROUPPerson Profiles Extension
RA_CUSTOMER_TRX_LINES_ALL3_DFVRA_CUST_TRX_TAX_EXEMPT_DDFTax Exemption