Oracle Apps FAQS

BASIC FLOW OF FINANCIAL

     In this we receive order from customer. WIP (work in process) if we are no able to meet sales order then requisition is raised. PO is approved. PO goes to supplier. Supplier sends his shipment. AT the time of creation of invoice PO matching takes place. If matching is approve then payment is made to supplier. Then all entries go to GL.

Entry from AR is also goes to GL.

Q1: Difference between customization, enhancement and implementation?

Ans: Customization: Customization is the developing of the forms, reports and SQL script from the begining or changing the existings.

          Enchancement :  Enhancement is  the modification of forms according to client                   

                                         And user requirement.

          Implementation: Implementation is the testing of  Applications.

Q2: What are the Types of Customizations.

Ans: There are two types of customizations.

          1). Customization by extensions

          2). Customizations by Modifications.

 Customization by extensions :  Customization by extension means developing  new:

 Component for existing Oracle applications and develop new application using the

 Development feature of AOL(Application object Library).

                                                      Customization by extensions means Copying an

Existing Oracle Application Component(Forms, Report, PL/SQL etc.) to a custom application directory and modifying the Copy.

Customizations by Modifications :  Modifying   existing oracle  application Component

                                                             to meet your specific Requirement.

Q3:  What are the most Common Types of Customization ?

Ans:      TYPE 1:      # Changing Forms :

1)      . Changing Forms

2)      . validation logic

3)      .  behavior

             TYPE2:      # Changing Report or Program

                                              1).Apperance

                                               2). Logic

             TYPE3:   # Database Customizations:

                                           1). Adding read only Schema

                                            2).Augment(add) logic with database Triggers.

            TYPE4:     #  Integrating third Party Software

(  NOTE :For more Information on customization  go 115devg.pdf  Chapter Twenty Seven)

Q4:  What is Legacy system. ?

Ans: System other than  Oracle is legacy System. Like Foxpro, spreadsheet.

Q5:  What is ERP.?

Ans: Resource Planning with in Enterprise. ERP is a term that cover whole Product Line.

         ERP means integration of different module. Any business will greatly benefits by

         Adapting this feature because u can customize it or integrate it with other Packages

         to satisfy unique requirements.

         BENEFITS OF ERP: 1). Flow of Information Effectively.

                                                2). Maintaining  Standardisations.

Q6:  What is Oracle Apps.

Ans:  Oracle-apps is an ERP Package. The Key Feature of all the oracle-Application

         module is Data Integration.

 Master data is Integrated: All the application share common files of customers, suppliers, employee, items and other entites that are used by multilpe applications.

Transaction data is Integrated: Oracle automatically bridge transactions from one system to another.

Financial data is integrated: Financial data is carried in a common format, and financial data is transmitted from one application to another.

Q7:  What is ad-hoc Report?

Ans: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query

Q8:  What is Localization?

Ans: Localization are designed to meet the specific needs of certain territories or countries. Most localization are necessary because the local laws or accountings practice differ from country to country.

Region of Localisation:  Three Region of Localization.

1). EMEA REGION: Europe, MiddleEast, Asia pacific and Africa.

2). America REGION: Canada plus Latin America.

3). Global REGION: localization that apply territories through the world.  For example

                                       Localization used in both Europe and Latin America are classified

                                        In the Global Region.

Q9: Library used in Localization?

Ans: #Globe: Globe library allows Oracle Application developer to incorporate global

                       Or regional feature into oracle application forms without modification of

                        The base Oracle Application forms.

        # JA:        JA library contains codes specific to Asia\Pacific Region. And is called                

                         Globe Library.

         # JE:      JA library contains codes specific to EMEA Region. And is called              

                             By Globe Library.

          # JL:         The JL Library contains code specific to Latin America Region.

                             And is called by Globe Library.

Q10:  How forms are attached.

