Doyen Domains

Blog Archives

Follow us on

Total Page Views

1,202 views

Program for Return to Vendor in Oracle purchasing

Program for Return to Vendor in Oracle purchasing

Return to Vendor of Purchase Order Receipts Script: Oracle EBS R12 Return to Vendor is done in two steps: "Return to Receiving" and  then "Return to Vendor". Follow below steps to return the received goods to vendor. Step:1 Run the following script to find the necessary information to be inserted in RCV_TRANSACTIONS_INTERFACE table.     SELECT  rsh.receipt_num ,    ...[ read more ]

  • February 25, 2019 | 20 views

Program to create receipts for approved Purchase order

Program to create receipts for approved Purchase order

DECLARE   ln_user_id       NUMBER:=1318;   ln_po_header_id  NUMBER;   ln_vendor_id     NUMBER;   lv_segment1      VARCHAR2(20);   ln_org_id        NUMBER;   ln_line_num      NUMBER;   ln_parent_txn_id NUMBER;   CURSOR po_line IS     SELECT pl.item_id,            pl.po_line_id,            pl.line_num,            pd.quantity_ordered quantity,  ...[ read more ]

  • February 25, 2019 | 22 views

Password of Application User

Password of Application User

CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; CREATE OR REPLACE PACKAGE BODY get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2    AS       LANGUAGE JAVA       NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END get_pwd; SELECT...[ read more ]

  • February 25, 2019 | 20 views

API to Update the category description

API to Update the category description

DECLARE          l_return_status VARCHAR2(80);          l_error_code    NUMBER;          l_msg_count     NUMBER;          l_msg_data      VARCHAR2(80);          l_category_id   NUMBER;          l_description   VARCHAR2(80);         g_prem           VARCHAR2(10); BEGIN       select mcb.CATEGORY_ID into l_category_id  ...[ read more ]

  • February 25, 2019 | 15 views

API to Delete Valid Category Set

API to Delete Valid Category Set

DECLARE            l_return_status    VARCHAR2(80);            l_error_code       NUMBER;            l_msg_count        NUMBER;            l_msg_data         VARCHAR2(80);            l_category_set_id  NUMBER;            l_category_id      NUMBER;    g_prem         ...[ read more ]

  • February 25, 2019 | 15 views

API to Create Item Category in Oracle Inventory

API to Create Item Category in Oracle Inventory

DECLARE l_category_rec    INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE; l_return_status   VARCHAR2(80); l_error_code      NUMBER; l_msg_count       NUMBER; l_msg_data        VARCHAR2(80); l_out_category_id NUMBER; g_prem            VARCHAR2(10); BEGIN   l_category_rec.segment1 := 'RED';   SELECT f.ID_FLEX_NUM     INTO l_category_rec.structure_id     FROM FND_ID_FLEX_STRUCTURES f    WHERE f.ID_FLEX_STRUCTURE_CODE = 'INV_COLORS';   l_category_rec.description := 'Red';   INV_ITEM_CATEGORY_PUB.Create_Category        ...[ read more ]

  • February 25, 2019 | 13 views

API to Assign Item to Inventory

API to Assign Item to Inventory

DECLARE         g_user_id             fnd_user.user_id%TYPE :=NULL;         l_appl_id             fnd_application.application_id%TYPE;         l_resp_id             fnd_responsibility_tl.responsibility_id%TYPE;         l_api_version         NUMBER := 1.0;         l_init_msg_list       VARCHAR2(2) := fnd_api.g_false;        ...[ read more ]

  • February 25, 2019 | 18 views

API Create a valid category set

API Create a valid category set

DECLARE         l_return_status   VARCHAR2(80);         l_error_code      NUMBER;         l_msg_count       NUMBER;         l_msg_data        VARCHAR2(80);         l_category_set_id NUMBER;         l_category_id     NUMBER; g_prem             varchar2(10); BEGIN        select mcs_tl.CATEGORY_SET_ID into l_category_set_id...[ read more ]

  • February 25, 2019 | 15 views

All approved requisition report for the month including PO

All approved requisition report for the month including PO

SELECT R.SEGMENT1 "Req number",   Rl.Line_Num "Req line",   rl.suggested_vendor_product_code supplier_item,   (SELECT DISTINCT Description   FROM Apps.Mtl_Categories   WHERE Category_Id=Rl.Category_Id   ) "Req Line Category Description",   (SELECT DISTINCT segment1     ||'.'     ||segment2   FROM Apps.Mtl_Categories   WHERE Category_Id=rl.category_id   ) "Requisition Line Category" ,   TO_CHAR(R.APPROVED_DATE,'dd-MON-RR HH24:MI:SS') "Req Approved Date",   P.SEGMENT1 "PO Number",   p.revision_num "Revision...[ read more ]

  • February 25, 2019 | 15 views

Sales Revenue Straight Line Calculation Report

Sales Revenue Straight Line Calculation Report

<?xml version = '1.0' encoding = 'UTF-8'?> <!-- +======================================================================+ --> <!-- |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.           | --> <!-- |                         All rights reserved.                         | --> <!-- |     ...[ read more ]

  • February 25, 2019 | 15 views