Financials , here some more General Ledger Questions, I consider these as functional and advance questions.Can a flexfield qualifier be changed after it has been created?No. Once a segment qualifier has been designated for a specific segment and has been saved, it will permanently have the attributes with that qualifier.For example, you accidentally designate the cost center segment as the natural account segment. Even though you do not compile this, the system saves the changes. And once it has been saved, it will have all the attributes designated for the natural account qualifier, even after it has been changed back, resaved with the correct qualifier and compiled. This is the inherent functionality of the software.Unfortunately, there is no real easy solution for this issue. The only option is to create a new chart of accounts and attach a new set of books. 

 

 

 

Does the Accounting Flexfield needs one segment flagged with the Intercompany qualifier?The intercompany segment is an optional Intercompany feature for the Intercompany Segment Balancing.It is not required in order to do intercompany balancing.It is just another way to do the intercompany balancing, instead of using different natural accounts to track intercompany balances, you can use the intercompany segment in the Chart of Accounts to record the same detail.It is more just a matter of preference of how you want to track the intercompany transactions.

 

 

 

  Can different Sets of Books share the same Value Set?If there is a set of books that uses a particular value set and a new book is created, it can use the existing value set.When the Account Flexfield Structure is created, simply choose the existing value set from the List of Values.However,if you use an existing value set, the new structure will also inherit the existing values in the value set. It does not create an empty value set to be populated.

 

 

 

 Can the Accounting Flexfield Segment name be changed?Nothing about a flexfield structure should be changed since this could seriously impact your existing data and cause inconsistenciesThe LOV (list of values) prompt and window prompt that appear on the segment form can be changed so the users can see the segment with a different name.

1.      Navigate to Setup: Financial: Flexfield: key: segments2.      Query all3.      Unfreeze your flexfield4.      Open the segment summary screen5.      Choose the segment you wish to change6.      Change the LOV and window Prompts and insert the new name.7.      Save your work8.      Freeze the Flexfield which should launch a concurrent request.9.      Check the log and make sure the compile worked OK.

 How to add a new value to an existing segment?On the Segment Values form, insert a new row with your new value.Make sure the segment qualifiers are set correctly (Allow Posting and Budgeting).If this is the natural account segment, specify the Account Type also. 

 

 

  How to delete a segment value? There is no supported way to delete a segment value. Segment values can only be disabled not deleted. How to enable an existing Future-Use accounting flexfield segment? Do the following, on the Key Flexfield Segments form:

1. Unfreeze the accounting flexfield2. Change the Window Prompt name to a valid name (do NOT change the segment

name)3. Update the Default Type and Default Value (if necessary)4. Freeze the accounting flexfield and recompile

How to re-enable an account value? In order to re-enable an account value or remove an end date, do the following: 

1. Unfreeze the accounting flexfield structure2. Re-enable the account value or remove the end date of the segment value.3. Re-freeze the accounting flexfield structure and recompile.4. Log out of the applications and log back in.

 Is there a way to load values for a specific segment outside of the form? iSetup is the Oracle product that provides supported APIs to load values into Oracle Applications flexfields.To load code combinations ADI may be used. Uploading zero amount journals will create new code combinations.In this case Dynamic Insertion should be enabled and all account segment values need to exist before the new account code combinations will be dynamically created.What is the difference between Hierarchical and Non-hierarchical Security Type?

 

 

 

Hierarchical Security: This feature combines Flex Value Security and Flex Value Hierarchy.The end result is ?a flex value is secured if one of it?s parents is secured?, i.e. if a parent value is excluded then all the children are also excluded.

 

 

With non-hierarchical security, the child values do not inherit the parent security.  

Which tables store segment values and descriptions?  FND_FLEX_VALUES_TL FND_FLEX_VALUES.

 Thanks - Shivmohan Purohit 

 

 

 

Categories: Interview Questions · Oracle GL Functional · Oracle GL Technical Tagged: Accounting Flexfield, chart of account, flexfield, fnd_flex_values, gl inerview, gl security, gl techical interview, oracle general ledger, value set

Oracle A.I.M. Methodology – template   list

February 25, 2009 · 6 Comments

