Oracle-Demantra-Overview

The following link give an example of Oracle Demantra

http://www.scribd.com/doc/31527296/Oracle-Demantra-Overview

Regards,
Sambhasiva Rao.

Oracle E-Business Tax

E-Business Tax provides a single point solution for managing your transaction-based tax requirements. E-Business Tax uniformly delivers tax services to all E-Business Suite business flows through one application interface. As global system architecture, E-Business Tax is configurable and scalable for adding and maintaining country-specific tax content.
With E-Business Tax, you can model your tax requirements according to the needs of local and international tax requirements. This includes:
• Both simple and complex country-specific tax legislation.
• Cross-border transactions.
• Local compliance requirements for recording and reporting.
• Continual changes to tax legislation, such as new taxes, local law changes, special tax rates, and special exceptions for products and customers.
You can manage the entire configuration and maintenance of tax content from the one E-Business Tax application. This ensures a uniform tax setup across applications, with a centrally managed system of automated tax services and control over manual intervention and update.

Note: You must have access to the system administrator responsibility to perform many of these tasks.

Setting Up Tax Users -- Optional

Setting Profile Option Values -- Optional

Setting Up Lookup Codes -- Optional

Setting Up TCA Geography Hierarchy -- Optional

Setting Up Legal Entity -- Mandatory

Setting Up Operating Units -- Mandatory

Setting Up Accounts and Accounting Information -- Mandatory

Setting Up TCA Classifications -- Optional

Setting Up Oracle Inventory -- Optional


Responsibilities: (Tax Users) (Optional)

Tax Manager: Main Responsibility for Setups , Configuration etc..

Tax Administrator: Support, normal modifications etc…

Tax simulator: assign to users, to test tax setups, business functionality etc…

U CAN MODIFY THE MENUS AS PER BUSINESS REQUIREMENT.

Profile Options: (Optional)

eBTax: Allow ad hoc Tax Changes : YES

eBTax : Allow manual Tax lines: YES

eBTax: Allow Override of Customer exemptions: YES

eBTax : Allow Override of Tax Classification Code: YES

eBTax : Allow Override of Tax Recovery Rate: NO DEFAULT VALUE

eBTax : Inventory Item for Freight : FREIGHT CHARGE

eBTax : Invoice Freight as Revenue: NO

eBTax : Read / Write Access to GCO Data: YES

eBTax Tax ware: Service Indicator: NON – SERVICE

eBTax Tax ware: Tax selection : JURISDICTION AND TAX

eBTax Tax ware: Use Nexpro : NO

eBTax Vertex: Case Sensitive: YES

eBTax profile options you can update at Site, Application, Responsibility levels.

eBTax Tax ware, eBTax Vertex profile options you can update at Site level only.

Lookup Codes: (Optional)

ZX_INPUT_CLASSIFICATIONS and ZX_OUTPUT_CLASSIFICATIONS

Release 11i tax codes and tax groups migrate to E-Business Tax as tax classification
codes. Payables and Purchasing tax codes migrate as tax classification codes under
ZX_INPUT_CLASSIFICATIONS. Receivables and Projects tax codes migrate as tax
classification codes under ZX_OUTPUT_CLASSIFICATIONS. You can set up additional
tax classification codes for use with a migrated tax data model or as an additional
determining factor in tax determination.

ZX_WEB_EXP_TAX_CLASSIFICATIONS

Internet Expenses related transactions.

ZX_EXEMPTION_REASON_CODE

The use of customer or product tax exemptions issued by the tax authority and applied to specific transactions.

ZX_JEBE_VAT_TRANS_TYPE

Use this lookup code to create tax transaction types for use with tax rate codes. You use transaction types when you set up a tax rate.

ZX_REGISTRATIONS_REASON

Use registration reason codes when you set up a tax registration to represent the reason for the tax registration.

ZX_REGISTRATIONS_TYPE

Use tax registration type codes when you set up a tax registration to organize your tax registrations into categories.

ZX_REGISTRATION_STATUS

Use tax registration status codes as determining factors in tax rules.

AGENT, REGISTERED, NOT REGISTERED.

ZX_TAX_TYPE_CATEGORY

Use tax types when you set up a tax.

SALES, VAT, EXCISE, CUSTOM DUTY & ENVIRONMENTAL.