Ans: STEP- ONE: First put the form in corresponding module like AP, AR, GL

                                  In appropriate server directory.

        STEP-TWO:  Second step register form with AOL.

         STEP-THREE: Attach form with Function.

        STEP-FOUR:     Attach function with menu.

        STEP-FIVE:     Attach menu with responsibility.

       STEP-SIX:          Attach responsibility to user.

Q11: How Report is attached.

Ans11: STEP- ONE: Register the application.

        STEP-TWO:   Put Report in appropriate server directory.

        STEP-THREE:         Define Executables. (NavigatoràConcurrentàProgram

                                      àExecutables)

        STEP-FOUR:        Define Program (Concurrent à Program à Define)

        STEP_FIVE: Define Responsibility (Sysadmin responsibility).

                                (SecurityàResponsibilityà Define).

          STEP-SIX:        Define Request Group.(Navigatoràsecurity

                                 àResponsibilityàRequest)

         STEP-SEVEN:     Define Data Group. (Navigatorà oracleàDatagroup).

        STEP-EIGHT:   Run the request through SRS. A request Id is created

                                     Through which u can view the request.

Qns12:  What is workflow.

Ans:   To automate and continuously increase business process we use workflow.

          Workflow processes represent business process flows and information routings.

      Main Function:

                                 1). Routing Information’s (sending or receiving information).

                                   2). Defining & modifying Business Rule.

                                   3). Delivering electronic notification.(by emails).

Qns13: What is main workflow Component.

Ans13: 1). WorkFlow Builder. Workflow is the component that provides user interface

                                                     For creating, reviewing and maintaining workflow

                                                       Definitions.

             2). Workflow Engine.:   workflow is the component that executes and enforces

                                                       The defined workflow Process.

            

             3). Workflow Monitor.    Workflow is the component of oracle workflow that

                                                          Allows you to review the state or status of an item

                                                          Through any particular workflow process.

              4).Workflow Definition Loader:  allows u to download the text file.

             5). WorkFlow Directory Services.   Tells workflow how to find users.

             6). Notifaction System.      Send emails and receives responses from the Oracle

                                                           Workflow notification system.

Qns14: What are Interface table in AP, AR,GL.

Ans: AP INTERFACE TABLE: 1). AP_INTERFACE_CONTROLS.

                                                        2). AP_INTERFACE_REJECTIONS

                                                         3). AP_INVOICE_INTERFACE

                                                          4). AP_INVOICE_LINES_INTERFACE.

AR INTERFACE TABLE:

                                                    1). AR_PAYMENTS_INTERFACE_ALL

                                                    2). AR_TAX_INTERFACE

                                                    3). HZ_PARTY_INTERFACE

                                                    4). HZ_PARTY_INTERFACE_ERRORS

                                                    5). RA_CUSTOMERS_INTERFACE_ALL

                                                    6). RA_INTERFACE_DISTRIBUTIONS_ALL

                                                    7). RA_INTERFACE_ERRORS_ALL

                                                    8). RA_INTERFACE_LINES_ALL

                                                    9). RA_INTERFACE_SALESCREDITS_ALL

GLINTERFACE TABLE:

                                                  1). GL_BUDGET_INTERFACE

                                                  2). GL_DAILY_RATES_INTERFACE

                                                  3). GL_IEA_INTERFACE

                                                  4). GL_interface

                                                  5). GL_INTERFACE_CONTROL

                                                  6). GL_INTERFACE_HISTORY.

Q: 15 Total numbers of Tables in AP, AR, GL?

Ans; AP------à 173

            AR-----à 294

              GL----à 165

              FA---à 160

             PO--à 132.

             OE--à 109

Q16: How will u customize a form.

Ans: STEP1: Copy the template.fmb and Appstand.fmb from AU_TOP/forms/us.

                        Then put in custom directory. The libraries (FNDSQF, APPCORE,                 APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, VERT) are automatically attached .

STEP2:         Create or open new Forms. Then customize.

STEP3:        Save this Form in Corresponding Modules.

Q17:   What are non-financial modules.

Ans:  1). Projects

           2). Manufacturing

           3). Supply chain management

           4). HR

           5). Front Office

            6). Strategic Enterprise management.

