Oracle R12

http://apps.ora.com:8000

Oracle corporation is an American multinational computer technology corporation that special in developing . Oracle Applications are in Finance head there are 6 applications . 1. General Ledger 2. Accounts Payable 3. Accounts Recievable 4. Fixed Assets . 5. Cash Management

6. Enterprise - Business Tax.

In supply chain management head. 1. Inventory 2. Purchasing (PO) 3. Operating Management. 4. System Administration. General ledger (GL) : It is an application of financial general ledger it is central representing . When we are defining major control features generate reports for organization .It is a Reporting entity in which recording day to day business transactions and also it will determine 4 cs are 1. Currency 2. Calendar 3. Chart of accounts 4. Accounting convention method. Accounts Payable (AP) : It is used to record the any type of payment s in an organization. Accounts Recievable (AR) : It is used to record the any amount receivable of an organization. Fixed Assets (FA) : It is used to maintain the fixed assets related data. Cash Management (CM) :It is used to maintain the cash related activities . Enterprise Business Tax (EBT) : It is used to maintain the tax related activities . Topics in ledger : Log in to Oracle Create New User

 Currency Calendar Chart of Account Value set Ledger Responsibility Open the GL periods Journal Source Journal Categories Entering & Posting journal

Journal Reverse (switch dr & cr ,Change sign)

Journal Batch Auto copy batch Suspense Journal Recurring Journal Auto Post Auto Reverse Journal Approval Allocation

Sequential Numbering
Inter company Budgets Translation Revaluation Reporting Currency Rollup Groups & Summary template Consolidation Secondary Ledger

 Definition Access Set Ledger set Cross Validation Rules Aliases Data Access Set

Descriptive Flex Field

Financial Statement Generator

Create New User N : SA -> security -> user -> Define.

Define Currency N : GLSU -> setup -> currencies -> define .

Define Calendar It is used to identify the dates an accounting transactions . There are 2 types of calendars 1. Accounting calendar 2. Transaction calendar

Accounting Calendar

It is used to record the accounting information for organization .

There are 2 types years 1. Calendar year 2. Fiscal Year . Step 1 Define Period type : N: GLSU -> setup -> financials -> calendars -> types. Step 2 Define accounting calendar : N : GLSU -> setup -> financial -> calendars -> Accounting . Transaction calendar It is used in the average balances processing feature it will determine which day working & which day is holiday in an organization . Step 1 Define transaction calendar : N : GLSU -> setup -> financials -> calendars -> Transactions. Flex fields : It is used field which is made up by segments. There are 2 types of flex fields 1. Key flex field 2. Descriptive flex field

Key flex field : It is a mandiatory flexfield which is used to capture the mandiatory or key information of an organization Descriptive flex field :It is a optional flexfield which is used to capture the additional information of the organization . Char of accounts will be defined using key flexfield . There are total 38 key flex field in oracle application , we have a 3 key flex fields in a general ledger . 1. Accounting flex field . 2. Reporting attributes accounting flex field . 3. GL ledger flex field . Chart of account : Chart of account means accounting structure of the organization . N : GLSU -> setup -> Financial -> Flex fields -> Key -> segments . Segment qualifiers : There are 2 Segment qualifiers 1. Allow budgeting 2. Allow posting . Value set : It is determine the features of segment values . Step 1 : Define value set N : GLSU -> setup -> Financials -> flexfield -> validation -> sets . Step 2 : Define company segment value set . Step 3 : Define department segment value set . Step 4 : Define account segment value set . Step 5 : Define future segment value set . Step 6 : Assigned value set to the segments . Step 7 : Assign qualifiers to the segments . Values : It is used to define the segment values . N : GLSU -> setup -> financials -> flexfields -> key -> values . Step 1 : Define company segment values find key field segment . Step 2 : Define department segment values . Step 3 : Define Account segment values Step 4 : Define future segment values . There are total 7 types of accounts 1. Expenses 2. Revenue 3. Assets

4. Liabilities 5. Ownership /stock holders equity (capital ,shares, debentures) 6. Budget Dr. 7. Budget Cr. Accounting Convention Method : It will determine what method you are using in the organization record the transaction . There are 2 types of methods 1. Accrual method