TCA Geography Hierarchy (Optional)

Set up and maintain the TCA geography hierarchy for each country where you have a
tax requirement. The TCA geography hierarchy provides a single reference source for
all geographical and location-based information for all E-Business Suite applications.

You must set up and maintain the TCA geography hierarchy before you can perform
these tax-related setups:

Legal entities and establishments

Tax zones
Tax regimes
Taxes
Tax jurisdictions
Tax rules

Use TCA administration to maintain these aspects of the geography hierarchy:

Country structure
Geography types
Address validations


Legal Entity (Mandatory)

First party legal entity - The legal entities that represent your company.

First party legal establishments - The legal establishments that have or require tax
registrations, either implied or explicit, from one or more tax authorities.

Legal authorities - The legal authorities that represent the tax authorities in the tax regimes where you do business.

When you set up a legal entity or establishment, you can also set up party tax profile details, including general information, rounding rule, and tax registrations.

Legal Entities

Legal entity before you can perform these tax-related setups:

Party tax profiles
Configuration options
Configuration owner tax options



First Party Legal Establishments

Set up a legal establishment record for each office, service center, warehouse and any other location within the company that requires a registration with a tax authority for one or more taxes. You set up legal establishments under a parent legal entity.

When you set up legal establishments, you can also perform these tax-related setups:

Party tax profiles
Tax registrations

Legal Authorities

Set up a legal authority record for each tax authority that administers taxes in a tax regime where you do business. While not mandatory, you can set up legal authority
records before you perform these tax-related setups:

Tax authority tax profile
Basic tax configuration
Tax regimes, Taxes, Tax jurisdictions
Tax registrations
Tax exemptions

Operating Units (Mandatory)

Set up the operating units that you need to process your tax transactions. An operating unit is an organization that uses Oracle Cash Management, Order Management and Shipping Execution, Oracle Payables, Oracle Purchasing, or Oracle Receivables.

You must set up and maintain operating units before you can perform these tax-related
setups:

Party tax profiles
Tax configuration options
Tax accounts
Configuration owner tax options


Accounts and Accounting Information (Mandatory)

Set up accounts and accounting information for your tax transactions. You must set up
and maintain accounting information before you can set up tax accounts for the
applicable operating units. You set up tax accounts by operating unit for taxes, tax rates, tax jurisdictions, tax recovery rates, and tax registrations of first party legal establishments.

Review and complete these accounting setup tasks according to your requirements:

Ledgers
Legal entity balancing segments
Accounting setup
Complete the accounting setup


TCA Classifications (Optional)

Set up TCA classifications to classify third parties for tax purposes. You can define a TCA class category and class codes specifically for use in tax determination. You can also use standard classifications, such as the US Standard Industrial Classification (SIC) codes, and assign these codes a party fiscal classification.

Must set up and maintain TCA classifications before you can perform these tax-related setups:

Party fiscal classifications
Party tax profiles
Tax rules

Use TCA administration to set up and maintain classifications for use in party fiscal
classifications:

Class category
Allow Multiple Parent Codes
Allow Parent Code Assignment
Allow Multiple Class Code Assignments
Class codes

Oracle Inventory (Optional)

Use the Inventory Item Category functionality in Oracle Inventory to model product
fiscal classifications. You can create either a single product fiscal classification type or a hierarchy of product fiscal classification types that matches the segments of the Inventory category.



FOR MORE INFORMATION PLEASE FOLLOW Oracle® E-Business Tax Implementation Guide.

CORPORATE SOCIAL RESPONSIBILITY (CSR)

Government of India Guidelines

Fundamental Principle

Core Elements:
Each business entity should formulate a CSR policy to guide its
strategic planning and provide a roadmap for its CSR initiatives, which
should be an integral part of overall business policy and aligned with its
business goals. The policy should be framed with the participation of
various level executives and should be approved by the Board.

The CSR Policy should normally cover following core elements:

1. Care for all Stakeholders:
The companies should respect the interests of, and be responsive
towards all stakeholders, including shareholders, employees,
customers, suppliers, project affected people, society at large etc. and
create value for all of them. They should develop mechanism to actively
engage with all stakeholders, inform them of inherent risks and mitigate
them where they occur.

