Entries by Oracle ERP Apps Guide

, , ,

R12 – Adding Descriptive Flex Field (DFF) through OAF Personalization

This article will explain how to add a DFF to a existing OAF page through personalization.I am using Supplier Quick Update Page ( /oracle/apps/pos/supplier/webui/SuppSummPG ). If you want to see how to create DFF please click here. In this scenario I am using a custom DFF. Following are the details. Application -> Payables ( Code: SQLAP )Name -> XXCUST_SUPPLIER_DFFTitle -> XXCUST – Supplier DFFTable Name -> AP_SUPPLIERSDFV […]

/by
, , ,

Query to get PO Requisition, PO and Receipt details in R12

I had to provide data to auditors on the Internal & Purchase Requisitions created by users Purchase Orders created for the requisitions (inventory and non inventory items) Receiving transactions with PO and Requisition information Purchase Requisition details SELECT prh.segment1 “Req #”, prh.creation_date, prh.created_by, poh.segment1 “PO #”, ppx.full_name “Requestor Name”,prh.description “Req Description”, prh.authorization_status, prh.note_to_authorizer, prh.type_lookup_code, prl.line_num,prl.line_type_id, […]

/by
, , , ,

R12 – Ship Confirm using API

Use this script to create a procedure in Database and call the procedure by passing the delivery number as a parameter to ship confirm it. You can set the options for1. Back ordering unspecified quantities2. Closing the delivery automatically by submitting the Trip stop program after ship confirm is successful SHIP CONFIRMATION THROUGH API CREATE […]

/by
, , , , ,

R12 – Item Category Create/Update/Delete using API’s

There are few APIs in INV_ITEM_CATEGORY_PUB package related to item category. This article will follow a category flexfield structure. Please refer the below post for more detail. 1. INV_ITEM_CATEGORY_PUB.Create_Category: 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; 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 = […]

/by