2. Cash basis method . Accrual method : If we use this method journal entry will be created by system each & every transaction irrespective of cash . Cash basis method : In this method journal entry created by system when cash taking place transaction . Ledger : Its a reporting entity in which recording day to day business transaction & also it will determine 4 cs are 1. Currency 2. Calendar 3. Chart of accounts 4. Accounting convention method. Step 1 : Define Retained earning account Step 2 : Define ledger N : GLSU -> setup -> financials -> Accounting setup manager -> Accounting setup . Responsibility: It is nothing but a group of tasks which are performed by the specific person . Step 1 : Define GL Responsibility N : System administrator -> security -> Responsibility -> Define . Step 2 : Assign ledger to the responsibility N : system administrator -> Profile -> system . Step 3 : Assign Responsibility to the user N : System administrator -> security -> user -> define . General ledger periods : there are 5 types of period status 1. Never opened 2. Open

3. Closed 4. Future 5. Permanent closed . Step1 : open the GL periods N : General ledger -> setup -> open/closed . Step2 : check the programme status Step3 : check the period status Journal source : It is a one of the journal component it will determine the source of the journal . Step1 : Define journal sources N: GL -> setup -> journal -> sources Step2 : Define journal category N: GL -> setup -> journal -> categories . Journals : It is used record the day to day business transaction it contains Debit & Credit lines always debit must be equal to the credit . Manual journals : Entering the journals in the oracle manual application is called a manual . Manual journal created in 2 ways 1. Individual or single journal 2. Journal batch . Step1 : Create journal N : journal -> enter -> new journal . Step2 : Post the journal Step3 : Enquiry account balances . Step4 : Query the journal to check the posting status . Balance types : There are 3 types of balance types 1. Actual 2. Budget 3. Encumbrance Actual : It is no planning of paying cash for any organization . Budget : It is having some planning based on this budget to take a decision & having limits . Encumbrance : It is reverse amount which is taken from the budget planning amount for specific purpose . Journal Reverse : It is a feature is used to reverse the journals which are enterd by mistake or as per the business requirement purpose . There are are 2 types of Reverse method . 1. Switch Debit & credit Method . 2. Change sign Method .

Switch Debit & credit Method : In case of switch Dr & Cr method system will create the new journal entity with exact opposite lines. Step1 : Query the journal which you want to reverse . Step2 : Query the reversal journal & post it . Step3 : check the accounts balances Change sign : In case of change sign method system will create new reversal journal entry with negative amount. Step1 : set profiles option journals Step2 : create journal & post it . Step3 : Query the journal which you want to reverse using change sign method. Step4 : Query the reversal journal & post it

Journal Batch : It is used group the journal based on certain parameters . Step1 : Define journal batch Step2 : Query the journal batch to check the status. Auto copy batch : It is used to create new batch by copying existing journal batch . Step1 : Query the journal batch which we want to copy . Step2 : Query the new batch & post it Change period : It is used to change the journal period before the posting . Step1 : Create journal & change the period . Suspense journal : It is used to post the unbalanced the journals Step1 :Define suspense account. Step2 : Enable suspense account feature at ledger level . Step3 : Define suspense account rules Step4 : Enter unbalance journal & Post it . Step5 : Query the journal to check the suspense account at journal. Recurring journal : Journals which are repeating each and every accounting period is called a recurring journal . There are 3 types of recurring journal. 1. Standard Recurring journal 2. Skeleton Recurring journal

3. Formula Recurring journal Standard Recurring journal : Journal which are effecting same account & same amount each & every accounting period is called a standard recurring journal Step1: Create standard recurring journal batch. Step2 : Query the recurring journal window & post it Skeleton recurring journal : If we create recurring journal with the partial information i.e., skeleton recurring journal Step1 : Create skeleton recurring journal Step2 : Query the skeleton journal & post it Formula recurring journal : In case of formula recurring journal , journal line amount will be calculated by system using formulas . Step 1 : Define formula recurring journal Step2 : Query the formula recurring journal & post it .