2. Ethical functioning:
Their governance systems should be underpinned by Ethics,
Transparency and Accountability. They should not engage in business
practices that are abusive, unfair, corrupt or anti-competitive.

3. Respect for Workers' Rights and Welfare:
Companies should provide a workplace environment that is safe,
hygienic and humane and which upholds the dignity of employees.
They should provide all employees with access to training and
development of necessary skills for career advancement, on an equal
and non-discriminatory basis. They should uphold the freedom of
association and the effective recognition of the right to collective
bargaining of labour, have an effective grievance redressal system,
should not employ child or forced labour and provide and maintain
equality of opportunities without any discrimination on any grounds in
recruitment and during employment.

4. Respect for Human Rights:
Companies should respect human rights for all and avoid complicity
with human rights abuses by them or by third party.

5. Respect for Environment:
Companies should take measures to check and prevent pollution;
recycle, manage and reduce waste, should manage natural resources
in a sustainable manner and ensure optimal use of resources like land
and water, should proactively respond to the challenges of climate
change by adopting cleaner production methods, promoting efficient
use of energy and environment friendly technologies.

6. Activities for Social and Inclusive Development:
Depending upon their core competency and business interest,
companies should undertake activities for economic and social
development of communities and geographical areas, particularly in the
vicinity of their operations. These could include: education, skill building
for livelihood of people, health, cultural and social welfare etc.,
particularly targeting at disadvantaged sections of society.

Implementation Guidance:

1. The CSR policy of the business entity should provide for an
implementation strategy which should include identification of
projects/activities, setting measurable physical targets with timeframe,
organizational mechanism and responsibilities, time schedules and
monitoring. Companies may partner with local authorities, business
associations and civil society/non-government organizations. They
may influence the supply chain for CSR initiative and motivate
employees for voluntary effort for social development. They may evolve
a system of need assessment and impact assessment while
undertaking CSR activities in a particular area. Independent evaluation
may also be undertaken for selected projects/activities from time to
time.

2. Companies should allocate specific amount in their budgets for CSR
activities. This amount may be related to profits after tax, cost of
planned CSR activities or any other suitable parameter.

3. To share experiences and network with other organizations the
company should engage with well established and recognized
programs/platforms which encourage responsible business
practices and CSR activities. This would help companies to improve on
their CSR strategies and effectively project the image of being socially
responsible.

4. The companies should disseminate information on CSR policy,
activities and progress in a structured manner to all their stakeholders
and the public at large through their website, annual reports, and other
communication media.

Journal Entries_Account Receivables

ACCOUNT RECEIVABLES:

Transaction Workbench:

Invoices

DR Receivables
CR Revenue
CR Tax (if you charge tax)
CR Freight (if you charge freight)


Invoice Rules: Bills in Arrears, Bills in Advance

Accounting Rules: Fixed, Variable

If you enter an invoice with a Bill in Arrears invoicing rule with a three month fixed duration accounting rule, Receivables creates the following journal entries:

In the first period of the rule:
DR Unbilled Receivables
CR Revenue

In the second period of the rule:
DR Unbilled Receivables
CR Revenue

In the third and final period of the rule:
DR Unbilled Receivables
CR Revenue


DR Receivables
CR Unbilled Receivables
CR Tax (if you charge tax)
CR Freight (if you charge freight)


If you enter an invoice with a Bill in Advance invoicing rule, Receivables creates the following journal entries:

In the first period of the rule:
DR Receivables
CR Unearned Revenue
CR Tax (if you charge tax)
CR Freight (if you charge freight)

DR Unearned Revenue
CR Revenue

In all periods of the rule for the portion that is recognized.
DR Unearned Revenue
CR Revenue


Credit Memos

When you credit an invoice, debit memo, or chargeback through the Credit Transactions window, Receivables creates the following journal entry:
AR: Use Invoice Accounting for Credit Memos is set to No, Receivables uses AutoAccounting to determine the Freight, Receivables, Revenue, and Tax accounts.

DR Revenue
DR Tax (if you credit tax)
DR Freight (if you credit freight)
CR Receivables (Credit Memo)

AR: Use Invoice Accounting for Credit Memos is set to Yes, ceivables credits the accounts of the original transaction.

DR Receivables (Credit Memo)
CR Receivables (Invoice)

