This article illustrates the steps to be followed to Email a concurrent program’s output. Write a procedure that will submit the concurrent program whose output has to be sent as an Email and once the program completes, send the output as Email using UTL_MAIL.send_attach_varchar2. Register this procedure as a concurrent program so that this program […]
This script can be used to read data from a flat file and insert into a table. UTL_FILE Read
API: ARP_NOTES_PKG.insert_p to create new AR Notes API: ARP_NOTES_PKG.update_p to updated existing AR Notes Few SQL Queries related to this API Verify from Applications Navigation: Receivables, Vision Operations > Transactions > Transactions Query your transaction and go to “Notes” tab
Sub Inventory: Logical classification of inventory material is done through sub inventories. Sub inventory is like a group to classify different types of material like “Raw Material”, “Finished Goods”, “Staging”, “Stores” etc. We move material across sub inventories in various scenario’s. for example to ship a sales order we move material from FGI to Staging […]
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: DBMS_XMLSTORE API / Package enables DML operations to be performed on relational tables using XML data. Steps to use DBMS_XMLSTORE: 1. Create a context handle by calling function DBMS_XMLSTORE.newContext and supplying it with the table name to use for the DML operations. For case sensitivity, double-quote (“) the string that is passed to the […]
Application: Order Management Process: pply Sales Order Hold Objectives: To create Sales Order Holds. To apply Sales Order Holds. To view Sales Order Holds. Prerequisites: Hold Types have been defined. Workflow items and activities have been defined. Transaction Order and Line Types have been defined. Responsibilities have been defined. Release Reasons have been defined. For […]
This articles contains all the table information related to Oracle Workflows and queries joining these tables. WORKFLOW TABLES LIST OF ACTIVITIES FOR AN ITEMTYPE Accepts Workflow itemtype / shortname as input parameter and will all the activities involved along with the status and user name to whom the current activity is assigned. TO FIND FROM […]
Overview: Develop a report to register as a concurrent program Create Executable: Link it to Report file(.rdf) created Create Concurrent Program: Link to it executable defined in previous step Enter Parameters and link Value Sets Assign the registered Concurrent Program to a request group Creating Executable: Navigation: Login into Oracle Applications –> Go to Application Developer Responsibility […]