Auto post : Auto post feature is used to post the journals automatically by system running programme. Step1: Define the auto post criteria set Step2 : Create journal with auto post criteria set Step3 : Query the journal to check the posting status Auto reverse : It is used to reverse the journal automatically the system using programme . Step1: Define auto reversal criteria set Step2 : Assign auto reversal criteria set to the ledger. Step3 : Create journal & posting with the same category . Step4 : Run programme automatic reversal . Step5 : Query the new reversal journal & posted . Journal Approval : It is used to define the authorization limited to approach for the sources . Step1 : Enable journal approval at ledger Step2 :Enable journal approval & sources Step3 : Define Approval limites for employees Step4 : Define new user & assign employee to user Step5 : Create journal approval & posting

Allocation : It is used to distribute the amount to the various expensive heads using simple formula. Like formula is cost pool amount * usage factor / Total usage factor = target amount .

Step1: Define cost pool a/c & usage factor a/c . Step2 : Define parent department . Step3 : Enter cost pool journal & post it Step4 : Create & post stat journal . Step5 : Define allocation formula. Step6 : Query the mass allocation & post it. Sequential numbering : It is used to assign unique numbers to the various concepts . The concepts are journal ,Accounts payable payments , Accounts payable Invoices , Accounts receivable Invoices , Accounts Recievable Reciepts etc., Step1 : Assign sequential numbering profile option at responsibility level. Step2 : Define sequential numbering . Step3 : Assign sequential numbering to the category. Step4 : Create journal & Post it.

Inter company : A transaction which is taking place between the two companies with in the group is called a inter company transaction . Intra company : A transaction which is taking place between the 2 companies with in the group & with in the legal entity is called a intra company. Step1 : Define inter company payable & inter receivable accounts. Step2 : Assign inter company Qualifiers to the company segment Step3 : enable intra company feature at ledger level Step4 : Define legal entity . Step5 : Assign legal entity to the ledger . Step6 : Complete operating units , inter company accounts & intra company rules . Step7 : Create intra company journal & post it . Step8 : Query the inter company journal to check the journal Budgets : It is used for better planning & controlling purpose . Budget can be defined up to 60 periods . There are 2 types of budget 1. Planning budget

2. Funding budget Planning budget : In case of planning budget just we are planning but there will not be any controlling & budget journals . Funding budget : In this budget we can plan either revenue or expenses and also controlling & budget journals also budget . Step1 : Define reserve for encumbrance A/c & budget expenses A/c . Step2 : Enable budgetary control at ledger level . Step3 : Define budget Step4 : Query the budget to check the latest open year status . Step5 : Define budget organization . Step6 : Define or Create budget journal . Step7 : Query the budget journal & post it Step8 : Enter journal with the budget Account . Step9 : Check the funds availability . Translation : It is used to translate the balances from functional currency to foreign currency . There are 3 types of rates which are used in the translation 1. Period average rate 2. Period end rate 3. Historical rates. Step1: Define commulative translation adjustment a/c. Step2 : Define rate types . Step2.1: Define Exchange rate Step2.2 : Assign commulative CTA a/c & Exchange rate type to ledger. Step2.3 : Run translation Step2.4 : Run programme trial balance - Translation Revaluation : It is used to identify unrealized gain/loss amount . Which is occurring due to the foreign currency exchange rates fluctuation . Step1 : Define unrealized gain /loss account . Step2 : Define exchange rate type Step3 : Define exchange rate Step4 : Create & post foreign currency journal

Step5 : Modify the exchange rate in next day Step6 : Run revaluation Step7: Query the revaluation journal & post it Reporting Currency : It is used translate the balances from functional currency at transaction level . Step1 : Define rounding differences tracking a/c . Step2 : Define exchange rate type Step3 : Define exchange rates Step4: Assign rounding differences tracking a/c to the ledger Step5 : Complete the reporting currencies setup step Step6 : Define reporting ledger GL Responsibility Step7 : Assign reporting ledger to GL responsibility Step8 : Assign GL Responsibility to the user . Step9 : Open in the periods in Reporting ledger. Step10 : Create & post journal the primary ledger. Step11 : Query the journal & Reporting the ledger to check the status.

