testoag

What is Implementation, Upgradation, Migration, Reimplementation, Rollout, Support in terms of Oracle Apps R12  or Difference between Implementation, Upgradation, Migration, Reimplementation, Rollout, Support in terms of Oracle Apps R12  Here are some of Important and frequently use Terminology in Oracle Apps EBS Listed below -: Implementation Upgradation Migration Reimplementation Rollout Support 1- Implementation - First-time implementation or fresh implementation of Oracle application on the server is called Oracle Implementation. 2- Upgradation - Upgrade Any lower version into its higher version is called Oracle Apps EBS Upgradation e.g 11i - R12(12.1.1) or R12 (12.1.1) to R12 (12.2.4). 3- Migration - Migrate some of the Selected data from one instance to another instance as per business requirement is called Migration of Data. 4-  Reimplementation - Somehow fresh implementation is not working properly or  it is not suitable for the business then again...

TNSNAMES.ORA entry to runs Oracle Application R12 at local Host  OR  TNS Entry steps to runs Oracle Application R12       Please follow the given steps -: 1- Go to  Host Desktop Screen  2- Press Home key + R and Type 'drivers' Then Press Enter. 3- Now Go to Folder etc < Hosts Then Then In the Host File please make an entry for - IP Address   |   Hostname   |  SID As - 192.168.1.5  ebs.example.com  EBSDB Important -:  Default setup for Oracle Vision Instance to connect database and Application  Host -  Host IP Address -   192.168.1.5  (It will be different as per network accordingly) Port -  Port Number       - 1521 SID -   Service Identification  -  EBSDB Note - You can also Explorer the path directly. Follow the given below directory for the same. C:\Windows\System32\drivers\etc “A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solut...

Definition of Lookup in Oracle Apps R12 Or What is Lookup in Oracle Apps R12? Or What is the main purpose of lookups in Oracle Apps R12? The main purpose of a lookup is to keep programs flexible and easier to configure. Lookups are an approach of creating a configurable “list of values” in E-Business Suite. One of the simplest examples of a lookup type is gender. A “gender lookup” will have definitions as shown next: Code       Meaning M             Male F              Female U             Unknown Suppose that there is a table for employees named PER_ALL_PEOPLE_F and it has the following columns: FIRST_NAME LAST_NAME DATE_OF_BIRTH GENDER The screen that displays an employee’s gender will display a value of Male, Female, or Unknown. However, the database column PER_ALL_PEOPLE_F table. GENDER will store a value of M, F, or U. Hence, the screen displays the meaning, whereas the dat...

What are the differences between system, extensible, and user lookup types in Oracle Apps R12? OR Type of Lookups in Oracle Apps R12 User Updating of the start date, end date, and enabled fields are allowed Deletion of codes is allowed Updating of the tag is allowed Insertion of new codes is allowed Extensible Insertion of new codes is allowed Updating of the start date, end date, enabled fields, and the tag is allowed  only  if the code is not 'seed data' Deletion of codes is allowed  only  if the code is not 'seed data' Updating of the module is  not  allowed Deletion of lookup type is  not  allowed System Insertion of new codes is  not  allowed Updating of the start date, end date, and enabled fields are  not  allowed Deletion of codes is  not  allowed Updating of the tag is  not  allowed Updating of the module is  not  allowed Deletion of lookup type is  not  allowed For more detail...

How can add a month in the calendar or defining new fiscal year in oracle apps R12   Or How can add an Adjustment Period in Calendar  Go to General Ledger ,Vision Operation (USA) < Setup  Then Setup < Financials < Calendars < Accounting Now Query (F11) "Accounting"  then press Ctrl + F11  Now Go to File < New and add a new line Accordingly. Fill all mandatory field as required. Now Save  Finally, Your's Month added in Calendar. Note -:  Use the following Query to check the status of the Periods Details accordingly : select a.period_name,        a.period_num,        a.gl_status,        b.po_status,        c.ap_status from    (select period_name, period_num,      decode(closing_status,'O','Open',                           'C','Closed',       ...

How can Open Oracle Apps General Ledger Period in Oracle Apps R12 Or  Step to Open Oracle Apps General Ledger  Period   in Oracle Apps R12 Note -: Whenever you do Receive inventory transactions, you often get errors if your Inventory/ purchasing/ GL periods are not open. Here is the navigation where you can set up the periods for your material receipts: Go to Setup > Financial > Accounting > Open and Close periods -OR- Setup > Open and Close periods Click On Open/Close  Select Ledger Name and Period Accordingly  Click On Open Periods  Choose Target Period  Once Check the Concurrent Program Status. Now Your's General Ledger Period Opened.  Ensure that the  GL Period has Open status. How can Open Oracle Apps Inventory  Period   in Oracle Apps R12 Or  Step to Open Oracle Apps Inventory  Period   in Oracle Apps R12 Go to Inventory >  Accounting close cycle > Inventory Accounting Periods Choose Re...