Q18: Explain Order- cycle in AR.

Ans: Step1: Enter sales order.

        Step2: Book the sales order.

        Step3: Pick release order.

        Step4: Ship or confirm order.

        Step5: Backorder Release

        Step6:  Receivable Interface

        Step7: Complete line

        Step8: Complete order

Q19: What is AU_TOP.

Ans: This is the Application utility contains PL/SQL library used by oracle forms, reports, oracle form source files and a copy of all Java used to generate the desktop Client.

Q20:  What is ad_top.

  Ans: ad_top (Application DBA). Contain installation and maintenance utility.

Such as Autoupgrade, AutoPatch and Admin Utility.

Q21: Can we make transaction in close Periods.

Ans: No, we can make only reports.

Q22: If Period is closed how we can enter transactions? (Doubt)

Ans:   No, we can not inter transaction.

Q23: what is SQl*Loader.

Ans: This tool is used to move data from a legacy system to oracle database.

         In this two type of inputs to be provided to SQL * Loader.

          First is data file, containing the actual data.

          Second is The control file containing the specification which drive the

           SQL * Loader.    

         

Q24: How can u relate order management with AR.

Ans: sales orders are displayed after confirm release of sales in order management.

Q25:  What are the Field of GL_interface.

 Ans:  1). SET_OF_BOOKS_ID

           2). ACCOUNTING_DATE
           3). CURRENCY_CODE
           4). DATE_CREATED

           5). CREATED_BY
           6).  CURRENCY_CONVERSION_DATE

           7). ENCUMBRANCE_TYPE_ID
           8). BUDGET_VERSION_ID
           9). CURRENCY_CONVERSION_RATE

           10). ACCOUNTED_DR
           11).ACCOUNTED_CR
           12).TRANSACTION_DATE

Q26: In which directory u store your custom form.

Ans: 

                 APPL_TOP

                          |

                          |

------------------------------------------------------------------------------------------

|               |                        |                          |                                    |

Adm.        ad                      au                      fnd(foundation)            cust-dem

--------------------- Core directory--------------------------               (custom-directory)

                                                                                                          |

                                                                                                         11.0.28

                                                                                                           |

                                                                                                        Forms

                                                                                                            |

                                                                                                --------------------- 

US    | D

                                                                                                      |

We Store the Form Here.

App_Top is top directory. We have Core directory Adm., ad(application dba),

Au(application utility), fnd( Foundation), Cust-Dem is Custom directory where

 Have 11.0.28 version then we have forms directory. Inside the form we hv US

Directory. Where we stand forms.

Q27: Who is Holder of Alerts.

Ans:  ALERT Manager.

Q28: Steps for upgradation of 11 to 11i.

Ans28: STEP1: Perform category 1,2,3. (Preupgrade steps).

      

       STEP2:   Run autograde

       STEP3:  Apply database patch to bring your database to the

                       Current oracle apps release level.

        STEP4: Install online help (optional).

        STEP5: Perform Category 4, 5, 6 Steps (Post-upgrade steps).

        

         STEP6: Perform product specific implementation steps as listed in your products

                        Users guide.

         STEP7: perform upgrade finishing step.

Q28: How interface program is written and for what purpose

Ans28: Interface Program is written through SQL, PL/SQL.

            PURPOSE:  1). Basic Integration

                                   2). Imports valid data that is meaningful to

                                         Organization

                                    3). Validate the integrity of any data

                                          Before introducing into oracle apps.

                                    4). Imports data from legacy system.

                                     5). Import data from one module to another.

Q29: What is AOL.

Ans:  AOL stands for Application Object Library used for customization

          And implementation of forms and Reports.       

Q30: which Columns is taking care of descriptive flexfields?

Ans: Attribute Columns

Q31: Can u attach two sets of books with single profile.

Ans: yes we can attach.

Q32:  How U Can u attaches two sets of books with single profile.

Ans:  we can attach different set of Books with different responsibility

           In a single profile.

Q33: can we run FSG report other than GL.