Roll up groups & summary template : It is used to group the parent values . Step1 : Disable Rollup groups at chart of account level. Step2 : Define rollup groups Step3 : Assign Rollup groups to the parent values. Step4 : Define summary template. Step5 : Inquiry the account balances using summary template . Consolidation : It is used to consolidation the multiple subsidiary ledger into single parent ledger. Step1: Define Require Subsidiary & parent ledgers . (i) Define parent ledger . (ii) Define subsidiary ledger (iii) Define subsidiary 2 ledger Step2 : Define parent & subsidiary ledgers GL Responsibility . (i) Define parent ledger GL Responsibility

(ii) Define sub1 GL Responsibility (iii) Define sub2 GL Responsibility Step3 : Assign ledgers to the GL responsibility (i) Assign parent ledger to the GL Responsibility (ii) Assign sub1 ledger to the GL Responsibility (iii) Assign sub2 ledger to the GL responsibility Step4 : Assign parent & subsidiary GL responsibility to the user Step5 : Open periods in parent & subsidiary ledger. (i) Parent ledgers (ii) Open periods in Sub1 ledgers.

(iii) Open periods in Sub2 ledgers.

Step6 : Define Exchange rate type. Step7 : Define Exchange rate type the sub1 & sub2 to parent type (i) Define Exchange rate between USD & REL currency (ii) Define Exchange rate between GBP & REL currency Step8 : Complete transaction option in parent & subsidiary ledger

(i) Parent ledger

(ii) Sub1 ledger CTA a/c (iii) Sub2 ledger CTA a/c Step9: Define consolidation mapping (i) Sub1 with parent mapping (ii) Sub2 with parent mapping Step10 : Define consolidation set Step11 : Create & post journal in each subsidiary 1 & 2 ledgers Step12 : Run Translation in each subsidiary 1 & 2 ledgers Step13 : Run consolidation transfer Step14 : Query the consolidation journal & parent ledger & post it. Secondary ledger : It will represent the primary ledger accounting information when following Things are differ compare to primary ledger Step1: Define exchange rate type

Step2: Define exchange rate Step3 : Define secondary ledger Step4 : Define secondary ledger GL responsibility Step5 : Assign secondary ledger to the GL Responsibilty Step6 : Assign GL responsibility to the user . Step7 : Open the periods in the secondary ledger Step8 : enter journal & post in the primary ledger. Step9 : Query the journal in secondary ledger & post it Definition Access set : It is a new feature option in R12 . It is used to provide use , modify or view access to the various definition . It will work at responsibility level . Step1 : Define definition access set Step2 : Assign Definition access set responsibility Step3 : Enable Security for calendar Step4 : Query the calendar to check the Definition access set Result Step5 : Grant modify Access to the calendar (i) Query Definition Access set to provide the modify access to the calendar (ii) Enable Security at Segment level (iii) Define security rules (iv) Assign Security rules at responsibility (v) Enter journal to check the security rules ledger Cross validation rules (CVR) : It is used to restrict the user from entering code combination . It will work at chart of account level . Step1: Enable CVR at chart of account level Step2 : Define CVR Step3 : Enter journal to check the CVR Aliases : It is used to define shirt name for account code combination . Step1 :Define Aliases Step2 : Recompile the chart of account Step3 : Enter journal to check the alias results Data Access sets : It is used to provide read or write Access to full ledger or balancing segment value or management segment value

Step1 : Enable / assign management qualifier Step2 : Define data access set Step3 : Assign data access to the responsibility. Step4 : Assign GL Responsibility to the user Step5 : Enter journal to check the data access set result Descriptive Flex Field (DFF) : It is used optional flex field to capture the additional information of the organization. Step1 : Enable DFF journal entry screen Step2 : Enter journal with DFF information Step3 : Define code combination in the combination window Step4 : Enter journal with the new code combination Financial Statement Generator (FSG) : It is a tool which is used to customize the financial report as per the company reporting requirement. FSG having 5 components 1. Row set 2. Column set 3. Content set 4. Row order set 5. Display set Row set & column set are mandiatory sets & remaining 3 are optinal Row set : It is determine format & content of rows . It includes accounting information etc. Column set : It is determine format & content of columns . Content set : It is used to generate the reports for multiple departments separately at a time Row order set : It is determine how the accounting information will display in the report. Display set : It is determine which account should be display in report & which account should not display in report. Step1 : Define row set Step2 : Define column set Step3 : Define report Step4 : Define Report set Step5 : Run FSG Report

