Setup steps for Aliases in Oracle General Ledger R12 - Peruse Technologies 9542881790

An account alias is an easily recognized name or label representing a general ledger account number. You can view, report, and reserve against an account alias. During a transaction, you can use the account alias instead of an account number to refer to the account

It is Short name for Inter Account code combinations, Alias Max size is 30, 

After complete define aliases we should re-compile Chart of accounts

Nav: General ledger --> Setup --> Financials --> Flexfields --> Key --> Alias --> enter




Querry your structure : ( click on F11 and give structure name then click on Ctrl + F11 )

Enable,  Enable check box,  Enter Max alias size and Prompt name ( T-Alias:)

Give Alias name , Choose account code combination in template field and give alias description

we can give effective date to alias

save it and close

Then go to re - compile structure

Nav : General ledger --> setup --> financials --> flexfields --> key --> segment --> enter

click ctrl + f11 ( to query structure )

Select your structure

Unfreeze structure then again freeze and compile structure

then go to check is alias executing / not

General ledger --> jornals --> enter --> new journal



In lines click on list of values (LOV's)

Contact Us for Online and Class room training

PERUSE Technologies
1st floor, Gayathri nagar
Behind huda Maithrivanam
Ameerpet, Hyderabad-500016
Contact : +91-9542881790
E-mail : perusetechnologies@gamil.com
Web Address : http://perusetechnologies.webs.com/

Oracle SCM and Financials Online Training with Project

ORACLE – SCM

Contact: +91-9542881790, E-Mail: perusetechnologies@gmail.com

http://perusetechnologies.webs.com/

Purchase Modules

·   Introduction of Purchasing

·    Define all the relevant Setups for Purchasing

·    Define Suppliers and Supplier Sites

·         Approved Suppliers list

·         Options

Financial Options

Purchasing Options

Receiving Options

·         Buyers

·         Position Hierarchy

·         Approval Groups

·         Approval Assignment

·         Document Types

·         Lines Types

·         Freight Carriers

·    Requisitions and RFQ

·         Quotations and Quote Analysis

·    Purchase Order flow

·    Manual generated PO’s and through Auto Create.

·    Types of Purchase Orders

Standard Purchase Order

                  Planned Purchase Order

                  Blanket Purchase Order

                  Contract Purchase Order

·         Blanket and Schedule Releases

.         Receive Item against PO

·         Auto Sourcing Rule

·    Return transactions Against PO

·         Types of PO Controlling

·         Receipt Routing

          - Direct

         - Standard

        - Inspection

·         Receiving Controls

         - Substitute

         - Cascade

         - Express

         - Blind

         - Un Ordered

Inventory Module                                            

      ·    Introduction of Inventory                                              

      ·    Definition of Location                                                  

      ·    Definition of Calendar                                                  

      ·    Definition of Organization

·    Master Item Definition

·    Assign Item to Organization

·    Item templates

·    Item Attributes

      ·    Unit of Measures

·    Definition of Sub Inventories and Locators

·    On-hand Quantities

·    Miscellaneous Receipts and Issues

·    Sub Inventory transactions.

·    Move Order Transactions

·    Inter Org Transactions

·    Mini-Max Planning

      ·    Kanban Planning

      ·    Re Order Point Planning

·    Replenishment Planning

·    ABC analysis

·    Physical Counting

·    Cycle Counting

      ·    Controls

      Lot, Revision, Serial, Locator and Sub inventory

      ·     Flex fields

            Alias

            System Item

            Item Category

            Item catalog

           Locators

           Sales order

·         Inventory

          Transactions, planning’s, Controls and Accuracy

·         All other Relevant inventory setups

Order Management Module

·    Introduction of Order Management

·    Understanding OM Cycles

·    All relevant setups for Order Management

·         Payment Terms

·         Sales Persons

·         Collectors

·         Grants and Roles

·         Customer Profile Classes

·         Define Customers

·         Transaction Types

·         System Options

·         System Parameters

·         Shipping Parameters

·         Pick slip grouping rules

·         Release sequence rules

·        Define shipping methods

·         Price list

·         Document Sequences

·         Type of Sales Orders

·         Quotations

·         Sales order Approvals

·         RMA Cycle.

·    Drop Shipment

• Back To Back Order
• Internal Sales Order
• Blanket Sales Agreement
• Back Order
• Credit Check
• Cancel
• Holds

Bill of Materials Module

·    Introduction of Bill of Materials

·    Define Bill of Material Parameters

·    Define bills and bill levels

·    Comparing bills and Indented bills

·    Create common bills

·    Attach the documents of bills

·    Define resources

·    Define departments and standard operations codes

·    Define routings

·    All relevant setups for bill of materials

·    BOM Types.

Work in Process Module

·   Introduction of work in process

·    Introduction of type of Mfg. process

·    Define WIP parameters

·    Define WIP accounting class

·    Relevant WIP setups

·    Complete cyclic flow for Discrete Mfg. and transactions

·    Complete cyclic flow for Repetitive Mfg. and transactions

·    Query Job/Schedule details

Multi-Org Structure and MOAC

·         Location

·         Business Group

·         Legal Entity

·         Ledger

·         Operating Unit

·         Inventory Organization

·         Sub-Inventories

·         Locators

Human Resources

·         Organizations

·         Job

·         Positions

·         Position Hierarchy

·         Employees

System Administrator

·         Users

·         Responsibilities

·         Profile Options

PROCURE TO PAY (P2P) Cycle Flow

ORDER TO CASH  (O2C)  Cycle Flow

Real Time Scenarios

AIM – Tool

AIM Phases and Documents

Project Types

          Implementation

          Support

          Migration/Up gradation

          Customization

          Global Rollout

Project Models

Project Instances

Oracle Financials and SCM Online Training with Project

ORACLE FINANCIALS 

Contact: +91-9542881790, E-Mail: perusetechnologies@gmail.com

http://perusetechnologies.webs.com/

General Ledger                                                                                 

·         Flex                                                                         

    - Key Flex Fields                                                   

          -Descriptive Flex Field                                          

·         Currency

·         Calendar

·         Chart of Accounts

·         Primary Ledger

·         Secondary Ledger

·         Open/Close Periods

·         Single Journals

·         Batch Journals

·         Reverse Journal

·         Foreign Currency Journals

·         Suspense Journals

·         Cross-validation rules

·         Security Rules

·         Alias

·         Recurring Journal

·         Inter and Intra company Journals

·         Budget

    -Plan Budget

          -Fund Budget

·         Translation

·         Revaluation

·         Consolidation

·         Reporting Currency

·         Finance Statement Generator (FSG)

·         Ledger Set

·         Trail Balance – Details

·         Trail Balance – Translation

·         Summary Templates

·         Document Sequences

·         Journal Approval

·         Auto post and Reverse

Account Payables

·         Options

            Financial Options

Payable Options

Payables system setups

·         Accounting Periods

·         Payment Terms

·         Distribution Set

·         Tolerances

·         Special Calendars

·         Payment Format

·         Aging Reports

·         Banks

Banks

Branches

Bank Accounts

·         Supplier

            Supplier

            Supplier sites

            Supplies Merge

·         Invoices

Standard Invoice

Credit Memo

Debit Memo

Prepayment Invoice

Expense Reports

Interest Invoice

Recurring Invoices

Withholding Tax Invoice

Po Match

Quick Match

·         Payments

           

Account Receivables

·         Key Flex fields

·         System Options

·         Payment Terms

·         Statement Cycle

·         Dunning Letter

·         Application Rule Set

·         Auto Cash Rule Set

·         Collector

·         Remit-to-Address

·         Customer

·         Customer Profile Class

·         Memo Lines

·         Transaction Types

·         Transaction Sources

·         Auto Accounting

·         Transactions

    -Invoice

    -Debit Memo

   -Credit Memo

   -Charge Back

   -Deposit

   -Guarantee

·         Transaction Rules

    -Invoice

    -Accounting         

·         Receivable Activity

·         Recurring Invoices

·         Receipt Class

·         Receipt Source

·         Receipts

·         Miscellaneous Receipts

·         Receipt Reversal

·         Remittance

·         Aging Reports

·         Revenue Recognition

·         Balance forward billing Invoice

·         AP/AR Netting

  

Cash Management

·         System Parameters

·         Bank Reconciliation statements

·         Bank Codes

·         Clear Invoice and Transaction

·         Reconciliation

·         Un-reconciliation

·         Forecasting

  

Fixed Assets

·         Flexi Fields

·         Values

·         System Controls

·         Fiscal Year

·         Depreciation Calendar

·         Prorate Convention Calendar

·         Depreciation Methods

·         Book Controls

·         Asset Categories

·         Asset Additions

·         Mass Addition

·         Depreciation                                   

·         Transfer

·         Mass Transfer

·         Changes

·         Revaluation

·         Reclassification

·         Retirement

·         Reinstatement

·         Journal Entries

E-BUSINESS TAX

·         Tax Regime

·         Taxes

·         Tax status

·         Tax jurisdiction

·         Tax rates

Multi-Org Structure and MOAC

·         Location

·         Business Group

·         Legal Entity

·         Ledger

·         Operating Unit

·         Inventory Organization

·         Sub-Inventory

·         Locators

System Administrator

·         Users

·         Responsibilities

·         Profile Options

PROCURE TO PAY (P2P) Cycle Flow

ORDER TO CASH (O2C) Cycle Flow

Real Time Scenarios

AIM – Tool

AIM Phases and Documents

Project Types

            Implementation

            Support

            Migration/Up gradation

            Customization

            Global Rollout

Project Models

Project Instances

Oracle SCM and Oracle Financials Online Training

PERUSE Technologies is a comprehensive repository for online courses offering high quality 

state-of-the-art IT and Business related e-learning trainings and courses. With offering from Oracle E-Business Suite (EBS), Financials and SCM (Supply chain Management).

Contact Us

PERUSE Technologies

1st floor, Gayathri nagar
Behind huda Maithrivanam
Ameerpet, Hyderabad-500016
Contact : +91-9542881790
E-mail : perusetechnologies@gamil.com
Web Address : http://perusetechnologies.webs.com/