Oracle A.I.M. Methodology encompasses a project management methodology with documentation templates that support the life cycle of an implementation. The life cycle methodology and documentation templates allows A.I.M. to be a very useful tool for managing implementation projects successfully. This is a depiction of the A.I.M. methodology life cycle:

Application Implementation Method is a proven approach for all the activities required to implement oracle applications. there are eleven processes of implementation.

1. Business Process Architecture [BP] – This phase outlines:

Existing Business Practices Catalog change practices Leading practices Future practices

BP.010 Define Business and Process StrategyBP.020 Catalog and Analyze Potential ChangesBP.030 Determine Data Gathering RequirementsBP.040 Develop Current Process Model

BP.050 Review Leading PracticesBP.060 Develop High-Level Process Vision

BP.070 Develop High-Level Process Design

BP.080 Develop Future Process Model

BP.090 Document Business Procedure    

 

2. Business Requirement Definition [RD] - This phase explains about the initial baseline questionnaire and gathering of requirements.

RD.010 Identify Current Financial and Operating Structure RD.020 Conduct Current Business Baseline RD.030 Establish Process and Mapping Summary RD.040 Gather Business Volumes and Metrics RD.050 Gather Business Requirements RD.060 Determine Audit and Control Requirements RD.070 Identify Business Availability Requirements RD.080 Identify Reporting and Information Access Requirements

3. Business Requirement Mapping [BR] – In this phase the requirements of business are matched with the standard functionality of the oracle applications.

BR.010 Analyze High-Level GapsBR.020 Prepare mapping environmentBR.030 Map Business requirementsBR.040 Map Business DataBR.050 Conduct Integration Fit AnalysisBR.060 Create Information Model

BR.070 Create Reporting Fit Analysis

BR.080 Test Business Solutions

BR.090 Confirm Integrated Business Solutions

BR.100 Define Applications Setup

BR.110 Define security Profiles    

 

4. Application and Technical Architecture [TA] – This outlines the infrastructure requirements to implement oracle applications.

TA.010 Define Architecture Requirements and StrategyTA.020 Identify Current Technical ArchitectureTA.030 Develop Preliminary Conceptual ArchitectureTA.040 Define Application ArchitectureTA.050 Define System Availability StrategyTA.060 Define Reporting and Information Access Strategy

TA.070 Revise Conceptual Architecture

TA.080 Define Application Security Architecture

TA.090 Define Application and Database Server Architecture

TA.100 Define and Propose Architecture Subsystems

TA.110 Define System Capacity Plan

TA.120 Define Platform and Network Architecture

TA.130 Define Application Deployment Plan

TA.140 Assess Performance Risks

TA.150 Define System Management Procedures    

 

5. Build and Module Design [MD] – This phase emphasizes the development of new functionality (customization) required by the client. It mainly details how to design the required forms, database and reports.

MD.010 Define Application Extension StrategyMD.020 Define and estimate application extensionsMD.030 Define design standardsMD.040 Define Build StandardsMD.050 Create Application extensions functional designMD.060 Design Database extensions

MD.070 Create Application extensions technical design

MD.080 Review functional and Technical designs

MD.090 Prepare Development environment

MD.100 Create Database extensions

MD.110 Create Application extension modules

MD.120 Create Installation routines    

 

6. Data Conversion [CV] – Data Conversion is the process of converting or transferring the data from legacy system to oracle applications. Ex. Transferring customer records from the legacy to the Customer Master.

CV.010 Define data conversion requirements and strategyCV.020 Define Conversion standardsCV.030 Prepare conversion environmentCV.040 Perform conversion data mappingCV.050 Define manual conversion proceduresCV.060 Design conversion programs

CV.070 Prepare conversion test plans

CV.080 Develop conversion programs

CV.090 Perform conversion unit tests

CV.100 Perform conversion business objects

CV.110 Perform conversion validation tests

CV.120 Install conversion programs

CV.130 Convert and verify data    

 

7. Documentation [DO] – Documentation prepared per module that includes user guides and implementation manuals.

DO.010 Define documentation requirements and strategyDO.020 Define Documentation standards and proceduresDO.030 Prepare glossaryDO.040 Prepare documentation environmentDO.050 Produce documentation prototypes and templatesDO.060 Publish user reference manual

DO.070 Publish user guide

DO.080 Publish technical reference manual

