Oracle Ebs Tutorial For Beginners Pdf

Click here to load reader

  • date post

    14-May-2015

  • Category

    Education

  • view

    1.230

  • download

    137

description

www.Magnifictraining.com-oracle apps r12 scm fuctional online training. contact us: [email protected] or call us: +919052666559 oracle apps technologies like oracle discrete manufacturing, oracle apps purchasing training, oracle apps order management training,oracle apps r12 functional training. real time Oracle scm online training by industrail experts for details call:+919052666559 hands on training on oracle online TRAINING. Oracle Apps Technical Online Training Concepts : Introduction to ERP 1.Definition of ERP, Overview of popular ERP’S 2.Comparison of Oracle Apps with other ERP’S 3.Types of Roles 4.Types of Projects 5.AIM documentation standards 6.Oracle Application Architecture. 7.Database structure of OA 8.Using TOAD Application Object Library 1.Creating Users 2.WHO columns 3.Creating Responsibilities 4.Menu construction 5.Request group construction Application development 1.Defining concurrent acara 2.Concurrent programs with parameters 3.Working with multiple concurrent programs 4.Scheduling the Concurrent Program 5.Concurrent Program incompatibilities 6.Creating Request Set 7.Procedure registration 8.Value sets

Transcript of Oracle apps-technical-tutorial

  • 1.1ORACLEAPPLICATIONS 1. INTRODUCTION ERP:ResourcePlanningwithinanEnterprise.ERPisatermthatcoverswholeProduct 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 tosatisfyuniquerequirements. BENEFITSOFERP: 1).FlowofInformationEffectively 2).MaintainingStandardizations Q: WhatisOracleApplications? Ans: OracleApplicationsareanERPPackage.TheKeyFeatureoftheentireoracle ApplicationmoduleisDataIntegration. Master data is Integrated: All the application share common files of customers, suppliers, employee, items and other entities that are used by multiple applications. TransactiondataisIntegrated:Oracleautomaticallybridgetransactionsfromone systemtoanother. Financial data is integrated: Financial data is carried in a common matra, and financialdataistransmittedfromoneapplicationtoanother.

