Function to return COA Account Combination.

Function to return concatenated account from id.

[code]</pre>
CREATE OR REPLACE FUNCTION APPS.GET_CONCAT_ACC (ACC_ID VARCHAR2)
RETURN VARCHAR2 IS
<p style="padding-left:30px;">AC VARCHAR2(100);</p>
BEGIN
/*** Returns Concatenated Accounts ***/

<p style="padding-left:30px;">SELECT ACCOUNT_COMB
INTO AC
FROM ABH_GL_ACC_CONCAT_SEGMENTS
WHERE CODE_COMBINATION_ID = ACC_ID;
RETURN NVL(AC, 'ERROR');</p>
END;
/
<pre>[/code]

This function is based on the View for Chart of Accounts KFF.

Shameem Bauccha

19 October 2009

View for Chart of Accounts KFF

The script below allows you creates a view for your chart of accounts.
Modify to suit your requirements. Note that the value set name of each segment is passed as parameter.

[code]
CREATE OR REPLACE VIEW ABH_GL_ACC_CONCAT_SEGMENTS
AS
SELECT cc.code_combination_id,
cc.chart_of_accounts_id,
cc.detail_posting_allowed_flag post,
cc.detail_budgeting_allowed_flag budget,
cc.account_type,
cc.show_account_type,
cc.enabled_flag,
cc.summary_flag,
--segment: segments used in COA definition
cc.segment1,
cc.segment2,
cc.segment3,
cc.segment4,
cc.segment5,
cc.segment6,
concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(segment1, '-'), segment2),'-'), segment3), '-'), segment4), '-'), segment5), '-'), segment6) account_comb,
get_flex_vs_desc('ABH Company', cc.segment1, '') Company,
get_flex_vs_desc('ABH Cost Center', cc.segment2, '') "Cost Center",
get_flex_vs_desc('ABH Account', cc.segment3, '') "Account",
get_flex_vs_desc('ABH Sub Account', cc.segment4, cc.segment3) "Sub Account",
get_flex_vs_desc('ABH Location', cc.segment5, '') "Location",
get_flex_vs_desc('ABH Entity-Services', cc.segment6, '') "Entity-Services"
FROM GL_CODE_COMBINATIONS_V cc
[/code]

Refer to document 'Fetching Key Flexfield Value Description' for get_flex_vs_desc.
Shameem Bauccha

19 October 2009

E-Business Tax Setup: Create First PartyLegal Entity and Establishment

Platform: R12

Create First Party: Legal Entity and Establishments

This is a required step if you want to use E-Business Tax. If you are using General Ledger, then you will have already defined the Legal Entity and Establishment.

Refer to the following documents:

-          Accounting Setup Manager

-          Legal Entity and Establishment

You need to define the following:

-          Legal Entity

-          Legal Establishments for the Legal Entity

Note that Legal Establishments are setup under a parent Legal Entity.



Click on the ‘Go to Task’ icon. Alternatively you may also navigate as follows:

Legal Entity Manager --> Legal Entity Configurator



[caption id="" align="alignnone" width="852" caption="Legal Entity Configurator Homepage"][/caption]







First Party: Legal Establishment

Setup a Legal Establishment for each office, warehouse, centre etc. which requires registration with a tax authority for one or more taxes. You can setup Party Tax Profiles for each Legal Establishment.

[caption id="" align="alignnone" width="855" caption="First Party Legal Entity and Establishment"][/caption]

Set the following for each Legal Establishment:

-          Party Tax Profiles

-          Tax Registrations

[caption id="" align="alignnone" width="854" caption="Establishment"][/caption]

Also setup your Operating Unit.

See Document ‘Operating Unit’ (Document to follow).



Shameem Bauccha

1 July 2009

Define System Profile Values for General Ledger

Set the following profile options at site level unless otherwise specified / required:

1. HR: Business Group


2. HR: Security Profile


3. HR: User Type (responsibility level)


4. GL: Ledger Name


5. GL: Data Access Set


6. MO: Operating Unit


7. MO: Security Profile