When you credit a commitment, Receivables creates the following journal entries:
DR Revenue
CR Receivables



You can delete an incomplete credit memo if the system option Allow Invoice Deletion is set to Yes.

If the profile option AR: Use Invoice Accounting for Credit Memos is set to Yes, Receivables credits the accounts of the original transaction. If this profile option is set to No, Receivables uses AutoAccounting to determine the Freight, Receivables, Revenue, and Tax accounts. Receivables uses the account information for on-account credits that you specified in your AutoAccounting structure to create your journal entries.

Receivables lets you update accounting information for your credit memo after it has posted to your general ledger. Receivables keeps the original accounting information as an audit trail while it creates an offsetting entry and the new entry.


Commitments

When you enter a deposit, Receivables creates the following journal entry:
DR Receivables (Deposit)
CR Offset Account

Use the AR: Deposit Offset Account Source profile option to determine how Receivables derives the Offset Account to credit for this deposit.

AR: Deposit Offset Account Source (Profile)

This option indicates which accounting source to use for a deposit's offset account. Receivables can use either AutoAccounting or the deposit's transaction type as the accounting source for the offset account.

When you enter an invoice against this deposit, Receivables creates the following journal entries:
DR Receivables (Invoice)
CR Revenue
CR Tax (if you charge tax)
CR Freight (if you charge freight)

DR Offset Account (such as Unearned Revenue)
CR Receivables (Invoice)


When you apply an invoice to a deposit, Receivables creates a receivable adjustment against the invoice. Receivables uses the account information that you specified in your AutoAccounting structure to create these entries.

When cash is received against this deposit,
Receivables creates the following journal entry:
DR Cash
CR Receivables (Deposit)


When you enter a guarantee, Receivables creates the following journal entry:
DR Receivables
CR Revenue



You can define multiple transaction types with a class of either Deposit or Guarantee to classify or group your commitments for reporting purposes. Transaction types for commitments also provide additional control features, such as accounting controls, printing controls, and other defaults

When you enter an invoice against this guarantee, Receivables creates the following journal entry:
DR Receivables (Invoice)
CR Revenue
CR Tax (if you charge tax)
CR Freight (if you charge freight)

DR Revenue
CR Receivables


When you apply an invoice to a guarantee, Receivables creates a receivable adjustment against the guarantee. Receivables uses the account information you specified in your AutoAccounting structure to create these entries.

When cash is received against this guarantee, Receivables creates the following journal entry:
DR Cash
CR Receivables (Invoice)


Receipts

When you enter a receipt, Receivables creates the following journal entries:
DR Cash
CR Receivables

When you fully apply a receipt to an invoice, Receivables creates the following journal entry:

DR Cash
DR Unapplied Cash
CR Unapplied Cash
CR Receivables

Note: These examples assume that the receipt has a Remittance Method of No Remittance and a Clearance Method of Directly.

When you enter an unidentified receipt, Receivables creates the following journal entry:
DR Cash
CR Unidentified

When you enter an on-account receipt, Receivables creates the following journal entry:
DR Cash
CR Unapplied

DR Unapplied
CR On-Account


When your receipt includes a discount, Receivables creates the following journal entry:
DR Receivables
CR Revenue

DR Cash
CR Receivables

DR Earned/Unearned Discount
CR Receivables

Receivables uses the default Cash, Unapplied, Unidentified, On-Account, Unearned, and Earned accounts that you specified in the Remittance Banks window for this receipt class.

When you enter a receipt and combine it with an on-account credit (which increases the balance of the receipt), Receivables creates the following journal entry:
DR Cash
CR Unapplied Cash


To close the receivable on the credit memo and increase the unapplied cash balance, Receivables creates the following journal entry:
DR Receivables
CR Unapplied Cash


When you enter a receipt and combine it with a negative adjustment, Receivables creates the following journal entries:
DR Cash
CR Receivables (Invoice)

DR Write-Off
CR Receivables (Invoice)

If you set up a Write-Off account when defining your Receivables Activity.

When you enter a receipt and combine it with a positive adjustment, Receivables creates the following journal entries:
DR Cash
CR Receivables (Invoice)

DR Receivables (Invoice)
CR Write-Off