Ans: No, we can not run.because FSG report can only run in GL.

Q34: What are the common libraries in AOL.

Ans34: libraries contain reusable client-side code.

            Common Libraries in AOL.

      FNDSQF: Contain packages for procedures for Message Dictionary,

                        Flexfields, profiles, and concurrent processing’s.

      APPCORE: Contain packages for procedures for Menus and Toolbar.

      APPDAYPK: contain packages that control application Calender.

      APPFLDR: packages for Folder.

Qns35:  What is multilanguage support.

Ans35: Oracle Application provides some feature to support multi language support.

Qns36: Can u delete the posted Journals. Can U make Changes in Posted Journals.

Ans36: No, once the posting program in oracle financial has updated accounts balances, you can not alter the posted journals, you can only post additional entries that negate the original values. These entries contain either the negative values of the original posted amounts or the original values but with the debit amounts and credit amounts reversed.

These approaches are known as reversal method.

Qns37: When u r taking bulk of reports.

Ans37: At midnight because traffic is less.

Qns38: Who is Holder of Alerts

Ans38: Alert Manager.

Qns39: What is TOAD.

Ans39: Tool for managing database activity,

Qns40: What is Flexfield?

Ans40: Oracle Application uses Flexfield to capture information about

             Your organization. Flexfield have flexible structure for storing key information.

              Like Company, Cost Center, and Account. They also give u highly adaptable

               Structure for storing customized information in oracle Applications.

Qns41: What are the elements of Flexfield?

Ans41:  1). Structure 2). Segment

              3). Segment value 4). Value set

Qns42: What do u mean by structure?

 Ans42: Structure as the name implies defines how Flexfield is

              Constructed. A Flexfield structure determine how many Segment

               it has, as well as how the segments are sequenced. Each structure is mapped

               To a structure ID Column in the database table for key Flexfield. Each

               Structure is mapped with context sensitive column in the database table for

               Descriptive Flexfield.

Qns43:  What do u mean by Segment?

Ans 43: Each Segment represents an element of your business structure

               Such as Employee, Cost Center, Account. A Flexfield can have

               Multiple Field. A segment is a single field with in a Flexfield.

Qns44: What do u mean by Valueset?

Ans 44: Valueset identifies a list of valid value for the segment.

               Valueset also govern the segment value’s length, its data type.

Qns45: What do u mean by Segment value.

 Ans45:  Value for each segment of flexfield.

Qns46: What is Key and Descriptive Flexfield.

Ans46: Key Flexfield: #unique identifier, storing key information

                                      # Used for entering and displaying key information.

                   For example Oracle General uses a key Flexfield called Accounting

                   Flexfield to uniquely identifies a general account.

             Descriptive Flexfield: # To Capture additional information.

                                                   # to provide expansion space on your form

                                                       With the help of [] . [] Represents descriptive

                                                        Flexfield.

Qns47: Difference between Key and Descriptive Flexfield?

Ans47:

Key Flexfield	Descriptive Flefield
1. Unique Identifier	1.To capture extra information
2. Key Flexfield are stored in segment	2.Stored in attributes
3.For key flexfield there are flexfield Qualifier and segment Qualifier	3. Context-sensitive flexfield is a feature  of DFF.(descriptive flexfield)

Qns48: Difference between Flexfield Qualifier and Segment Qualifier.

Ans48:  Flexfield qualifier is used to identify a particular segment within a

             Key flexfield. While segment qualifier is used to capture value for any particular

             Segment.

Qns49:       What is CrossValidation Rule?

Ans 49:    To prevent users from entering invalid combinations

                Of segments Oracle General Ledger allows u to set

                Up cross validation rule. There are two types of cross-validation

                 Rule element: include and exclude.

                  For example, to secure a balance sheet account to be associated

                  With the balance sheet cost center or the corporate cost center only,

                   U must include every possible combination then exclude the balance

                    Sheet account range for the cost center.                          

Qns50:    Purpose of CrossValidation rule.