Refer to document 'Define System Profile Values' for detailed explanation on how to proceed.

GL: Data Access Set required only if you have defined Data Access Set

(Document to follow on 'Defining Data Access Set').

Shameem Bauccha

23 June 2009

Accounting Setup Manager

Accounting Setup Steps

In R12, Accounting setup steps are divided into 3 parts as follow:

1. Create Accounting Structure


2. Define Accounting Options


3. Complete Accounting Setup

Detailed documentation to be uploaded tomorrow

Apologies

Shameem Bauccha

23 June 2009

Enable Currencies

General Ledger Super User --> Setup --> Financials --> Currencies --> Define



Query for the appropriate currency. Scroll to the right and enable the currency by checking the box if it is not checked.



If your currency is not available, add the currency in the list and enable it.

Enable all currencies required and disable whatever is not required.

Define Transaction Calendar

Define Transaction Calendar

[caption id="" align="alignnone" width="562" caption="Transaction Calendar"][/caption]

Secure Transaction Calendar

(Document to follow during course of the week)

Apologies

Shameem Bauccha

23 June 2009

Define Accounting Calendar

Calendar Types

General Ledger Super User --> Setup --> Financials --> Calendars --> Types



You can use any of the seeded Calendar Types or create your own custom Calendar type.

For Year Type: Calendar or Fiscal

Accounting Calendar

General Ledger Super User --> Setup --> Financials --> Calendars --> Accounting

Prerequisite

Carefully consider the type of calendar you need for your organization, since it can be difficult to change your calendar (e.g., from a fiscal year to a calendar year) once you've used it to enter accounting data. Changing your calendar may require assistance from an Oracle consultant.

Define your accounting period types





Be careful not to miss out on any day when defining your calendar periods.

In the example above you can see that we have defined an additional adjusting period that overlaps with our last period of the year and allows us to make adjustments after we have closed the last period. We can have more than one adjusting period in a year with any from date and to date.

You can enable Security by checking the box (optional). You can secure your calendar definition using definition access sets. Definition access sets are an optional security feature that allows you to control use, view, and modify access to your General Ledger definitions.

For accounting calendars, only View and Modify access are applicable.

When you exit the Calendar Form, the Calendar Validation Report is automatically launched. You can view the request. You can also launch the request manually.

Shameem Bauccha

23 June 2009

Accounting Key Flexfield - Create Chart of Accounts

(doc will be ready tomorrow)

apologies

Refer to the document 'Define Key Flexfield Structure' for further details.

Shameem Bauccha

23 June 2009

Oracle Apps R12 - GL - Creating a territory

Legal Entity Administrator --> Lookups --> Define Lookups

[caption id="attachment_7" align="alignnone" width="756" caption="Legal Entity Configurator Lookup"][/caption]

You can define your own values for Legal Entity, Establishment and Legal Entity Person Registration.

Query ‘LE Registration Code’, ‘Establishment Registration Code’ or ‘Legal Entity Person Registration Code’ in the description field and update accordingly.

Clear the cache to ensure the values appear in your lookups.

Legal Entity Administrator --> Jurisdictions

[caption id="attachment_8" align="aligncenter" width="300" caption="Legal Entity Configurator"][/caption]

Select the Legislative Category

[caption id="attachment_17" align="aligncenter" width="120" caption="Legislative Category"][/caption]

Click on ‘Go’.

[caption id="attachment_10" align="aligncenter" width="300" caption="Jurisdictions"][/caption]

Add Legal Functions if required.

[caption id="attachment_14" align="aligncenter" width="300" caption="Add Legal Functions"][/caption]

You can add any combination of the following functions:

[caption id="attachment_12" align="aligncenter" width="207" caption="Legal Functions"][/caption]

Click on ‘Apply’.

You should get a confirmation message.

[caption id="attachment_15" align="aligncenter" width="442" caption="Confirmation"][/caption]

Your jurisdiction must now be available.

The territory will now be available when you create your Legal Entity.

Shameem Bauccha

18 June 2009

Click here to download the file.