When you write off the unapplied amount on a receipt, Receivables creates the following journal entries:
DR Unapplied Cash
CR Write-off


When you enter a receipt and combine it with a Chargeback, Receivables creates the following journal entries:
DR Cash
CR Receivables (Invoice)

DR Receivables (Chargeback)
CR Chargeback (Activity)

DR Chargeback (Activity)
CR Receivables (Invoice)
You set up a Chargeback account when defining your Receivables Activity.

To move funds between receipts, you can apply one receipt to another open receipt (also called netting receipts). For example, you can move funds from Receipt 1 to Receipt 2 by opening Receipt 2 in the Applications window, and selecting Receipt 1 in the Apply To field.

You can net receipts in Receivables. To net receipts, you apply a receipt against another open receipt, and then apply the resulting unapplied receipt balance to a transaction.
Open receipts include receipts that have:

Unapplied cash
On-account cash
Open claim investigation applications

You can also apply one receipt against another receipt that has an open claim investigation application. A claim investigation application results from either a noninvoice-related deduction or an overpayment.

Note: Receivables automatically updates Trade Management when you make a receipt application against a second receipt that has an open claim investigation.
Attention: When netting receipts, both receipts must be in the same currency.

Following the example above, Receivables creates these journal entries:
DR Unapplied Cash (Receipt 1)
CR Netting (Receipt 1)

DR Netting (Receipt 2)
CR Unapplied Cash (Receipt 2)

After this receipt-to-receipt application completes, Receipt 2 gains additional funds that you can then apply to a debit item.
You set up a Netting account when defining your Receivables Activity.

If both receipts are in a foreign currency, however, then you could have an exchange gain or loss when you net the receipts. The exchange gain or loss is realized on the main receipt (Receipt 2) at the time of receipt application (netting).
If you later adjust the exchange rate on Receipt 1 or 2, then Receivables:
Rolls back all accounting for both receipts.
Re-creates the accounting, including the netting application, using the adjusted exchange rate.
Recalculates the exchange gain or loss on whichever receipt is open in the Applications window.


Remittances

When you create a receipt that requires remittance to your bank, Receivables debits the Confirmation account instead of Cash. An example of a receipt requiring remittance would be a check before it was cashed. Receivables creates the following journal entry when you enter such a receipt:
DR Confirmation
CR Receivables

You can then remit the receipt to your remittance bank using one of the two remittance methods: Standard or Factoring. If you remit your receipt using the standard method of remittance, Receivables creates the following journal entry:
DR Remittance
CR Confirmation

When you clear the receipt, Receivables creates the following journal entry:
DR Cash
DR Bank Charges
CR Remittance

If you remit your receipt using the factoring remittance method, Receivables creates the following journal entry:
DR Factor
CR Confirmation

When you clear the receipt, Receivables creates a short-term liability for receipts that mature at a future date. The factoring process let you receive cash before the maturity date, and assumes that you are liable for the receipt amount until the customer pays the balance on the maturity date. When you receive payment, Receivables creates the following journal entry:

DR Cash
DR Bank Charges
CR Short-Term Debt

On the maturity date, Receivables reverses the short term liability and creates the following journal entry:
DR Short-Term Debt
CR Factor

Adjustments

When you enter a negative adjustment against an invoice, Receivables creates the following journal entry:

DR Write-Off
CR Receivables (Invoice)

When you enter a positive adjustment against an invoice, Receivables creates the following journal entry:

DR Receivables (Invoice)
CR Write-Off

Debit Memos

When you enter a debit memo in the Transactions window, Receivables creates the following journal entries:

DR Receivables
CR Revenue (if you enter line amounts)
CR Tax (if you charge tax)
CR Freight (if you charge freight)

DR Receivables
CR Finance Charges

On-Account Credits

When you enter an on-account credit in the Applications window, Receivables creates the following journal entry:

DR Revenue (if you credit line amounts)
DR Tax (if you credit tax)
DR Freight (if you credit freight)
CR Receivables (On-account Credit)

Receivables uses the Freight, Receivable, Revenue, and Tax accounts that you specified in your AutoAccounting structure to create these entries.

Once the on-account credit is applied to an invoice, the following journal entry is created:
DR Receivables (On-account Credit)
CR Receivables (Invoice)


Credit Card Refunds