DO.090 Publish system management guide    

 

8. Business System Testing [TE] – A process of validating the setup’s and functionality by QA(functional consultant) to certify status.

TE.010 Define testing requirements and strategyTE.020 Develop unit test scriptTE.030 Develop link test scriptTE.040 Develop system test scriptTE.050 Develop systems integration test scriptTE.060 Prepare testing environments

TE.070 Perform unit test

TE.080 Perform link test

TE.090 perform installation test

TE.100 Prepare key users for testing

TE.110 Perform system test

TE.120 Perform systems integration test

TE.130 Perform Acceptance test

    

 

9. Performance Testing [PT] - Performance testing is the evaluation of transactions saving time, transaction retrieval times, workflow background process, database performance, etc

PT.010 – Define Performance Testing StrategyPT.020 – Identify Performance Test ScenariosPT.030 – Identify Performance Test TransactionPT.040 – Create Performance Test ScriptsPT.050 – Design Performance Test Transaction ProgramsPT.060 – Design Performance Test Data

PT.070 – Design Test Database Load Programs

PT.080 – Create Performance Test TransactionPrograms

PT.090 – Create Test Database Load Programs

PT.100 – Construct Performance Test Database

PT.110 – Prepare Performance Test Environment

PT.120 – Execute Performance Test    

 

10. Adoption and Learning [AP] – This phase explains the removal of the legacy system and oracle application roll out enterprise wide.

AP.010 – Define Executive Project StrategyAP.020 – Conduct Initial Project Team OrientationAP.030 – Develop Project Team Learning PlanAP.040 – Prepare Project Team Learning EnvironmentAP.050 – Conduct Project Team Learning EventsAP.060 – Develop Business Unit Managers’Readiness Plan

AP.070 – Develop Project Readiness Roadmap

AP.080 – Develop and Execute CommunicationCampaign

AP.090 – Develop Managers’ Readiness Plan

AP.100 – Identify Business Process Impact onOrganization

AP.110 – Align Human Performance SupportSystems

AP.120 – Align Information Technology Groups

AP.130 – Conduct User Learning Needs Analysis

AP.140 – Develop User Learning Plan

AP.150 – Develop User Learningware

AP.160 – Prepare User Learning Environment

AP.170 – Conduct User Learning Events

AP.180 – Conduct Effectiveness Assessment    

 

11. Production Migration [PM] – The process of “decommissioning” of legacy system and the usage(adoption) of oracle application system.

PM.010 – Define Transition Strategy

PM.020 – Design Production Support Infrastructure

PM.030 – Develop Transition and Contingency Plan

PM.040 – Prepare Production Environment

PM.050 – Set Up Applications

PM.060 – Implement Production Support Infrastructure

PM.070 – Verify Production Readiness

PM.080 – Begin Production

PM.090 – Measure System Performance

PM.100 – Maintain System

PM.110 – Refine Production System

PM.120 – Decommission Former Systems

PM.130 – Propose Future Business Direction

PM.140 – Propose Future Technical Direction

thanks – Shivmohan Purohit

Categories: General Technical · Oracle AP Functional · Oracle AR Functional · Oracle FA Functional · Oracle Functional · Oracle GL Functional · Oracle HRMS Technical · Oracle Inventory Functional · Oracle Payables Technical · Oracle Projects Functional · Oracle Projects Technical · Oracle Receivables Technical · Oracle Technical · System Administrator Tagged: aim, documentation, methodology, Projects, template

Oracle Applications / Financials – Functional Question on General Ledger –   Budgeting

January 23, 2009 · 3 Comments

Oracle Applications / Financials – Functional Question on General Ledger – Budgeting. Quite useful as FAQ and Interview Questions for General Ledger.

11. What is Set of Books? What are the four conditions when you change your SOBs?SOB is of 2 types – Primary and Reporting.Primary SOB - All transactions are with functional Currency

12. What is an Invoice?AR invoice is a document sent to the customer with details like, Bill-to customer code, product code, qty sent, price, currency, credit terms, tax details, etc. Based on this invoice, customer will make payment to the company and the same is applied against the invoice. AP invoice is the document received from the supplier and contains information such supplier details, product code, qty, price and tax details. This invoice is entered in the AP module and payment is made to the supplier against this invoice.There are 2 types of invoices-