Multi Organisation Structure : It is used to capture the multiple company information using in single database . Org structure Business Group (HR) -> Ledger (GL,FA)-> Legal Entity (EBT,CM) -> Operating unit (AP, AR, PO,OM) -> Inventory organization (I)-> Sub inventory organization (SI) Business Group : Its a highest level data in the Multi org structure it secures the HR data. Operating Unit : It is nothing but a major business division one legal entity contains multiple operating unit but one operating unit must be associate one legal entity. Inventory organization : It is nothing but a warehouse or manufacturing plant where we are storing the goods . One operating unit contains multiple Inventory organization but one inventory organization must be associate one operating unit . Sub inventory (SI) : It is a part in the inventory organization . One inventory organization contains multiple SI but one SI must be associate with one inventory organization. Step1 : Define currency Step2 : Define location Step3: Define Business Group Step4: Define Ledger Step5: Define HR Responsibility Step6 : Assign profile options to the HR Responsibility Step7: Assign HR Responsibility to the user Step8: Define GL Responsibility Step9 : Assign profile option to GL Responsibility Step10: Assign GL responsibility to the user Step11: open the periods in GL responsibility Step12: Define legal entity Step13: Assign legal entity to the ledger Step14: Define operating unit Step15: Run replicate seed data from for each operating unit Step16: Define inventory organization responsibility Step17: Assign profile option to inventory responsibility Step18: Assign inventory responsibility to the user Step19: Define work day calendar Step20: Define Inventory organization

Step21: Define sub inventory Multiple organisation Access control (MOAC): It is used to access multiple operating unit information from single responsibility . To achieve this we will use multiple organization security profile option. Step1: Define MOAC security profile Step2: Define all required responsibilities for PO, AP, OM, AR, FA, CM, EBT Step3: Assign profile option to the responsibility for PO , AP, OM, AR, FA, CM, EBT Step4: Assign Responsibilities to the user for PO , AP, OM, AR, FA, CM, EBT.

Purchasing (PO)
It is used to capture the purchasing activities of organization .

Requisitions : There are 2 types of Requisitions 1. Internal Requisition 2. Purchase Requisition Request For Quotations RFQ : There are 3 types of RFQ 1. Catalogue RFQ 2. Standard RFQ 3. Bid RFQ.

Quotations : There are 3 types of Quotations 1. Catalogue RFQ

2. Standard RFQ 3. Bid RFQ. Purchase orders : There are 4 types of purchase orders 1. Standard PO 2. Planned PO 3. Blanket Purchase Agreement

4. Contract Purchase Agreement

Delivery : There are 3 types of delivers 1. Direct delivery 2. Standard delivery 3. Inspection delivery There are 2 cycle financial 1. Procure to Pay cycle (P2P) 2. Order to Cash (O2C) PO Integration

PO setups : There are 5 PO setups 1.options 2. Employee 3.Item 4.Supplier 5.PO Setups

1. Options : It is nothing but a controlling Features at operating unit level . There are 3
types of options (i). Financial options (ii). Purchasing options (iii). Receiving options

Financial options : It will be shared by purchasing ,Account payable , Fixed assets & Internet exposure. Step1: Define financial options Free on Board : It will determine where ownership of goods change from supplier to organization. Purchasing options : It will be shared by the purchasing application Step2: Purchasing options Receipt close point : It will determine which place at which stay we are sending , confirmation to the supplier we have receive goods from carrier . Enforce lot quantity : It will determine whether we can enter lot quantity at the time of purchase order creation . Dispositon : It will determine whether we can copy /not item related information to PO from Requisition Allow item description : It will determine whether we can modify or not item description at the time of document creation . Match approval level : using of this option to checking of goods quality for each and every stages like 2 way, 3 way, 4 ways . Step3 : Receiving options ASN control action ( advance shipping notice ): It is used for based on Assurance or note or promissory note to receiving the goods. RMS Receipt routing (Return material acceptance ) : this method will determine in which method goods will be received when customers returns goods to the organizations. Allow cascade transaction : It will determine whether we can receiving goods or not in the multiple inventory organization . 2. Employee Step1 : Define jobs Step2 : Define employees Step3 : Assign jobs to employees Step4: Assign manager to the clerk Step5: Define user & assign to employees 3. Item It is nothing but a product but a product . It will be defined the inventory . there are 7 key flex field in the inventory 1. Item categories 2. Account Aliases

