1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Tax and revenue recognition tables

Discussion in 'Oracle Apps Technical' started by Bharat, Apr 11, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Can I know what are tables used to identify TAX details like jurisdiction code, Regime code etc. And also what are the tables we are going to use to identify revenue recognition details.
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    I will post the details sometime shortly.
    cheers
    Ramji
     
  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharat,

    Do not look at it from a purely technical angle.Just a quick Note ,the Architecture is beautiful. As you read more you will learn to appreciate it. From a simple purpose of defining tax rates in 11i it has evolved into a fullblown product that caters to all the modules and business requirements from a centralized workbench.

    Very Easy to Remember Tax Jurisdictions, Authorities and Regimes, Tax, Status and Rates all connected to Parties with a permutation and combination of Global definitions. I suggest you read the Legal Entity model in R12 and understand it thoroughly. Once you do it this module is a piece of cake.
    Cheers
    Ramji
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Thank you ramji.. I will go through Legal Entity model now.
     
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bharat,

    check this..
    Oracle E-Business Tax Tables:

    ZX_ACCOUNTS
    ZX_ACCOUNT_RATES
    ZX_ACCT_TX_CLS_DEFS_ALL
    ZX_API_CODE_COMBINATIONS
    ZX_API_OWNER_STATUSES
    ZX_API_REGISTRATIONS
    ZX_COMPOUND_ERRORS
    ZX_COMPOUND_ERRORS_T
    ZX_CONDITIONS
    ZX_CONDITION_GROUPS_B
    ZX_CONDITION_GROUPS_TL
    ZX_CONTENT_CHOICES_TMP
    ZX_CONTENT_SOURCES
    ZX_DATA_UPLOAD_INTERFACE
    ZX_DETAIL_TAX_LINES_GT
    ZX_DETERMINING_FACTORS_B
    ZX_DET_FACTORS_TL
    ZX_DET_FACTOR_TEMPL_B
    ZX_DET_FACTOR_TEMPL_DTL
    ZX_DET_FACTOR_TEMPL_TL
    ZX_ERRORS_GT
    ZX_EVENT_CLASSES_B
    ZX_EVENT_CLASSES_TL
    ZX_EVENT_CLASS_PARAMS
    ZX_EVNT_CLS_MAPPINGS
    ZX_EVNT_CLS_OPTIONS
    ZX_EVNT_CLS_TYPS
    ZX_EVNT_TYP_MAPPINGS
    ZX_EXCEPTIONS
    ZX_EXEMPTIONS
    ZX_FC_CODES_B
    ZX_FC_CODES_CATEG_ASSOC
    ZX_FC_CODES_DENORM_B
    ZX_FC_CODES_TL
    ZX_FC_COUNTRY_DEFAULTS
    ZX_FC_TYPES_B
    ZX_FC_TYPES_REG_ASSOC
    ZX_FC_TYPES_TL
    ZX_FORMULA_B
    ZX_FORMULA_DETAILS
    ZX_FORMULA_TL
    ZX_ID_TCC_MAPPING_ALL
    ZX_IMPORT_TAX_LINES_GT
    ZX_ITM_DISTRIBUTIONS_GT
    ZX_JURISDICTIONS_B
    ZX_JURISDICTIONS_GT
    ZX_JURISDICTIONS_TL
    ZX_LINES
    ZX_LINES_DET_FACTORS
    ZX_LINES_SUMMARY
    ZX_PARAMETERS_B
    ZX_PARAMETERS_TL
    ZX_PARAM_DETAILS
    ZX_PARTY_TAX_PROFILE
    ZX_PARTY_TYPES
    ZX_PO_REC_DIST
    ZX_PROCESS_RESULTS
    ZX_PRODUCT_OPTIONS_ALL
    ZX_PRVDR_HDR_EXTNS_GT
    ZX_PRVDR_LINE_EXTNS_GT
    ZX_PTNR_LOCATION_INFO_GT
    ZX_PTNR_NEG_LINE_GT
    ZX_PTNR_NEG_TAX_LINE_GT
    ZX_PURGE_TRANSACTIONS_GT
    ZX_RATES_B
    ZX_RATES_TL
    ZX_RECOVERY_TYPES_B
    ZX_RECOVERY_TYPES_TL
    ZX_REC_NREC_DIST
    ZX_REC_NREC_DIST_GT
    ZX_REGIMES_B
    ZX_REGIMES_TL
    ZX_REGIMES_USAGES
    ZX_REGIME_RELATIONS
    ZX_REGISTRATIONS
    ZX_REPORTING_CODES_B
    ZX_REPORTING_CODES_TL
    ZX_REPORTING_TYPES_B
    ZX_REPORTING_TYPES_TL
    ZX_REPORT_CODES_ASSOC
    ZX_REPORT_TYPES_USAGES
    ZX_REP_ACTG_EXT_T
    ZX_REP_CONTEXT_T
    ZX_REP_MATRIX_EXT_T
    ZX_REP_TRX_DETAIL_T
    ZX_REP_TRX_JX_EXT_T
    ZX_REVERSE_DIST_GT
    ZX_REVERSE_TRX_LINES_GT
    ZX_RULES_B
    ZX_RULES_TL
    ZX_SERVICE_TYPES
    ZX_SIM_CONDITIONS
    ZX_SIM_PROCESS_RESULTS
    ZX_SIM_PURGE
    ZX_SIM_RULES_B
    ZX_SIM_RULES_TL
    ZX_SIM_RULE_CONDITIONS
    ZX_SIM_TRX_DISTS
    ZX_SRVC_SBSCRPTN_EXCLS
    ZX_SRVC_SUBSCRIPTIONS
    ZX_SRVC_TYP_PARAMS
    ZX_STATUS_B
    ZX_STATUS_TL
    ZX_SUBSCRIPTION_DETAILS
    ZX_SUBSCRIPTION_OPTIONS
    ZX_TAXES_B
    ZX_TAXES_TL
    ZX_TAX_PRIORITIES_T
    ZX_TAX_RELATIONS_T
    ZX_TRANSACTION
    ZX_TRANSACTION_LINES
    ZX_TRANSACTION_LINES_GT
    ZX_TRX_HEADERS_GT
    ZX_TRX_LINE_APP_REGIMES
    ZX_TRX_PRE_PROC_OPTIONS_GT
    ZX_TRX_TAX_LINK_GT
    ZX_UPDATE_CRITERIA_RESULTS
    ZX_VALIDATION_ERRORS_GT
     
  6. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Revenue Recognition Details are stored here..

    Field Name Description
    INVOICING_RULE_ID Contains the Invoicing rule id, value = -2 or -3
    ACCOUNTING_RULE_ID Contains Accounting rule id
    ACCOUNTING_RULE_DURATION Contains the number of periods
    AUTORULE_DURATION_PROCESSED Upon creation of an invoice with rules, this field is null. When the Revenue Recognition process is run, this field will get incremented to reflect the number of periods for which revenue has already been recognized.
    AUTORULE_COMPLETE_FLAG Upon creation of an invoice with rules, this field is N. When the Revenue Recognition process is run and completes processing all periods for this line, this field will get updated to null.
    RULE_START_DATE Contains the start date
    RULE_END_DATE Contains the end date (if provided)
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    Actually I have submitted Revenue Recognition Program but it doesn't updates those fields from ra_customer_trx_all and ra_customer_trx_lines_all two tables. Is there any setup exists for revenue recognition to get updated of these fields.
     
  8. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Yes you need to setup for revenue to be recognized according to your requirements. I believe the documents you contain the necessary info.
    Ramji
     
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    Yes bhai in that document there are setups for that. I have gone through them. Its working fine now. Thanks alot.