1. Periodic 2. Milestone

Also, Invoice is an information sheet which a company sends to the buyer along with the good. It explains the details of the goods in the shipment and also the prices. Invoices can contain all sorts of data regarding the shipment and goods depending on the company and product.

13. Can you disable budgetary control for a set of books?

You can, however existing encumbrances are not cleared from the feeder systems. Therefore it is not recommended. If you do change the budgetary control options for an existing set of books, you must do two things for the change to be reflected.

–Run the Period Map Maintenance concurrent request, it must complete successfully.

–Exit Oracle Applications and restart. You must completely exit the application…it is not sufficient to select Sign on again from the Oracle Applications Special menu.

14. Is there a limit to the number of periods in a budget year or how many years a budget can span?

There is no limit for the budget. One can define budgetary control for n number of years however, one year can have maximum of 60 fiscal periods.

15. Why don’t my Detail budgets roll up to my Master budget?Detail budgets do not automatically roll up to the master budget. The GL uses summary accounts to maintain master/detail budget relationships between them. 

 

16. I was able to post a budget journal to a closed period, why?Yes, a budget journal can be posted to any period that is in an open budget year for that budget. This is regardless of the status of that period. The budget journal is not linked with your accounting period. Once you have open the budget period then you can book budget journal for that whole period. 

 

17. How many ‘Current’ budgets can you have?For each set of books, you can have only one current budget at any point in time. The only distinction between a ‘current’ and an ‘open’ budget is that the current budget defaults into the budget field on several budget-related forms. It can be replaced however by any ‘open’ budget in the field.18. What is a funding budget?

Funding budget is a budget against which accounting transactions are checked for available funds when budgetary control is enabled for your set of books. Funding Budgets are approved budgets.Two types of budgets are there in Oracle Apps: 1- Fund 2- Plan.

Fund budget create the Budget Journal but plan budget used only for planning. Fund budget requires journal entries, and is assigned to a summary template or account range in the budget org, where the funds check level is set at Absolute or Advisory. It is the assignment that makes it a ‘funding budget’; it is not done at the budget definition level.

19. Why is my budget requiring budget journals?At the set of books level that option is not enabled? This would happen when the budget itself is defined to require budget journals. This is done at the budget definition level. 

 

20. Why can’t I inquire on my budget amounts from INQUIRE/BUDGETS navigation path?The Budget Inquiry form (GLXIQBUD) is used to perform inquiries about master and detail budgets. GL compares summary balances between your master and detail budgets, and checks for budget variances and violations. This form only looks at summary accounts. To inquire on detail accounts you must use the navigation INQUIRE/ACCOUNTS, and choose the ‘budget’ amount type. 

 

21. If I delete my budget org, will the budget amounts be deleted?No, the amounts will be same. Deleting the budget organization does not remove the budget amounts from the GL_BALANCES table. 

 

22. Can I update/adjust an existing account range in my budget organization?Yes you can update an existing account range in Budget Organization. 

 

23 How many times can a budget be purged?Budget can be purged only one time. 

 

24. Why is there no value in the REQUEST_ID column of GL_BUDGET_INTERFACE for rows with data that failed to be uploaded by the Budget Spreadsheet Upload program?You are trying to open the next budget year. After navigating to the form and querying the budget, you notice the [Open Next Year] button is grayed out. You find that Account code combinations are not being added to the Budget Organization.25. Why don’t my Detail budgets roll up to my Master budget?

Detail budgets do not automatically roll up to the master budget. The GL uses summary accounts to maintain master/detail budget relationships between hierarchy levels. Summary templates are defined so that accounts in your lower level detail budgets roll up into the same summary accounts as the detail accounts in your controlling master budget. A common misconception is that the detail budgets somehow roll up to the master budget by definition, this is not true. You must actually budget to a detail account in the master budget; this then serves as the controlling amount for the detail budgets. Master/Detail

budgets are used in the budgeting process to control Authority and identify budgets that exceed control limits. They are not intended for reporting purposes.

26. I was able to post a budget journal to a closed period, why?A budget journal can be posted to any period that is in an open budget year for that budget. This is regardless of the status of that period (closed, opened, or future enterable).27. Why don’t my budget amounts appear on my FSG?