When you unapply a receipt and reapply the receipt to a credit card refund, Receivables creates these journal entries:

DR Receivables
CR Unapplied

DR Unapplied
CR Receivable Activity (Clearing Account)

After you apply the receipt to a credit card refund, Receivables automatically creates a negative miscellaneous receipt in the amount of the refund and creates this journal entry:

DR Receivable Activity (Clearing Account)
CR Cash

Reversing a credit card refund

When you reverse a credit card refund, either by reversing the negative miscellaneous receipt or by unapplying the credit card refund activity, Receivables creates this journal entry for the negative miscellaneous receipt:

DR Cash
CR Receivable Activity (Clearing Account)

and Receivables creates this journal entry for the original payment receipt:

DR Receivables Activity (Clearing Account)
CR Unapplied

Claims

Creating an invoice related claim

When you record an invoice related short payment as a claim in the Applications window, Receivables creates the standard accounting entries for the invoice and for the receipt application. There are no additional accounting entries for the invoice related claim.

Creating a non-invoice related claim

When you record a non-invoice related short payment or over payment as a claim investigation application in the Applications window, Receivables creates these journal entries:

DR Claim Investigation
CR Unapplied Cash

Receivables derives the accounting flexfield for the claim investigation application from the receivable activity that you assigned in the Applications window.



AR: Default Exchange Rate Type (Profile)

This option determines the default exchange rate to use when converting foreign currency transactions to your functional currency. Valid values are:
Corporate Exchange Rate - An exchange rate you define to standardize rates for your company. This rate is usually a standard market rate determined by senior financial management for use throughout the organization.
Spot Exchange Rate - An exchange rate you enter to perform a conversion based on the rate on a specific date.
User Specified Rate - An exchange rate you specify when entering a foreign currency transaction.

Period End Close Dependencies

General – Period End Close Dependencies
Before you start with the Period-End process you have to know what the dependencies are between the various modules as described in this document.

The dependencies between some of the main Financials products and a couple of supply chain products.

You have to close Oracle Payables before you close Oracle Purchasing to account for purchasing accruals at period end. You also need to close Oracle Payables before you close Oracle Inventory and Oracle Assets.
You actually have to close Oracle Cash Management before you close Oracle Receivables, as bank reconciliation in Cash Management will create miscellaneous receipts in Oracle Receivables. Finally, you close all of your subledgers before you close General Ledger.

Projects
Order Management
Cash Management
Payables
Receivables
Purchasing
Inventory / Cost Management
Assets
Treasury
General Ledger.

Public Sector Budgetting

Oracle Public Sector Budgeting provides a complete and integrated solution that allows
users to prepare and maintain a comprehensive budget that includes position
budgeting for personnel services.

Users can extract information from external systems such as Oracle Human Resource
Management Systems, Oracle Labor Distribution, and Oracle General Ledger. Users can
also export information from Oracle Public Sector Budgeting to General Ledger.
Positons are available from HRMS.

Oracle Public Sector Budgeting supports the online distribution, notification, review, and approval.

Oracle Public Sector Budgeting also supports versioning, maintaining a complete record of the budget at each
stage.

Oracle Public Sector Budgeting supports multiple methods for analyzing and
presenting budget information. With Oracle Discoverer, users can create multiple data
views and create graphs and charts for analysis and reporting.

Oracle Public Sector Budgeting supports position control, using the allowing users to
record information on position, cost, and distribution in position control.

Flexfield mapping allows users to change the accounting key flexfield or accounting
flexfield values extracted from General Ledger so that updated code combinations are
used when new worksheets are created in Oracle Public Sector Budgeting.

Oracle Public Sector Budgeting supports encumbrance balances from General Ledger.

Oracle Public Sector Budgeting supports more than one ledger currency at transactional level.

HRMS is mandatory for position control in Public Sector Budgeting.

For more information follow Oracle Public Sector Budgeting User Guide.

TCA Party

Can the TCA Party of an Existing Customer be Used as TCA Party for a Supplier?

No.

The ability to query an existing TCA party and create them as a supplier is not yet available.

If the TCA party is first a supplier, you can query the party and create a customer account for it.
If the TCA party is first a customer, then yes - two parties will be created if a supplier is then created.


For more information better to follow Oracle Metalink Note: 550539.1