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 […]

/by
, ,

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 […]

/by
,

How to Find Duplicate Row in OAF Page?

How to Find Duplicate Row in OAF Page? In this article, I have explained how to stop user to enter duplicate rows in OAF Page table region or advanced table region. This validation helps the users not to enter any duplicate record into system. Below method should be created in AM (Application Module) and it […]

/by