Ans50:  u can use CrossValidation rule to perform certain validations in your

             Accounting flexfield. For example, u can use CrossValidation rule

             To secure all balance sheet account to be associated only with the balance

              Sheet cost center, corporate cost center and profit and loss account

               To be associated with the specific cost center other than the corporate

                Center.

Qns51:  What are types of segment for Descriptive Flexfield.

Ans51: Two types

           1). Global segments

            2). Context-sensitive segment.

    Global Segment: global segment maps one to one to a database column.

                                  DFF segment stored in ATTRIBUTE. Global segment always

                                   Displayed in a descriptive flexfield.

 Context-Sensitive Segment: Context sensitive segment can share a single database

                                                 Column because the context – sensitive will be

                                                 Mutually exclusive and will never overlap.

Qns52:  What are Key Flexfield in AP, AR, GL.

Ans52: Key Flexfield in GL: Accounting Flexfield.

             Accounting Flexfield is chart of account flexfield.

             It is used for identifying an account combination.

              It must have a balancing segment, cost center segment,

               Natural account segment.

               Combination table in Acct. FF : GL_CODE_COMBINATION_ID.

                Structure column: chart_of_accounts_id.

                Maximum number of Segments: 30.

  

                Key flexfield in AR: 1). Sales Tax Location Flexfield.

                                                   2). Territory Flexfield

                Sales Tax Location Flexfield: to calculate sales tax.

                 Combination table: AR_LOCATION_COMBINATION

                  Max number of segment: 10

                  Territory Flexfield: This is used to group territories according to company 

                                                    Needs.

                    Combination table: RA_TERRITORIES.

Qns53:  What is purpose of Token Field.

 Ans53: To define parameter name defined in oracle reports.

Qns54: What is Templateform?

Ans54:  Template form is the starting point for all development of new form.

               Start developing new form by copying template.fmb file located in

               AU_TOP/forms/us to local directory and renaming it as appropriate.

                Template Form Contains

·         Several libraries like FNDSQF, APPDAYPK, and APPCORE.

·           STANDARD_TOOLBAR, STANDARD_CALENDER

·         Several form level trigger with required code.

Qns55: What are Handlers?

Ans55: Oracle application uses group of packaged procedure called handlers,

             To organize PL/SQL code in the form so that it is easier to develop,

              Maintain and debug.

               Types Of handler: 1). Item handler

                                             2). Event handler

                                             3). Table handler.

                 Item handler: An item handler is a PL/SQL Procedure.

                                           That encapsulates all of the code that acts upon an item.

                 Event handler: An item handler is a PL/SQL Procedure.

                                         That encapsulates all of the code that acts upon an event. 

                 Table handler: An item handler is a PL/SQL Procedure.

                                         That manages interaction between block and base table.

Qns56: What is Appstand Form.

Ans56: Appstand form contains the Following.

            1).Object Group STANDARD_PC_AND_VA.

                 Which contain the visual attribute and property class.

             2). Object group STANDARD_TOOLBAR which contains the windows

                   Canvasses blocks and item of application toolbar.

              3). Object group STANDARD_CALENDER which contains the windows

                   Canvasses blocks and item of application calendar.

              4). Object groups QUERY_FIND, which contains a window, blocks and item

                   Used as a starting point for coding a find window.

        Qns56: What is set of books.

Ans56: A financial reporting entity that uses a particular chart of accounts, functional currency and accounting calendar. You must define at least one set of books for each business location.

         Qns57: what are four options that are tied to defined set of books.

          Ans57: 1. Standard option (supenseposting, automaticposting, Average

                           Balanceposting)

                       2). Average Balance option.

                       3). Budgetary control option.

                       4). Reporting Currency option.

     

           Qns58: What is FSG.

            Ans58: A powerful and flexible tool you can use to build your own custom

                          Reports without programming.

      

          Qns59:  What are the components of FSG?

           Ans59: 1). Row set

                        2). Column set

                        3). Row order

                         4). Display set

                          5). Content set.

        

          Qns60: What is MRC.

           Ans60: The Multi Reporting Currency Feature allows u to report

                        And maintain records at the transaction level in more than one

                         Functional currency.you can do by defining one or more set of books in

                          Addition to primary set of books.

          

          Qns61:  What are Alerts..

           Ans61:    Oracle alert is an application module that reports exception actions

                           Based on the detected exceptions. U can create alert when specific event

                           Occur or that run periodically.

                                                      Oracle alert provides a reliable way to monitor database

                          Activity. As well as keeping u informed of unusual condition.

                          U can monitor your business performance through alerts.

          Qns62:  Types of alerts?

           Ans62:  Two types of alerts.