To include budgets (encumbrances or currencies) in a FSG report, your report definition must specify a row set of column set that has control values specified in the Balance Control options. In the report definition itself, you associate budget names with the control values that are assigned to the row or column set.

 Shivmohan Purohit

 

 

 

Reporting SOB - All transactions are with foreign Currency

You have to assign your SOB to your responsibility. Set of book means linking between the 3cs i.e. chart of accounts, calendar, currency and maintain 5 mandatory accounts. Set of books are created keeping in mind the ‘Accounting Structure”. This is a combination of 3 ‘Cs’ – Chart of Accounts, Currency and Calendar. Chart of Accounts is made up of segments- Max of 30 Segments are allowed. Two Segments are mandatory – Balancing and Natural segment, Calendar –This can have a max of 365 periods (daily calendar) and a min of 1 period (Yearly calendar). Periods can be monthly, fortnightly, weekly, daily.

Categories: Interview Questions · Oracle Applications Technical · Oracle GL Functional · Oracle GL Technical Tagged: 11i, budgeting, calender, chart of accounts, faq, functional, general ledger, gl, interview, Interview Questions, oracle, segment, set of books, sob, technical, useful

Oracle Applications – Technical Interview   Questions

January 20, 2009 · 2 Comments

Hello Friends, Upon requests on some of my friends, i am posting few more generic oracle applications’ questions. hope this will give you overview of generic features. do share your feedback if these are good n useful. 

what is a flexfield qualifier ?

Oracle Applications products use flexfield qualifiers to identify certain segments used for specific purposes. eg: segment named ‘Account’ is qualified as ‘Natural Account’so that it identifies Accounts, similarly a segment named ‘Company’ can be qualified as ‘Balancing Segment’, i.e, for these segment values B/S can be brought out in Accounting Flexfield in GL.

 A flexfield is made of segments and oracle identifies if particular segment in the accounting flexfield is an account segment or a company segment, based on some predefined values called as flexfield qualifiers which are assigned to the segments to look meaningful for defining the accounting flexfield. Eg: Account segment uses Natural Account segment and the company segment uses Balancing segment are mandatory for defining the accounting flexfield. Other values are Cost center segment, Inter company segment, secondary tracking segment

 

What is the difference between configuration, conversion, and customization?

Conversion ,customization and configuration are part of an oracle implementation project they come in this order

1. configuration/set up

2. Customization

3. Conversion

Configuration is setting up customer specific requirement which generally exist in oracle apps customization is filling the gap between oracle apps and Customer requirement by developing some extension and solution design

Customization is relatively different thing, something that is not a part of oracle apps core product but the client requirement demands it we go for Customization. If the functionality demanded by the client exists in the application, it is to be configured according to his needs by taking some data, this is called configuration

Conversion is structural change of customer data in a form which is compatible with oracle database best of luck. Conversion is the process of mapping the tables from a legacy system to apps system. Sometimes conversions can be from one version to other

 

Where we can check the status of PO.

In po_headers_all authorization_status coloumn is their we can find through this coloumn

 

What is back order in OM

There are few reasons that a scheduled order could be Backordered during pick release process.

1. In-sufficient onhand

2. Order might be put as ‘Pick release hold’

3. If it’s a lot controlled item being involved then some of the factors will be checking at picking rule setup (like Lot- expiration date, etc) and tured to ‘Backordered’ incase the criteria does not meet.

 

Where we find the status of order information.

Order header status is in oe_order_headers_all table reference with flow_status_code column and order line status would be oe_order_lines_all table reference with flow_status_code column.

 

What are the tables of auto invoice?

RA_INTERFACE_LINES_ALL, RA_INTERFACE_DISTRIBUTIONS_ALL ARE THE TWO INTERFACE TABLES MAINLY USED BT AUTOINVOICE.  FURTHER DATA READ FROM THESE TABLES WILL BE INSERTED INTO RA_CUSTOMER_TRX_ALL , RA_CUSTOMER_TRX_LINES_ALL , RA_CUST_TRX_LINE_GL_DIST_ALL , AR_PAYMENT_SCHEDULES_ALL AFTER VALIDATING.

 

For report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we will make it.