3. Item Catalogs 4. Sales orders 5. System items 6. Stock locators 7. Oracle service item flex field Item categories : It is used to define the items Step1 : Define item category structure Step2 : Item categories structure values (i) Define family segment value (ii) Define class segment value Category codes : It is used to group the items Step1: Define category codes Step2: Define category sets Step3: Define item 4. Supplier Either organization or person who is selling goods or services to the organization is called a supplier There are 3 level of information in the supplier record . 1. Header 2. Address 3. Site Step1 : Define supplier Approval Groups : It is used to define the approval authorization limits. Step1: Define Approval groups for employees Approval group Assignments : It is used to assign the approval groups the jobs. Step1: Assign Approval groups to the PO clerk job . Step2: Assign Approval groups to the PO manager job Document types : It is used to determine the features of purchasing document . Buyer : A person who is buying goods and services behalf of organization is called a buyer. Step : Define buyers

Requisitions : Requisition created by employees when there is a requirement . there are 2 types 1. Internal Requisition 2. Purchase Requisition Requisition contains 3 levels of information 1. Header 2. Lines 3. Distributions (Accounting information) Internal Requisition : It is used to move goods one inventory organization to other inventory organization. Purchase Requisition : It will be created by employees & Send to the purchasing department when there is Requirement. Step1 : Create Purchase Requisition Step2: Check the Requisition status Request for Quotations : RFQ will be created by buyers & senders to the suppliers . There are 3 types 1. Catolague 2. Standard 3. BID RFQs can be created by 2 ways Manual Automatic

Manual Creation : Entering RFQs manually in oracle purchasing is called manual creation . Catalogue RFQ : This will be used for regular items . It contains 3 levels of information Header Lines Price breaks.

Step : Create Catalogue RFQ Standard RFQ : It is used for Occasional items . It contains 3 levels of information Header Lines

Price breaks

Step : Create Standard RFQ & Print the RFQ BID RFQ : It is used for high volume of items which are require special shipment . It contains 3 levels Header Lines Shipments

Step1: Create BID RFQ Step 2: Auto create RFQ Quotations : Quotations will be Received by suppliers & entered in oracle purchase. There are 3 types 1. Catalogue Quotations 2. Standard Quotations 3. BID Quotations Quotations can be create in 2 ways Manual Creation Automatic

Step : Create Manual Catalogue Quotation Step: Create Standard Quotation BID Quotation: Create BID Quotation and Auto create Quotation Quote Analysis : It is Used to Analyze the Quotations and select the best one. Purchase Orders : Its a legal document which will be created by organization and send to the suppliers to buy goods & services. It contains 4 levels of informations . Header Lines Shipment Distribution

There are 4 types of purchase orders 1. Standard 2. Planned 3. Blanket purchase agreement

4. Contract purchase agreement Purchase orders can be created in 2 ways Manual creation Automatic

Standard purchase order : Its a one time purchase order it will be created by organization & send to the supplier to buy goods & services . When we know the terms & conditions , Goods & services , Price , Quantity , Distribution and Delivery schedule. Step1 : Create standard purchase order Step 2: Check the purchase order status

Difference between 11i and R12

Particulars
Definition Access set

Oracle 11i
In 11i not having this feature for accessing of sets

Oracle R12
In R12 having this feature. It is used to provide use,modify and view Access to the various definitions. It will work at Responsibility level . In R12 having MOAC Feature with the help of this feature to access multiple operating unit information from single responsibility. To achieve this we will use MO Security Profile option. In R12 call it as Ledger behalf of Set of books. In R12 having 4 Cs i.e., Accounting convention method

Multiple organization Access control (MOAC)

In 11i not having MOAC feature

Ledger Cs

In 11i call it as Set of books behalf of Ledger . In 11i having only 3 Cs