Oracle Apps World

Application Implementation Method is a proven approach, which specifies all the activities which are required to implement oracle applications successfully. The scope of the AIM is enterprise wide . There are eleven processes of implementation. 1. Business Process Architecture[BP] This phase explains: - Existing business practices - Catalog change practices - Leading practices - Future practices 2. Business Requirement Definition[RD] This phase explains about the Base line questionnaire and the gathering of information. 3. Business Requirement Mapping[BR] In this phase we can match all the requirements of business with the standard functionality of the oracle applications. If all the requirements match with oracle standard (with out customization) functionality then, it is called as vanilla implementation). 4. Application and Technical Architecture [TA] Explains the infrastructure requirements to implement oracle applications. For example: - desktops - software - hardware ...

The AIM Documents list.............. Business Process Architecture (BP) BP.010 Define Business and Process Strategy BP.020 Catalog and Analyze Potential Changes BP.030 Determine Data Gathering Requirements BP.040 Develop Current Process Model BP.050 Review Leading Practices BP.060 Develop High-Level Process Vision BP.070 Develop High-Level Process Design BP.080 Develop Future Process Model BP.090 Document Business Procedure Business Requirements Definition (RD) 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 Business Requirements Mapping BR.010 Analyze High-Level Gaps BR.020 Prepare mapping environment BR.030 Map Business requirements BR.040 Map Business D...

TOAD is powerful development tool to build an advanced SQL/PLSQL . Using TOAD, developers can build and test PL/SQL packages, procedures, triggers and functions. You can create and edit database tables, views, indexes, constraints and users. Simply, the GUI object browser provide quick access to database object. You can download the TOAD software from the below mentioned link: http://www.toadsoft.com/

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads. One can load data into an Oracle database by using the sqlldr (sqlload on some platforms) utility. Invoke the utility without arguments to get a list of available parameters. SQL*Loader ( sqlldr ) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database. The below mentioned diagram depicts the SQL*Loader architecture. SQL*Loader reads a data file and a description of the data which is defined in the control file. Using this information and any additional specified parameters (either on the command line or in the PARFILE), SQL*Loader loads the data into the database. During processing, SQL*Loader ...

Data load is the tool to Load data into any application running in Windows, and contains extra functionality for loading data and setup into Oracle Applications. Means we can load data through front end forms. To load data using Data Load you setup Data Load to load into the forms and the forms load the data into your system. Non technical users can also use this tool. You can download the DataLoad software from the below mentioned link: http://www.dataload.net/

Before year-end carry forward of encumbrance followings will be carried out; Post outstanding encumbrance journal entries in Oracle GL. Post outstanding budget journal entries in Oracle GL. Post outstanding actual journal entries in Oracle GL. For Year-End Carry Forward of encumbrance following tasks will be carried out; Run “Encumbrance Details Report” in Oracle Purchasing to review Purchase Orders and Purchase Requisitions against encumbrances. Run Program creates journals. Post encumbrance journal entries. Run Encumbrance Trial Balance for audit trail of encumbrance before year-end carry forward in Oracle GL. Run “Open Encumbrance Balance with Transaction Detail Report” to create an audit trail of encumbrance balances in Oracle GL. Close the last period of the current fiscal year. Open the first period of the next fiscal year. Open the next encumbrance year. Open the next budget year. Run “Year-...

You cannot close a period in Payables if any of the following conditions exist: - Outstanding payment batches : Confirm or cancel all incomplete payment batches. - Future dated payments for which the Maturity Date is within the period but that still have a status of Issued. - Unaccounted transactions: Submit the Payables Accounting Process to account for transactions, or submit the Unaccounted Transaction Sweep to move any remaining unaccounted transactions from one period to another. - Accounted transactions that have not been transferred to general ledger: Submit the Payables Transfer to General Ledger process to transfer accounting entries. To complete the close process in Payables: 1. Validate all invoices. Run Invoice Validation Concurrent program. 2. Confirm or cancel all incomplete payment batches. 3. If you use future dated payments, submit the Update Matured Future Dated Payment Status Program. This will update the status of matured future dated payments to Negotiable s...

After completing this document, you should be able to understand the accounting entries generated by the system during procure to pay cycle. · When Inventory / Material is in Transit · When Inventory is delivered to the Inventory Sub Stores · When Invoice is booked / recorded · When Payment is made · When Reconciliation is made ENTRY 01: When Goods / Material Are In-Transit Or When We Receive Inventory, The Following Accounting Entry Will Be Generated. Description Dr. Cr. Receiving Inventory Account xxxxx Inventory AP Accrual Account xxxxx There are two inventory Organizations: · Receiving Organization · Inventory Organization When the inventory is received at Receiving Organization then the above entry will be generated. Receiving of ...