1.      Event alert

2.       Periodic Alert

Event alerts: An event alert is a database trigger that notifies u when

A specified database event occurs and a particular condition is met.

Periodic event: A periodic alert on the other hand is not immediate.

                          It is executed according to a predefined frequency

.

          Qns63: What are three alert action types?

           Ans63: 1.   Detail (An action defined at detail level is initiated once for

                                          Each exception found. – Meaning once for each row

                                           Returned by the select statement in the alert definition.

                        2). Summary (An exception defined at the summary level is initiated

                                               Once for all exceptions found or once for each unique

                                                 Output combination.)

                        3).  No Exception (An action defined at the no-exception level is initiated

                                                       Once if no data is returned from the select statement).

     Qns64: What are the advantages of alert.

      Ans64: 1).   Integration with email.

                   2).  Automatic processing

                   3).   Performing routine transactions

                    4).  Maintaining information flow without a paper trail.

   Qns65: What is Currency.

   Ans65:  Two types of Currency.

                 1). Foreign Currency: A currency that you define for your set of books for

                                                       Recording and conducting accounting transactions in a

                                                       Currency other than your functional currency

                  2). Functional Currency: The principal currency you use to record transactions

                                                           And maintain accounting data within General

                                                            Ledger. The functional currency is usually the

                                                             Currency in which you perform most of your

                                                              Business transactions. You specify the functional

                                                                  Currency for each set of books in the Set of

                                                                  Books window.

Qns66: Types of matching.

Ans66: Two way Matching: The process of verifying that purchase order and invoice information matches within accepted tolerance levels. Payables uses the following criteria to verify two-way matching:
Invoice price <= Order price
Quantity billed <= Quantity ordered

Three way matching: The process of verifying that purchase order, invoice, and receiving information matches within accepted tolerance levels. Payables uses the following criteria to verify three-way matching:
Invoice price <= Purchase Order price
Quantity billed <= Quantity ordered
Quantity billed <= Quantity received

Four way Matching: The process of verifying that purchase order, invoice, and receiving information matches within accepted tolerance levels. Payables uses the following criteria to verify four-way matching:
Invoice price <= Order price
Quantity billed <= Quantity ordered
Quantity billed <= Quantity received
Quantity billed <= Quantity accepted

Qns67: What is the difference between Master table, setuptable, and transaction table.

Ans 67: Master table: Created in any module and accessible across the application.

                                    Like GL_CODE_COMBINATIONS, GL_SET_OF_BOOKS.

              Transaction –Table: transaction tables are tables that store day to day transaction

                                               Data. Such as payable invoice, receivable invoice.

               Set-Up table: Created once with in Application.Like FND_CURRENCY.

Qns68: Name Few Master tables, Set up table I, transaction table in AP, AR, GL.

Ans68:

