Monday, October 01,

1.

In Release 11i, a user assigned to an Operating Unit (OU) would process data from the products deployed in that OU. To process data for another OU, a user would log out of the first and into the second. The data generated in that OU would be accounted for according to rules generated by various product accounting engines, and posted to general ledger in ways appropriate for the different products, some generating part of the detail at different times in the process. General Ledger sets of books (Sob) were self-contained, reflecting the balances of the entity to which you’d assigned the Sob, and managed by users assigned to the Sob.

In Release 12.0, by contrast, users can be assigned to multiple operating units, and are supported by processes and transactions that can span operating units. Their data is book-kept according to rules stored in a single accounting engine,and the accounting is stored in subledger tables that are standard across all products. Complete accounting is maintained for every appropriate event, and all subledger entries are fully balanced and detailed. A single, common posting engine summarizes to your required level of detail, and posts to General Ledger.Sets of Books are replaced by the accounting entity’s ‘ledger’ for data, and its ‘Ledger Set’ for processing, from reporting, opening and closing, through allocations. Ledgers can be combined into ledger sets, and GL users are assigned to the ledger sets. User access to multiple operating units is called ‘Multi-Org Access Control’,(MOAC).

2. Multi-Org Access Control (Changed functionality): Multi-Org Access Control enables companies that have implemented a Shared Services operating model to efficiently process business transactions by allowing them to access, process, and report on data for an unlimited number of operating

units within a single applications responsibility. This increases the productivity of Shared Service Centers, as users and processes no longer have to switch applications responsibilities when processing transactions for multiple operating units at a time. Data security and access privileges are still maintained using security profiles that now support a list of operating units.

5. Multi-Org Integration with Accounting Setup Manager:(New functionality) The Accounting Setup Manager is a central location to define your accountingrelated setup across all financial applications. Here, you can define your legal entities and their accounting context, which includes the ledgers that will contain the accounting data for each legal entity. Multi-Org is integrated into the Accounting Setup Manager such that users can define operating units and their relationship to ledgers. For each operating unit, users can also select a legal entity to provide a default legal context during transaction processing. This centralizes your setup and makes it easier to inquire on and maintain relationships between ledgers, legal entities, and operating units.

6.GL Accounting Setup- Simultaneous Accounting for Multiple Reporting Requirements:(New functionality) Companies that are global in nature and that have operations in different localities often have multiple reporting

requirements. These companies and their subsidiaries often need to satisfy the accounting and reporting requirements for each country as well as those of the parent company. This involves performing accounting in accordance with accounting principles and standards of multiple countries and in different currencies, charts of accounts, and/or calendars. The

reporting requirements can also be statutory in nature, and one subsidiary may even need to satisfy multiple sets of statutory requirements. Oracle General Ledger simplifies the simultaneous management of the accounting for all of these different reporting requirements in this latest release. You are able to define your legal entities and the setup needed to address each accounting and reporting requirement using the Accounting Setup Manager. New enhancements and integration with Subledger Accounting enable Oracle General Ledger to perform accounting for all reporting requirements of a legal entity simultaneously.

7. Centralized Accounting Setup(New feature): The Accounting Setup Manager is a central location to define your accounting-related setup across all financial applications. Here you can define your legal entities and their accounting context, which includes the ledgers* that contain the accounting data for each legal entity. If a legal entity has multiple reporting requirements, you can include additional reporting currencies or ledgers in the accounting context to satisfy the additional requirements.

8. Enhanced Reporting Currency Functionality (Changed functionality) : Multiple Reporting Currencies functionality is enhanced to support all journal sources. Reporting sets of books are now simply reporting currencies. Every journal that is posted in the primary currency of a ledger can be automatically converted into one or more reporting currencies. This conversion can be performed by Subledger Accounting, to convert all subledger journal entries, or by General Ledger, to convert more summarized General Ledger journals. You can choose to convert any journal sources and

categories.

Can access multiple legal entities and ledgers when you log into Oracle General Ledger using a single responsibility. This improves processing efficiency by reducing the need to switch between responsibilities when trying to access data for different ledgers or legal entities.

10.Simultaneous Opening and Closing of Periods for Multiple Ledgers: (New feature) The Open and Close Periods Programs have multiple enhancements. You are able to run any of the Open and Close Periods Programs from the Concurrent Manager. This allows you to take advantage of scheduling and request set capabilities for greater processing efficiency. Also, if you manage multiple

ledgers, you can open or close periods for multiple ledgers simultaneously. You can even keep the status of periods across multiple ledgers in synch with new programs that ensure a specific period is Open or Closed for all of the ledgers you manage.

11. Cross-Ledger and Foreign Currency Allocations:(New feature) You are able to allocate financial data from one or more ledgers to a different target ledger. This enables you to perform cross-ledger allocations, which is useful for purposes such as allocating corporate or regional expenses to local

subsidiaries when each entity has its own ledger. This is possible even if the target ledger is in a different currency than the source ledger(s) because you can create allocations in foreign currencies. Foreign currency allocations are also useful within a single ledger if you need to allocate amounts to a currency that is different from the primary currency of a ledger.

12. Simultaneous Currency Translation of Multiple Ledgers (New functionality) If business manages multiple ledgers; you can run the Translation program for multiple ledgers simultaneously.

REATING CUSTOM TOP IN ORACLE APPS

You can create custom top in oracle application using following Process

.

Cd $APPL_TOP

Step 2: Create Custom Top Under APPL_TOP Dir Mkdir XXCUST_TOP (Exactly Product Directories)

Make sure all the files and Directories are same as Other Product Dir. Step 3: Add Custom Top entry in APPLSYS.env file

Step 4: Login Oracle apps using Sysadmin or AOL Navigate: Applications->Register

Add your Custom top Entry Here Application: XXApplication name Short name: XXCUST

BasePath: XXCUST_TOP Description: XXApplication.

Step 5: Restart the Internal Concurrent Manager (ICM) So that New Changes will recognize. Step 6: Finally Check Custom Entry in

Select BASEPATH,PRODUCT_CODE,APPLICATION_SHORT_NAME From fnd_application

Where application_Short_name like 'XXCUST_TOP%'

1) Open the workflow Builder 2) Click on choose file

3) Select database radio button and connect to database 4) Select the item type you want to display in object Navigator Then it loads selected Wf Item type in workflow object navigator 5) Select item type in Navigator

6) Choose file menu and click on shortcut

Then it will ask you creating short cut on Desktop click on

7) Go to desktop select the wft file right click on that go to properties You can see the text in target box like this

C:\OraWf\bin\WFBLDR.EXE -C "apps@visr12" -E "AZNM007"

8)Change the text from C:\OraWf\bin\WFBLDR.EXE -C "apps@visr12" -E "AZNM007” to C:\OraWf\bin\WFBLDR.EXE -C "apps/apps@visr12" -E "AZNM007" and click on ok Button 9) Finally Double click on wft file it wills automatically connected to Database

Note: Repeat same steps to SQLPLUS .

Select PLUS80w.exe go to properties change the target text box value. Ex: C:\orant\BIN\PLUS80W.EXE apps/apps@DBNAME

posted by Rama at 4:19 PM | 0 Comments