NVL2 Function NVL2: check for the existence of NOT NULL Most of us are familiar with the NVL function which checks for the existence of NULL values. Oracle provides a new function called NVL2 which checks for the existence of NOT NULL. The syntax for this function is as follows. NVL2(expr1,expr2,expr3); If expr1 is not … Read more
ORACLE BULK COLLECT Oracle uses two engines to process PL/SQL code. All procedural code is handled by the PL/SQL engine while all SQL is handled by the SQL statement executor, or SQL engine. There is an overhead associated with each context switch between the two engines. If PL/SQL code loops through a collection performing the … Read more
Dive into to know Auto Lockbox Mechanism : AR LOCKBOX APPROACH Now to know how Auto Lockbox is actually implemented in a step by step approach Dive into: Auto Lockbox Process Implementation Thank You……..
Here is the link to refer for the Basic’s of UNIX SHELL Script : Click it to view in detail Basic Commands for UNIX SHELL Scripting Please feel free for any suggestions or comments which would be highly appreciated.
VMI (VENDOR MANAGED INVENTORY) Whenever the inventory quantity falls we opt for planning methods to increase the quantity. But if we want to outsource our inventory management to our supplier so that once the quantity falls short of certain level the supplier would be creating the release then wither he approves it or we would … Read more
Receipt Routing Receipt Routing are of three types Direct, Standard and Inspection In Direct once the goods arrive at the gate we directly move them to Sub-Inv, in Standard once the goods are at gate we receive it at the receiving point first and then move them to the Sub-Inv and finally in Inspection once the … Read more
Structure of Standard PO PO Headers PO Lines PO Shipments PO Distributions Each Line can have one or more PO Shipments, Each PO Shipment can have one or more PO Distributions. Some total of PO Distributions should be equal to Shipment Qty, Sum total of PO Shipment line should be equal to … Read more
Purchase Order (PO) Based on the details that are available the different types of PO are created as below PO Types/Requirements ITEM Details Qty Details Price Terms Delivery Schedule Standard PO √ √ √ √ √ Planned PO √ √ √ √ X Blanket Purchase Agreement √ X √ √ X Contract Purchase Agreement X … Read more
MOAC (Multi Org Access Control) MOAC is a feature used to access the data of multiple organizations or multiple operating units from a single responsibility. Data security is maintained using security profiles that determine the data access privileges associated to responsibilities granted to a user. Because of this you can perform multiple tasks across operating … Read more
Inventory Transactions Below are the different types of transactions that can be created in Inventory Miscellaneous Move Order Inter-Org transfers Account alias issue and receipt Miscellaneous Transactions are used to create adjustments for the missing or any in-accurate transactions. Responsibility: Inventory Vision Operations or MM INV Change the organization to MIP (MM INV PUNE) as … Read more