While defining Parameters you can set range option(in concurrent prog parameters window). Select low for from_Date and high for to_Date.Then it will not allow for from_date > to_date.

 

How to find the custom directory in front end.

From Application Developer responsibility, navigate to Application –> Register. Query for the custom application name. The value in the field Basepath, is the OS system variable that stores the actual directory info.

 

What are the execution methods in oracle apps?

1. Host

2. Immediate

3. Java Stored Procedure

4. Java Concurrent Program

5. Multi Language Function

6. Oracle Reports

7. Request Set Stage Function

8. Pl/Sql Stored Procedure

9. Spawned

10. Sql*Lodar

11. Sql*Plus

12. Perl Concurrent Program

 

What are APIs

API stands for application program interface. Oracle has its own api facility to transfer data from a external source to oracle base table so api is an standard oracle tool to transfer data to oracle database. It is a very simple method and a person with no technical background also can use api. Example-uploading journal and budget data through API.

 

Thanks – plz share questions if you have more in this area. also share your comment/feedback. Shivmohan Purohit

Categories: Application Developer · General Technical · Interview Questions · Knowledge Base · Oracle AP Functional · Oracle AR Functional · Oracle Applications Technical · Oracle FA Functional · Oracle Functional · Oracle GL Functional · Oracle Inventory Functional · Oracle Technical · System Administrator Tagged: 11i, aol, Application Object Library, functional, interview, overview, technical

Oracle Financials Accounting – Interview Technical Fucntional   Questions

January 16, 2009 · Leave a Comment

 1. What are the application objects that support View Accounting and Drilldown?GL_Import_Reference_Table (modified) For Example Invoices imported from Payables into GL goes to these tables from GL_Inerface table.GL_SL_LINK_IDGL_SL_LINK_TABLEGL_JE_LINES (modified)

New views in the database:FA_AEL_GL_VFA_AEL_SL_MRC_VFA_AEL_SL_V

2. Where in Oracle General Ledger 11i can Drilldown be accessed?You can drilldown from GL Account Inquiry window and the GL Journal Entry and GL Journal Inquiry windows. (N) Tools -> Drilldown Open the Journal entry in GL and go to Tools – drilldown, its shows u the origin of the journal entry. It is used only for viewing the origin of the journal entry.

3. What are the Release 11i Sub-ledger drilldown features?Expanded Subledger drilldown to other subledgers. View Accounting Lines window.

4. What are recurring invoices? What are AP setup steps?Some times suppliers would not be sending any invoices, but still the payment have to be made to him. Ex: rent, lease rentals. In this situation we have to create invoice every period wise. For that purpose we have to create one recurring invoice template. Template means with one master copy creating the

multiple invoices. Here we are creating the one invoice master copy is formally known as recurring invoice or recurring invoice template.Setup: 1) Create one special calendar2) Create one full distribution set3) Enter payment terms in the recurring invoice window4) Enter the template no., first invoice amount, special invoice amounts.Recurring Entries are of 3 types-1. Standard,2. Skeleton,3. Fornulae BasedIn GL Module1.Define Formula Batch (e.g. ABC Rent batch)2.Enter Lines (Here u have both Debit as well as Credit lines)3.Generate Recurring period4.Review Journal Batch5.Post the batch1. Standard Recurring Journal: It is used for same accounts & same amounts e.g.Utilities DrCash Cr2. Skeleton Recurring Journal: It is used for same accounts but for different amounts, e.g.Recurring Fee DrCash Cr3.Formule Based Journal: It is used for different accounts with different amounts, e.g.Salaries DrCash Cr

5. If any conflict occurs in FSG who will override; Column Set or Row Set?The override component is row set. However some times it depend on the column set also.

6. What is the difference between discounts and adjustments? Discount refers to the payment terms or on quantity (bulk order discount) ordered. In the invoice received from supplier, discounts term is specifically stated, e.g. “If paid with in 15 days discount @ 2%”, what you need to do is pay 2% less then the original invoice amount, however caution should be taken that the freight amount should not be considered while calculating the discount. Adjustment could be for various reasons- Over priced invoice, short delivery of quantity as per goods received note, poor quality etc. Agreed upon amount will be deducted from the invoice, while making the payments. In

AR, discount is given to promote the business and cash flow. Adjustments are made to adjust the account balances, which is not possible in other means.

