GL Account Balance: The below SQL gets the beginning balance and ending balance of the specified GL Account for a giver ledger and period.
Note: Firefox is partially supported to view this video. You can view the video in IE, Chrome, Safari.
Companies might have to transfer material from one warehouse (inventory organization) to other warehouse depending on the current on-hand stock and demand at each location. Oracle ERP provides a couple of ways to achieve this requirement. 1) Internal requisition to internal sales order 2) Inter Organization Transfer ( I have covered this in another article) […]
Overview: JSP allows the embedding of servlet code within HTML pages. As part of the Java technology family, JSP technology enables rapid development of Web-based applications that are platform independent. JSP technology separates the user interface from content generation, enabling designers to change the overall page layout without altering the underlying dynamic content. In […]
The following topics will be discussed in this article: Overview of CALL_FORM.(Instead of call_form, we use fnd_function.execute in oracle apps) Steps for Development of Calling Form(XXPO_VENDORS.fmb). Steps for Development of Called Form(XXPO_VENDOR_SITES.fmb). Called Form Registration in Oracle Applications 11i (XXPO_VENDOR_SITES.fmb). Calling Form Registration in Oracle Applications 11i(XXPO_VENDORS.fmb). 1. Overview of CALL_FORM: (In Oracle Applications, we […]
Get details of concurrent requests which are running currently and also the script will provide details of who is running the request and from which responsibility
What is Oracle Fast Formula? Oracle Fast Formula is a simple way to write formulas using English words and basic mathematical functions. You can use information from your database in formulas without learning the database structure or a programming language. You can use Oracle Fast Formula to: 1.Calculate your payrolls 2.Define the rules for PTO […]
How to secure the documents in XML/BI Publisher : This is a very simple article. If you start comparing Oracle report with XML/BI publisher report then you can see some key limitations of Oracle reports that are overcome by BI Publisher Reports. Securing the output of a program is one among them .It is very […]
Oracle Business events are like Triggers. So we have event (Business event) based on which an action can be performed. There are two kinds of business events 1)Oracle provided business events / Seeded Business Events 2) Custom Business Events, which we create as per our business needs.
In most of the cases we just need to create an action for a seeded business event. Oracle Corp knows most of the business requirements and they have provided us with many seeded business events which are ready to use.
Overview: Database Adapter is a partnerlink in BPEL which is used to interact with Database for read, write operations. Using Database Adapter we can perform the following functions. 1.Call a Stored Procedure of Function 2.Perform DML operations like insert, update, delete on a table 3.Perform SELECT operation 4.Execute custom SQL Statements In this Article I […]