Friday, November 11, 2016

Oracle EBS AR / Interview questions focus




  • AR documents
  • Interfaces
    • Standard interface programs in AR
      • Autoinvoice
      • Autolockbox
      • Customer interface
  • Conversions
  • Customers
    • Party
    • Customer Account
    • Customer Locations - Sites
    • Site Uses
  • Accounting
    • Periods - AR/GL
    • Create Accounting
      • Working
      • Tables
      • Link to GL - GL_SL_LINK_ID from xla_ae_lines to gl_import_references
  • Receipt
    • Types of receipts - Sign
    • Receipt Class
    • Receipt Method
    • Receipt bank account
    • Receipt customer
    • Receipt tables
    • Receipt life cycle
    • Accounting for receipts
    • Autolockbox
      • Stages
        • Import
        • Validation
        • Postquickcash
      • Functioning
      • Setup
        • Lockbox number
      • Staging/interface tables
    • Receipt Reversal
      • Receipt Reversal
      • Debit Memo Reversal
    • Receipt batch
    • Receipt activity (write-off, Refund)
    • Receipt application
    • On-account application
  • Transactions
    • Setup
      • Batch source
        • Automatic numbering
        • Automatic batch numbering
        • Type: Manual/Imported
      • Transaction type
        • Natural application/Allow overapplication flags
      • AutoAccounting setup
    • Invoice
      • Ways to create Invoices
        • Autoinvoice - created_from = RAXTRX
        • Manual Batch
        • Manual (UI)
    • Credit Memo
      • Types of CMs
        • Regular
        • On-Account
      • Payment term - No
    • Commitment
    • Chargeback
    • Autoinvoice
      • Autoinvoice Import program
      • Autoinvoice Master program
      • Autoinvoice Purge Program
        • Do not need to run this program if 'Purge Interface Tables' option is set in system options
      • Interface tables
        • ra_interface_lines_all
          • Interface_status: NULL/P/E
        • ra_interface_salescredits_all
        • ra_interface_distributions_all
        • ra_interface_errors_all
      • Grouping Rule
        • Mandatory grouping rule columns
          • Ex. ORIG_SYSTEM_BATCH_NAME - (optional column - May be used as legacy batch name)
        • Optional columns
      • Validation
    • Invoicing Rule
      • -2/-3 - Advance/Arrears
    • Accounting Rule
  • Adjustments
    • Creation types
    • Adjustment type
    • Line type
    • User Approval limit
  • AR Public APIs
    • Transaction
    • Credit Memo
    • Receipts
    • Adjustment
  • Bank Accounts
  • Flexfields used in AR
    • Key Flexfield
    • Descriptive Flexfiled
      • Transaction Flexfields
      • Line Transaction Flexfields
  • Personalizations
    • Form/Function Level
    • Resp/User/Global
    • Condition
      • Triggers
        • When-New-Record-Insstance
        • When-New-Item-Instance
        • When-Validate-Record
    • Action
  • Custom .pll
  • AR Tables
    • ra_batches_all
    • ra_customer_trx_all
    • ra_cust_trx_lines_all
    • ra_cust_trx_line_salesreps_all
    • ra_cust_trx_line_gl_dist_all
    • ar_payment_schedules_all
    • ar_cash_receipts_all
    • ar_cash_receipt_history_all
    • ar_receivable_applications_all
    • ar_distributions_all
    • ar_adjustments_all
    • ar_batches_all

No comments:

Post a Comment

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...