20091009

What are Types of Documents in Oracle Applications :

AIM (Application Implementation Maintenance) developed by Oracle Applications.MD050 - Module Design - By Functional ConsultantsMD070 - Technical Document Design - By Technical ConsultantsMD020 - Testing Document Design ...



Account Payables -> Account Payables Flow:

Account Payables -> Account Payables Flow:PO -> Receipt -> AP -> GLInvoice -> Payments-> Move Transactions from AP to GLIn AP there are 2 Thumb rules.• Without supplier there is no invoice.• Without invoice there is no payment.Invoice Types:1. Standard: We will make all the payments based on the standard invoice. It will have the...



Which are Concurrent Executables in Oracle Apps? How many Types of Concurrent Programs?

There are 11 types of executables1. Reports - .rdf2. SQL * Plus - .SQL3. PL/SQL Procedures - .pkb / .pks4. SQL * Loader file - .ctl5. Java Structured Procedure - .java / .class6. Host(UNIX) - .sb7. Spawned8. Immediate9. Java Concurrent Program10. Request set stage Function11. Multi-Language Function.Note: Once moving are programs to Oracle Applications...



What is SQL* Loader?

SQL*loader is one of the Oracle tool which will be used to transfer the data from Flat-File to oracle Database table. We can find the fallowing files in SQL*loader1. Flat or Data File2. Control File3. Bad File4. Discard File5. Log FileFlat Or Data File: This file contains the records in a special format; these records will be fetching for other legacy....



What is Value Sets? What are Types Of Value Sets?

Oracle Application Object Library uses values; value sets and validation tables as important components of key FLEXFIELDs, descriptive FLEXFIELDs, and Standard Request Submission. This section helps you understand, use and change values, value sets, and validation tables. When you first define your FLEXFIELDs, you choose how many segments you want...



Navigation Path for Value Set Creation?

Navigation Path for Value Set Creation:Application-> Validation -> Set.Once we create Independent & Dependent valueset then we can attach values to the valueset by using the following Navigation.Application -> -> Validation -> Values (To create values for value set)NOTE: Once we attach any value...



Navigation Path for Value Set Creation?

Navigation Path for Value Set Creation:Application-> Validation -> Set.Once we create Independent & Dependent valueset then we can attach values to the valueset by using the following Navigation.Application -> -> Validation -> Values (To create values...



What are Steps for Report Development in Apps?

Steps for Report Development....1. Develop the report as per client requirement using the Report-6i tool.2. Move the report (.rdf) file from local machine to respective path in the server. If client have the CUST_TOP then move into Cust_Top else move it to the related Standard Top.Custom Top - CUST_TOP/ 11.5.0/ Report/ US/ .rdf Standard Top - PO_TOP/...



How to Develope Report with out Parameters?

How to Develope Report with out Parameters? Developing Report with out Parameters:To develop any report in Report-6i tool, select “Build a new Report Manually” option.Select SQL query object and write the Select Statement.It will ask the Database connection. Provide User id, Password and Connection string (DB host) – APPS/APPS@ORCL.Create Layout...



Standards for Report Developments in Oracler Apps

What Are Standards for Report Developments in Oracler Apps?Oracle Applications Standards for New Report Developments...For developing a Report in Oracle Applications we should follow three standards.1. Creation of Bind Variable - P_CONC_REQUEST_ID: We must create a Bind Variable called “P_CONC_REQUEST_ID” (We can’t change this name. It is standard...



20091004

Oracle Apps Installation

1) Oracle Applications 11i (EBS - 11i) Installation on windows.2) Oracle Applications R12 (EBS - R12) installation on windo...



Oracle Apps 11i Installation on Windows

1) Prerequisites 2) Apps Installation on Windows Server 2003 or Windows...



Prerequisites for EBS - 11i installation

1) Computer Name and Domain setting 2) Create a loopback adapter3) Install MKS Tool Kit4) Install Visual Studio ...



Create a Loopback adapter

1) Open Control panel and open Add hardware wizard2) Click on Yes,I have already connected the hardware and click next.3) scroll down and click on click on add a hardware and click next4) Click on Install the hardware that I manually select from a list and click next5) Select Network adapter from list and click next.6) Click on Microsoft loopback adapter...



Computer name and Domain setting.

1) Open Control pannel. Double Click System.2) Click on computer name tab,click on change button to chage the computer name and domain.3) Give computer name and click more button to change domain.give the domain name inDomain_Name.com format and click ok4) Restart the computer for the changes to take effe...



Oracle EBS - 11i Installation on Windows NT

Go the Stage drive and double click the rapidwiz.exe file in the Stage\startCD\Disk1\rapidwiz directory. The below window appears. Click next button to continue.click next button.If you have configuration file, select Yes and specify the file name.In a single-node installation, the RDBMS, the core AD directories and productdirectories, and the concurrent...



20091003

Download Links

Download Links-------------------Oracle SQL DeveloperForms & Reports 6iXML PublisherPuttyDeveloper suite 10g (Including reports, forms, Jdeveloper):BI PublisherWorkflow Builder Discoverer Desktop Oracle Database 9i Oracle Database 10g Oracle Database 11gOracle Applications 11i and ...



AP Module

AP ModuleIn this session you will find all the ready scripts available for the AP Module.P2P Query based on the Purchase Order NumberSummary Hold information based on the Invoice NumberDetail Hold information of the Invo...



Summary Hold information based on the Invoice Number

AP Summary Hold information based on the Invoice Number:-------------------------------------------------------------------------When we Purchase some material/Goods/Items from Vendor/Supplier, after receiving the material. Vendor would send the INVOICE (In other words we receive BILL for the Items you have received). And payment will be done automatically....



Detail Hold information of the Invoice

AP Detail Hold information of the Invoice:---------------------------------------------------When we Purchase some material/Goods/Items from Vendor/Supplier, after receiving the material. Vendor would send the INVOICE (In other words we receive BILL for the Items you have received). And payment will be done automatically. If there is some Discrepancy...



GL Module

Journal BalancesAutopost DefinitionsBalances and MovementsCode Combinations CCIDCVR Cross Validation Rule OverviewCVR Cross Validation Rule Detail ListingFlexfield Security Rule AssignmentsFlexfield Security Rule DefinitionsFSG Report and Components OverviewInterface SummaryInterface DetailsJournal Header SummaryJournal Line Based Trial Balance ReportJournal...



Scripts

PO ModuleGL ModuleINV ModuleOM ModuleAP Mod...



OM Module

This section is design for ready scripts for the OM module.Order Line is Invoiced or notIdentify the items at Item Category level against active modifiersIdentify the items at Price-list level against active modifiersGet the Modifier details of particular item (only at the Line Level)Install Base creation for all the Sales Order for which it is missingHard...



Hard Reservation for Standard Sales Order line against Purchase Order

Hard Reservation for Standard Sales Order line against Purchase Order Hard Reservation for Standard Sales Order line against Purchase Order:--------------------------------------------------------------------------------------Note:- You need to have the ASCP Module Installed for the following script to work.Note:- ASCP decide whether it have to...