Module Name	Master table	setup table	Transaction table
GL	1.GL_SET_OF_BOOKS 2.GL_CODE_COMBINATIONS	FND_CURRENCY	GL_JE_LINES GL_JE_HEADRES GL_JE_BATCHES GL_interface GL_CONSOLIDATION GL_SUSPENSE_ACCOUNTS GL_INTERCOMPANY_ACCOUNTS
AP	PO_VENDORS AP_BANK_BRANCHES PO_VENDOR_SITES AP_HOLD_CODES	FND_CURRENCY	AP_BATCHES_ALL AP_INVOICE_ALL AP_DISTRIBUTION_ALL AP_CHECKS_ALL AP_PAYMENTS_HISTOTRY_ALL
AR	HZ_CUST_ACCOUNT	FND_CURRENCY	AR_ADJUSTEMENT_ALL AR_PAYMENTS_SCHEDULE_ALL AR_CASH_RECEIPT_ALL AR_DISTRIDUTION_ALL AR_RECEIVABLE_APPLICATION_ALL.

    Qns69: What do u mean by Fifopick and Fifoship.

     Ans69: Fifopick: First in first out. (Order comes from customer).

                 Fifoship: order ship to customer. 

 Qns70: Difference between SC and NCA.

 Ans70:

SC	NCA
1. SMART CLIENT	1. Network computing Architecture
2. No form server in SC. All form are in directory which is on the client.	2. Forms are in the server. Thus making security higher.

Qns71: What is first step in GL.

Ans71: Creating chart of account.

Qns72: What are standard reports in GL.

 Ans72: Trial Balance Report

             Journal Report

              FSG REPORT

              Account Analysis Report.

Qns73: What are standard reports in AP.

Ans73: 1.  Supplier Report

             2). Payment Report

             

Qns74: What are standards report in AR.

Ans74:              1. Tax Report                      2.  Customer Profile Report

3.      Aging Report                 4. Dunning Letter Report

Qns75.What are customer table, transaction table, and Receipt table in AR.

Ans75:

Module	Customer Table	Transaction Table
AR	HZ_CUST_PROFILE_CLASS HZ_CUST_PROF_CLASS_AMTS HZ_CUSTOMERS_PROFILES HZ_CUST_PROFILE_AMTS HZ_CUST_ACCOUNTS HZ_CUST_ACCT_SITES_ALL HZ_CUST_CONTACT_POINTS HZ_CUST_ACCT_RELATES_ALL HZ_CUST_SITES_USES_ALL	RA_CUTOMER_TRX_ALL RA_CUSTOMER_TRX_LINES_ALL RA_CUST_TRX_TYPES_ALL RA_CUST_TRX_LINE_SALESREPS_ALL

RECEIPT Table

AR_CASH_RECEIPTS_ALL AR_RECEIPT_METHOD AR_CASH_RECEIPT_HISTORY_ALL AR_INTERIM_CASH_RECEIPT_ALL

                  

 Qns76: What is Custom-Library.

 Ans76: The custom library allows extension of oracle application without modification

              Of oracle application code. U can use the custom library for customization

               Such as zoom (moving to another form), enforcing business rule(for example

                Vendorname must be in uppercase letters) and disabling field that do not apply

                 For your site.

                 Custom library is placed in AU_TOP / resource directory.

            Event Passed to Custom-Library:

            1). WHEN_FORM_NAVIGATE

            2). WHEN_NEW_FORM_INSTANCE

            3). WHEN_NEW_BLOCK_INSTANCE

            4). WHEN_NEW_RECORD_INSTANCE

            5). WHEN_NEW_ITEM_INSTANCE.

Qns78: What are the Component of alerts.

Ans78:  1. Message

              2.SQL SCRIPT

              3.Operating system script

4.       Concurrent request.

Qns79: What is difference between chargeback and adjustment.

Ans79:

CHARGEBACK	ADJUSTMENT
A new debit item that u assign to your customer closing an existing , outstanding debit item.	A receivable feature that allows u to increase or decrease the amount due of your invoice, debit memos, chatgeback.

 Qns80: What are types of invoice.

  Ans80:

TYPES OF INVOICES

NINE Type: Standard Credit memo Debit memo Expense Report PO default Prepayment Quick match Withholding tax Mixed

         Qns81: What are sub modules in Financials.

          Ans81:

Sumodule in Financials

GL AP AR FA CM(cash management) Financial Analyzer

    

 Qns82: Concept of Multiorganisation, Explain.

   Ans82:   Multi organization allows u to setup multiple legal entities

                 Within a single installation of oracle applications.

           

          ARCHITECTURE  OF MULTIPLE ORGANISATION