2. 22.ORACLEAPPLICATIONS Oracle Applications is one of the Enterprise Resource Planning (ERP) Business Application packages. It comprises of various Modules, Libraries, Forms, Reports, etc. Oracle Applications is designed on the basis of Generally Acceptable Accounting Principles(GAAP).ItisusedtochattertheBusinessneedsofanOrganization.Itconsists of256differenttypesofmodules,4000Forms,5000Programsetc.AnyOrganizationcan adopt this package and use the supplied modules with the customization as per their businessrequirements. Oracle works on 3 Tier Architecture (i.e. Client, Application and Database). It supports Form based Interface (i.e. FIN, MFG, MM & HR) and HTML based Interface (i.e.CRM,SSWA). Note:SSWASelfServiceWebArchitecture Applications3TierArchitecture Desktop TierApplication TierDatabase TierForms Server Web BrowserReports ServerDatabase ServeriAS Server Concurrent Processing Server Discoverer ServerAdministration Server 3. 3 3.PRODUCTDIRECTORYSTRUCTURE WhenOracleApplicationsinstallsinamachineitcreatesabasedirectorywiththe nameORACLE.Thisisthebasedirectoryforaccessingtheapplication. OracleApplicationssuppliedinthreeflavors 1. ProductionOracleApplications:usedforimplementinginanyorganization. 2. VisionOracleApplications:usedforDemonstrationorTrainingpurpose. 3. TestOracleApplications:usedforR&Dpurpose ProductDirectoryStructureofOracleApplications ORACLEProduction OAVision OATest OAPRODDBVISDBTESTDBPRODORAVISORATESTORAPRODCOMMVISCOMMTESTCOMMPRODDATAVISDATATESTDATAPRODAPPLVISAPPLTESTAPPL VISDB: ConsistsofOracle8i/Oracle9i/Oracle10gDatabaseexecutablefiles. VISORA: Captures8.0.6/9iAS/10giASmiddlewareDatabaseexecutablefiles. VISCOMM:Captures Control Script files, which are used to Start or Stop the ApplicationServices. VISDATA: Capturesall.DBFfiles. VISAPPL: CapturesallModuleSpecificDirectoriesandSomeSpecialDirectories. 4. 4APPL_TOP(i.e.VISAPPL)DirectoryStructure APPL_TOPAPPL_TOP = D:ORACLEVISAPPL GL 11.5.0Forms ReportsAR APUS USBIN LIB SQL HTML Gelondong OUT MessageFND AU 11.5.0 FormsUSResource 5. 5 GL_TOP:(APPL_TOP/GL/11.5.0)isoneoftheModuleDirectoryofOracleApplications. Itconsistsofareleasedirectory(i.e.11.5.0)underwhichForms,Reports,Kacang,LIB,SQL, etc., GL_TOP/11.5.0/Forms/USisformsdirectorytostoreall.FMX(Compiled)Formfilesofa specificmodule. GL_TOP/11.5.0/Reports/US is a reports directory to capture all the .RDF (Compiled) Reportfilesofaspecificmoduledirectory. USisalanguagespecificdirectory. GL_TOP/11.5.0/BINwillcapturetheC,C++,PRO*C,SQL*LOADERetc.,files. GL_TOP/11.5.0/LIBwillcaptureall.OBJfilesofC,C++orJAVACLASSfiles. GL_TOP/11.5.0/Messagewillcaptureall.MSBmessagebodyfiles. GL_TOP/11.5.0/LOGwillcaptureall.LOGfiles. GL_TOP/11.5.0/OUTwillcaptureall.OUTfiles. GL_TOP/11.5.0/SQLwillcaptureall.SQLscriptfiles. GL_TOP/11.5.0/HTMLwillcaptureall.HTML,.HTMwebfiles. GL_TOP/11.5.0/FNDisaSpecialDirectoryknownasApplicationObjectLibrary(AOL) directory.ItisusedtocaptureallModulesApplicationExecutableFiles. GL_TOP/11.5.0/AUisanApplicationUtility(AU)Directory.Itconsistsofaapplication release SubDirectory, which consists of Forms and Resource directories. It is used to storeall.FMBand.PLLandPL/SQLLibraryfiles. GL_TOP/11.5.0/AU/11.5.0/Forms/USwillcapture.FMBFormfilesofallModules. GL_TOP/11.5.0//AU/11.5.0/Resource is used to store .PLL and .PL/SQL Library files of OracleApplications. 6. 64.DATAMODEL WhenweinstallOracleDatabasebydefaultsystemwillcreatesSYSandSYSTEM schemas. These consist of all Data Dictionary Tables. Like this if we install Oracle ApplicationsSystemwillautomaticallycreatesschemasofallModules(i.e.GL,AR,AP, etc.)withtherespectivemodulenameasUserandPassword.Alongwiththeseschemas some special Schemas i.e. APPS, APPLSYS, APPLSYSPUB will be created for special purpose. APPSADMIN Application Administrator GL/GL AR/AR User Schemas AP/AP PPR/PPRAPPLSYS/APPS FND Foundation Tables ALR Alert Tables WF Work Flow Tables AD Application database APPLSYSPUB/PU APPS/APPS APPSSchema:ItisPublicSchema.Itconsistsofacollectionofpublicsynonymofall theobjectsofalltheschemasintheApplicationdatabase.AlltheProcedures,Functions andPackagescreatedmustbestoredinthisSchema. 7. 7APPLSYS Schema: This is a special Schema consists of the files starts with FND, ALR,WFandAD. APPLSYSPUBSchema: This schema is a collection of public synonyms of all FND Tables, which are used for User verification. This is the Gate Way User ID of Oracle Applications. Note:1.WhenwearechangingtheAPPSSchemapassword,firstwehavetochangein thebackendforbothAPPSandAPPLSYSSchemas. 2.PasswordforbothAPPSandAPPLSYSshouldbesame. 3.ChangethepasswordofboththeSchemasinFrontEndandBackEnd. 4. Drop the Concurrent Manager Services and recreate the Concurrent Manager ServicewiththePasswordasAPPSPassword. 8. 85. RESPONSIBILITIESANDUSER Responsibility: It is a role authorized to access specific Forms and Programs of a particular Module. A responsibility is a collection of Menus, Request Groups and Data Groups.MenusandDataGroupsaremandatorytoaresponsibility. Menu:AmenuisacollectionofSubMenusandFunctions. RequestGroup(RG):ItisacollectionofconcurrentPrograms.Itisusedtorequest programsfromtheresponsibility. Data Group (DG): It is a collection of Modules used to integrate one or more Modules for cross application transfer of data, cross application reporting and cross applicationreference.IfwewanttogetdatafromotherModulesweneedtodefinethose modulesintheDataGroup. Functions:Afunctionisapartofanapplicationsfunctionalitythatisregisteredunder auniquenameforthepurposeofassigningitto,orexcludingitfrom,amenu(andby extension,aresponsibility). An Oracle Applications feature that lets you control user access to certain functionsandwindows.Bydefault,accesstofunctionalityisnotrestricted;yoursystem administrator customizes each responsibility at your site by including or excluding functions and menus in the Responsibilities window. There are several types of functions:formfunctions,subfunctions,andnonformfunctions. Thesearetwotypesoffunctions 1 FormFunctions:areusedtosecureFormsfromtheresponsibilities. 2 NonFormFunctions:areusedtosecureLayoutItemswithintheForm. AdvantagesofFormFunctions IfyouwanttoopentheFormindifferentmodeswithoutcreatingthecopies,we can create a Form Function and pass the parameters based on the requirement. The indikator, which is passed in the form function, must be already defined in the form whiledesigningtheForm. AmenucanbeassignedtomorethanoneResponsibility.Ifyouwanttorestrict some of the Forms from a particular responsibility, we can include Form Function of thoseFormsinMenuExclusionsoftheResponsibility. 9. 9PreDefinedResponsibilities S.No 1 2 3 4 5 6Module ApplicationObjectlibrary SystemAdministration OracleGeneralLedger OraclePublicSectorPayables OracleReceivables OracleAlertsResponsibility ApplicationDeveloper SystemAdministrator GeneralLedgerSuperUser PayablesManager ReceivablesManager AlertsManager HowtoCreateaResponsibility? Step1:ConnecttoOracleApplicationwithAPPSADMIN/APPSADMINUser. Step2:GotoApplicationAdministrator. Step3:GotoSecuritythenResponsibilitythenDefine Step4:EntertheDataintheopenedWindow. Note:AboveInformationofResponsibilityisstoredinFND_RESPONSIBILITYTable. 10. 10HowtoCreateaUser? Step1:ConnecttoOracleApplicationwithAPPSADMIN/APPSADMINUser. Step2:GotoApplicationAdministrator. Step3:GotoSecuritythenUserthenDefine Step4:EntertheDataintheopenedWindow. Note:AboveInformationofUserisstoredinFND_USERTable. UserResponsibilitiesstoredinFND_USER_RESP_GROUPSTable. 11. 116.NEWMODULEDEVELOPMENTStepsrequiredfordevelopingaNewModule? 1. RegistertheNewModulewithAOLmodule. SavetheEntries. 2.CreateaSchema/UserfortheNewModuleandGrantRollstoitfromSQLPrompt. Loginasapps/[email protected] SQL>CREATEUSERPPRSIDENTIFIDBYPPRS; SQL>GRANTCONNECT,RESOURCETOPPRS; SQL> 3.CreateproductDirectoryStructuretotheNewModuleatServerend. Orafin8d$applpprs11.5.0formsus Orafin8d$applpprs11.5.0reportsus Orafin8d$applpprs11.5.0bin Orafin8d$applpprs11.5.0sqletc., 4. Create the Form Using Form Builder with all the coding standards required accordingtoOracleApplications. 5. CompiletheFormandCopy.FMXfileinModuleSpecific(New)Directory. 6. Copysome.fmxFormfilesfromanyexistingmodulestonewmoduledirectoryfor registrationdemo. 7. RegistertheformwithApplicationObjectLibrary(AOL)Module. ConnecttoAPPSTECH/APPSTECH GotoApplicationDeveloper 12. 12 Application Form Save&Close 8.CreateFormFunctionforalltheForm,whichareregisteredwithourmodule. ConnecttoAPPSTECH/APPSTECH GotoApplicationDeveloper Application Function Save&Close 9. DefineamenuforournewmoduleusingAOLModule. ConnecttoAPPSTECH/APPSTECH 13. 13 GotoApplicationDeveloper Application Menu 10.AssigntherequiredFormFunctionstothemenus. 11.DefineDataGroup(DG)usingSystemAdministrationModule. SystemAdministrator Security Oracle DataGroup 14. 14 11.DefineaResponsibilityforthenewmodule. SystemAdministrator Security Responsibility Define 12.AssignResponsibilitytotheUser. SystemAdministrator Security User Define 15. 15 13.SetupthebasepathoftheNe

Source: https://fdocuments.in/document/oracle-apps-technical-tutorial-5584a03c9cef9.html