If we want to run the SQL script from the Concurrent Program window then we should follow the below steps.1. Develop the SQL*plus (.SQL)2. Transfer the SQL script file (.sql) file from local machine to the server in to respectable path CUST_TOP/11.5.0/SQL/.SQLThen we have to follow the steps to implement (to run from Concurrent Program […]
PL/SQL Stored Procedures :If you want to make a PL/SQL procedure as a Concurrent Program, then we will define that procedure by using fallowing syntax Syntax:CREATE OR REPLACE PROCEDURE Procedure_Name(errbuf OUT VARCHAR2,recoded IN VARCHAR2,x IN NUMBER,y IN NUMBER) ASBEGINPL/SQL statements;Fnd_file.put_line (fnd_file.output, ’message’variables);Fnd_file.put.line (fnd_file.log, ’message’variables);END ; ERRBUF: Used to get the error messages in to the […]
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. Which files in SQL*loader?1. Flat or Data File2. Control File3. Bad File4. Discard File5. Log File What is Flat Or Data File: This file contains the records in a special format; these […]
Functional Training of Purchase Order FlowWhat is flow of PO: Step 1:We will be raising the Requisitions for the items which are needed. Requisition is 2 types • Internal Requisition • PurchaseInternal Requisition is used when we are getting the items from one organization to another organization of the same business group.Purchase Requisition is raised […]
Training of Account Payables -> Account Payables Flow:PO -> Receipt -> AP -> GL Invoice ->; 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. How many types of Invoices and What are Invoice Types:1. Standard: We will […]
Recent Comments