Set of books: Within one set of books u may define one or more legal entities.

LEGAL ENTITY: each legal entity has its own employer tax identification number.

                                And prepare its own tax forms. Each legal entity has its own

                                Tax forms. Each legal entity has its own set of federal tax rule,

                                 State tax rule and local tax rule. Legal entities consist of one or

                                  More operating units.

Operating unit: operating units’ represents buying and selling units with in your

                         Organization. Oracle order Entry, Oracle receivables, Oracle Purchasing,

                         and Oracle Payables.

Inventory Organization:  an Inventory organization is a unit that has inventory                

                                        Transactions. Possibly manufactures and or distribute products.

Qns83: How will u attach SOB.

Ans83: STEP1: Create a new Responsibility.

                           (NàsecurityàResponsibilityàDefine).

             STEP2: Attach the new responsibility to an existing user.

      STEP3: Defining a new Period Type.

      STEP4: Defining an accounting calendar.

       STEP5: Defining a set of books.

       STEP6: Attach the set of books to your responsibility.(NàProfileàSystem)

        STEP7: Signing on as new responsibility.

Qns84: What are key functions provided by Oracle General Ledger.

Ans84:

Function Provided by GL

General Accounting Budgeting Multiple Currencies Intercompany Accounting Cost Accounting Consolidation Financial Reporting

Qns85: What do u mean by cost center?

Ans85: COST center gives the information about investment and returns

             On different projects.

Qns86: what is Fiscal Year.

Ans86: Any yearly accounting Period without relationship to a calendar year.

Qns87: What is Credit-memo?

Ans87: A document that partially or reverse an original invoice.

Qns88: How data is transferred from legacy system to Oracleapps table.

Ans88: A system other than oracle apps system is called legacy System.

Qns89: What is Chart of Accounts?

Ans89:  The account structure your organization uses to record transaction and maintain

               Account balances.

Qns90: What are different types of budgets.

Ans90:

Types of Budgets

Operating Captial Master Production Schedule Variable Time-Phased

Qns91: How others modules are integrate through GL.

Ans91:  Integration of module With GL

Qns92: Explain Payable Cycles:

Ans92: Four steps in AP Cycle

                                   PAYABLE CYCLE             

Four steps in Payable Cycles:

STEP1: Enter Invoice (this process may or may not include matching each invoice with

                                       PO).

STEP2: Approve invoice payment.

STEP3: Select and pay approval invoices.

STEP4: Reconcile the payment with bank statement.

                                                                                                                                                                                                                                                                       

Qns95:  AGING BUCKETS?

A.  Time periods you define to age your debit items. Aging buckets are used in the Aging       reports to see both current and outstanding debit items. For example, you can define an aging bucket that includes all debit items that are 1 to 30 days past due.

   Payables uses the aging buckets you define for its Invoice Aging Report

Q96. CREDIT INVOICE?

A.  An invoice you receive from a supplier representing a credit amount that the supplier owes to you. A credit invoice can represent a quantity credit or a price reduction.

Q97. CREDIT MEMO?

A document that partially or fully reverses an original invoice.

Q98.CUTOFF DAY

The day of the month that determines when an invoice with proxima payment terms is due. For example, if it is January and the cutoff day is the 10th, invoices dated before or on January 10 are due in the next billing period; invoices dated after the 10th are due in the following period.

Q99. DEBIT INVOICE?

A.  An invoice you generate to send to a supplier representing a credit amount that the supplier owes to you. A debit invoice can represent a quantity credit or a price reduction.

Q100. JOURNAL ENTRY HEADER/S?

A.   A method used to group journal entries by currency and journal entry category within a journal entry batch. When you initiate the transfer of invoices or payments to your general ledger for posting, Payables transfers the necessary information to create journal entry headers for the information you transfer. Journal Import in General Ledger uses the information to create a journal entry header for each currency and journal entry category in a journal entry batch. A journal entry batch can have multiple journal entry headers.