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
, , ,

R12 – How to Delete Oracle AR Transactions

User can able to delete the AR transaction in below cases are met: The invoice in the incomplete status. The invoice doesn’t posted. This is no receipt applied to the invoice. Note: You might miss your invoice document sequence. Based on company policy, whether you can keep the document or remove from system. If the […]

/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
, ,

R12 – java.sql.SQLException: Invalid column type in OAF

Issue: When we are using view object (VO) in OA Framework it’s possible that you will run in to the problem java.sql.SQLException: Invalid column type, especially if it’s an LOV VO. When you click on the LOV torch for the first time it is working fine. But whenever when we click on the GO button in […]

/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