Entries by Oracle ERP Apps Guide

, , ,

R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERP

:$FLEX$.VALUE_SET_NAME to set up value sets where one segment depends on a prior segment that itself depends on a prior segment (“cascading dependencies”) WHERE CLAUSE WHERE EXISTS (SELECT 1FROM PO_REQUISITION_HEADERS_ALL PRHA,PO_REQUISITION_LINES_ALL PRLA,PO_REQ_DISTRIBUTIONS_ALL PRDA,MTL_SYSTEM_ITEMS_B MSIWHERE PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_IDAND PRHA.AUTHORIZATION_STATUS = ‘APPROVED’AND PRLA.REQUISITION_LINE_ID = PRDA.REQUISITION_LINE_IDAND PRLA.ITEM_ID = MSI.INVENTORY_ITEM_IDAND PRLA.DESTINATION_ORGANIZATION_ID = MSI.ORGANIZATION_IDAND (PRLA.LINE_LOCATION_ID IS NULLOR PRLA.AUCTION_HEADER_ID IS NULL)AND […]

, ,

How to Define Custom Key Flexfield (KFF) in R12

I will explain how to create a custom KFF. Here I’m using XXCUST_KFF_DEMO table to capture the KFF code combinations. Following steps needs to perform to create custom KFF. 1) Register the XXCUST_KFF_DEMO table. Click here to see the code. Verify the table has created successfully. Navigation: Application Developer > Application > Database > Table 2) Register the Key Flexfield. Navigation : Application Developer > Flexfield > Key Flexfields 3) Define […]