Entries by Oracle ERP Apps Guide

, , , , , , , ,

Oracle R12 Create Order using APIs

DECLARE   PROCEDURE create_move_order   IS      l_hdr_rec         inv_move_order_pub.trohdr_rec_type              := inv_move_order_pub.g_miss_trohdr_rec;      l_line_tbl        inv_move_order_pub.trolin_tbl_type              := inv_move_order_pub.g_miss_trolin_tbl;      x_return_status   VARCHAR2 (1);      x_msg_count       NUMBER;      x_msg_data        VARCHAR2 (4000);      x_hdr_rec         inv_move_order_pub.trohdr_rec_type              := inv_move_order_pub.g_miss_trohdr_rec;      x_hdr_val_rec     inv_move_order_pub.trohdr_val_rec_type;      x_line_tbl        inv_move_order_pub.trolin_tbl_type;      x_line_val_tbl    inv_move_order_pub.trolin_val_tbl_type;      v_msg_index_out   NUMBER;      l_rsr_type        inv_reservation_global.mtl_reservation_tbl_type;   BEGIN      l_line_tbl.DELETE;      x_line_tbl.DELETE;      mo_global.set_policy_context (‘S’, 204);      inv_globals.set_org_id (207);      fnd_global.apps_initialize (1005902, 50583, 401);      l_hdr_rec.date_required := SYSDATE;      l_hdr_rec.header_status := inv_globals.g_to_status_preapproved;      l_hdr_rec.organization_id := 207;      […]

/by
, , , , , , , , ,

R12: Create, Allocate and Transact a Move Order using APIs

Move Orders in Oracle provide good functionality for approval based movement of material with in an inventory organization. Move Order Approvals use a workflow (INV: Move Order Approval) for approvals and hence provide flexibility to extend it for approvals. Move Orders can be created from different sources. These move orders are identified by Move order […]

/by
, , , ,

What are Business Events in Oracle Apps?

Business event is, as the term means, is simply an event that occured in business. Business is all about people taking decisions in their respective functions on the information available at that time and communicating further down the supply chain as quickly and accurately as they can: Upon order booking warehouse ships the order or […]

/by
, , , , , ,

What is under one item type in workflow?

While debugging a workflow issue, it is a little cumbersome to connect to the database in workflow builder to check the code behind an activity. Below sql prints all the runnable processes and activities in that process along with the pl/sql functions behind each of them in sql*plus for a given item type. Just pass […]

/by
, , ,

SLA functionality

A good part of SLA functionality is deriving correct account based on business rules. This functionality is called defining account derivation rules. The outcome of accounting derivation rule sometimes is an entire account (famously known as code combination) or simply a segment in the code combination. If only a segment is derived then each of […]

/by