7. What are cycles of GL, AP, and AR? GL Accounting cycle can be further elaborated like this…1. Open Period.2. Create Functional and foreign journal entries.(including the journal import from legacy systems and subledgers).3. Reverse journal entries.4. Post the journals.5. Review and correct the balances.6. Revalue foreign currency balances.7. Translate foreign currency balances.8. Consolidate set of books.9. Run accounting reports.10. Close the accounting periods.

AP cycle ——– Purchase Order –> Receipt –> AP voucher –> Payment madeAR Cycle ——–Sales Order –> Shipment –> Invoice –> Payment receiptGL cycle ——– Direct GL JE / Transfer subledger data to GL –> Post

8. What are Summary Accounts and Rollup groups?Summary Account is an account whose balance represents consolidation of accounts. Rollup group is a collection / consolidation of parent accounts. e.g. Assets is a total of Current assets and Fixed Assets. Current assets / Fixed assets in turn are collection of assets.Summary Account is an account whose balance represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations. Rollup group is a collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.Summary accounts are consolidated balances of accounts and rollup groups is collection of parent accounts.9. What Sub-ledgers does Oracle General Ledger 11i Drilldown support? Accounts Receivable, Accounts Payable and Cash Management. Drilldown from Oracle General Ledger 11i also supports Oracle Purchasing module (displays POs and Requisitions) from 11.5.9 version onwards. Drilldown from Oracle General Ledger 11i is supported for Oracle Payables, Oracle Receivables, Oracle Assets (except depreciation), Projects, Purchasing, Inventory, and Work in Process (WIP). Shivmohan Purohit   

 

 

 

 

 

 

Categories: Application Developer · Interview Questions · Knowledge Base · Oracle AP Functional · Oracle AR Functional · Oracle Applications Technical · Oracle FA Functional · Oracle Fixed Assets Technical · Oracle Functional · Oracle GL Functional · Oracle GL Technical · Oracle Payables Technical · Oracle Receivables Technical Tagged: 11i, accounting, ap, ar, fa, faq, functional, gl, interview, Interview Questions, questions

Oracle Applications Documentation AIM   Methodology

January 15, 2009 · 2 Comments

Oracle Applications – Documentations – Using AIM or Tailored AIM Methodology 

here i am giving brief intro, in next article you can find much details information on AIM documents and reference

Not all companies are using the same AIM instead they are using their own giving different names but the formats of all the documents are more or less same. Each stage is having set of documents. 

First Stage: AnalysisSecond Stage: DesigningThird Stage: Build – DEMO / PROTO TYPEFourth Stage : TestingFifth Stage : Go LiveSix Stage : Post Production 

 

 

 

 

 

Various documents for different scope and criterias such as1.Implementation2.Customization3.Conversions    

 

 

 

Below some brief on mostly used document typesBR Documents : Business Requirement Documents, which is primafaciely done by the Functional Persons of the Implementation Team like Funtional Project Leads / Managers. These documents are the Set up Documents, which is 100% based on the BR 120 – Business Requirement Gatherings as provided by the business. Now as a Funtional Consultant you need to always go for the BR – 100, that is set up document, so BR 100 is the To Be Process after you gather all sorts of info from the Biz and map in the Oracle systems

MD Documents : Modular Designing Documents, which are is primafaciely done by the Technical Persons of the Implementation Team like Technical Project Leads / Project Manager. These documents are the Design Documents, which is again based on the BR 120 – Business Requirement Gathering as provided by the business. These MD’s are of basically discussed any customization needs or any special behaviaour oracle system should work which is not the Standard Oracle Funtionality. These also discussed about the tables and the Interface Tables or forms which are going to be used in the particular modules. Thses also discussed about the High Level Designs like Flows of the Business and all. These MD’s are basically made after you all Functional Design and if there is no work around Oracle System provides for a particular Test Scenario and there is no other way other than to go for the Customization. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MD.70 is technical Document(Technical resource will design), which show all Technical Details like Coding, Maping and Logics. 

 

 

 

 

 

MD.50 is Desgin Document(Functional resource will design), which explore all design methods like its road-map, which includes all design setups.

 

 

 

 

 

 

thanks – Shivmohan Purohit