prashanthkumar
oracle consultant
How to Secure your Wi-Fi Network (or Wireless Internet Connection) Learn how you can secure your wireless network fin simple steps.
You can prevent hackers from intercepting your Wi-Fi network and also avoid casual users from using your wireless broadband connection. This article describes how you can secure your Wireless Network from hackers and you’ll also learn about free tools that people generally use to intercept your Wi-Fi signals. Wireless Networking (Wi-Fi) has made it so easy for you to use the computer, portable media player, mobile phones, video game consoles, and other wireless devices anywhere in the house without the clutter of cables. With traditional wired networks, it is extremely difficult for someone to steal your bandwidth but the big problem with wireless signals is that others can access the Internet using your broadband connection even while they are in a neighboring building or sitting in a car that’s parked outside your apartment.
This practice, also known as piggybacking, is bad for three reasons: Step 1. Step 2. Step 3. Step 4.
Create MySQL Tables. The table creation command requires:
SQL Interview Questions. 1.
What’s the difference between a primary key and a unique key? Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only. 2. SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay. What is responsibility and how u attach. Question I also faced this Question!!
Rank Answer Posted By. Oracle Apps Technical Interview Questions. Oracle Apps Technical Interview Questions Email Details Category: Oracle Apps Interview Questions Created: 22 June 2008 Written by Anil Passi Which is the most commonly used package in apps that uses Autonomous Transaction?
FND_LOG, this is used for debugging.
SQL LOADER part 1. SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded.
SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called log file, bad file or reject file, discard file. Log file tells you the state of the tables and indexes and the number of logical records already read from the input datafile. This information can be used to resume the load where it left off. Bad file or reject file gives you the records that were rejected because of formatting errors or because they caused Oracle errors.Discard file specifies the records that do not meet any of the loading criteria like when any of the WHEN clauses specified in the control file. In Depth Apps - Oracle eBusiness Suite - Gareth Roberts. PL/SQL Tutorial - Exception Handling. 2) Structure of Exception Handling.
General Syntax for coding the exception section Declaration section Exception section WHEN ex_name1 THEN -Error handling statements. SQL Quiz Test. Get Oracle Apps Traning Here. Registering SQL*Loader as a Concurrent Program « Dibyajyoti Koch:A Blog on Oracle Application. The following steps will describe the process to register a SQL*Loader program as a Concurrent Program in Oracle Apps.
Step 1] Create the SQL*Loader Control and Data file and place them in Server(ex: $CUSTOM_TOP/bin). Create or check the interface table structures in the backend. Apps - Concurrent Programs in Oracle Apps. Bill of Materials. Bills of Materials (BOM) are normally accessed according to production or procurement deadlines.
The History Management function allows several types of BOM to be managed simultaneously, and can be operated according to the needs of the customer. Single Level Bills of materials and Multi Level Bills of Material can be generated in eresource ERP. For each manufactured line item on a WO, the system provides a bill of materials (BOM) and routing. In the single Level bill of materials only those subordinate components can be captured that are immediately required to manufacture the product. The multiple BOM concept aids the management of a variety of similar BOMs (variant problem). The advantage of this function is that changes of (data regarding) common components need only be carried out in the Reference BOM-M.
The data of BOMs is automatically shown against the work orders providing the ability to include configured items on a WO's BOM. Toad World > HOME. Welcome to The Oracle FAQ. Java. Auditdll. Asciitab. Plsloop. Countall. Ftpclient. Utlfile. Smtp. Scripts. UTL_FILE. With the UTL_FILE package, PL/SQL programs can read and write operating system text files.
UTL_FILE provides a restricted version of operating system stream file I/O. Using UTL_FILE Security Model. About Oracle Apps: How to use XML Publisher. XML Publisher Concurrent Program - XMLP In this article I have listed a step by step demo of XML Publisher as a Concurrent Program in Oracle Apps. I think it is very important that you get a feel of XML Publisher, as this will become the reporting tool in Fusion [assuming XMLP can become as powerful as Oracle Report in the given time]. Before I explain the steps in details with screenshots, let me brief them:- a.
About Oracle Apps: Oracle Account Receivables (AR) - Functional Overview. Enter Invoices Use this form to enter invoices and debit memos one at a time, or as a group called a batch. Oracle Receivables lets you use batch control totals to ensure that you enter invoices accurately. Whenyou enter an invoice, Oracle Receivables uses your AutoAccounting rules to determine your default general ledger accounts.
Oracle Receivables now lets you assign invoicing and accounting rules to invoices you enter through this form. Use Revenue Recognition Program to control when your accounting distributions are created.You can also use this form to review and update information for your invoice. About Oracle Apps: Basic Concepts in Oracle GL - Part2. 2.8 Consolidation Consolidated Set of Books Consolidation is the period-end process of combining the financial results of separate subsidiaries with the parent organization to form a single, combined statement of financial results.
The Global Consolidation System (GCS) provides the flexibility to help you manage your consolidation needs regardless of your organization structure. Consolidated data is required at the end of year usually when companies prepare their balance sheets. Decide the Global Set of Books Get the Parent SOB and the Subsidiary SOB; keep the Method as Transaction / Balance. Functional Guy- Devendra Gulve. PL/SQL Tutorial - PL/SQL Stored Procedures. General Syntax to create a procedure is: CREATE [OR REPLACE] PROCEDURE proc_name [list of parameters] What are Types of Documents in Oracle Applications : June 2008. Application Implementation Methodology. Application Implementation Methodology:--------------------------------------------------- I have received lot of request from many people asking for the AIM document information. For the best of my Knowledge, I have prepared the following information. If you have any more information related to AIM document, please share it across with Oracle Community.
Application Implementation Methodology in short referred as AIM. AIM- Oracle’s Application Implementation Methodology is a proven approach to implement Oracle Applications. AIM defines an organization’s business needs at the beginning of the project and maintains their visibility through out the implementation. R12 Oracle Application Footprint. Value Set Basics in Oracle Apps R12. Value-set is a group of values.
Supplier Conversion in R12. Supplier Conversion in R12 Vendor conversion program will load the Supplier Master, Sites and Contacts data from data files to the staging tables, validate the data and then load the data into Interface tables, finally Validated data will import into Oracle Supplier Standard Tables by using Oracle Standard Supplier Import Programs. Oracle Apps Technical Manual. Oracle Payables User's Guide. Browser version script Skip Headers This chapter covers the following topics: Submitting Standard Reports, Programs, and Listings Payables provides reports, programs, listings, and notices (all referred to as requests) that you can use to: review information about your suppliers, invoices, and payments.
For information on submitting reports, listings, or request sets, see: Running Reports and Programs, Oracle Applications User's Guide. You can see detailed information on the parameters in the Selected Report Parameters section of the request description, or in Common Report Parameters. If your request has output, you can see detailed information on it in the Selected Report Headings section of the request description, or in Common Report Headings. Workflow tutorial. DataLoader Tutorial. Data Loader: Tool to Export or Migrate Data between MySQL, Oracle, Access, Excel, MS SQL Server, Foxpro, DBF, CSV, Delimited Text Files. Report Builder Documentation - Support Wiki. Unix « Dibyajyoti Koch:A Blog on Oracle Application. Fusion Middleware Documentation Library. Apps - Oracle HRMS Payroll Tables. The GL_INTERFACE Table (Oracle General Ledger Users' Guide)
The GL_INTERFACE table is where Journal Import receives accounting data that you import from other systems. When Journal Import receives this data, it validates and converts your import data into journal entries within your General Ledger application. The GL_INTERFACE table is organized by columns in which your General Ledger application categorizes and stores specific accounting data. For example, journal entry source information is stored in the column called JE_SOURCE_NAME. The GL_INTERFACE table contains the following columns: OracleApps Epicenter. 185 useful Keyboard Shortcuts for Access 2010. DataMiner. Apps - Oracle Workflows Training Lesson 3. Apps - Oracle Workflows Training.
Pearltrees videos. Getting started.