Entries by Oracle ERP Apps Guide

, , , , , ,

List of Tables for Forms Personalization

Below is the list of tables that are populated when any Forms Personalization is done FND_FORM_CUSTOM_RULESFND_FORM_CUSTOM_SCOPESFND_FORM_CUSTOM_ACTIONSFND_FORM_CUSTOM_PARAMSFND_FORM_CUSTOM_PROP_VALUESFND_FORM_CUSTOM_PROP_LIST You can FNDLOAD utility to move one instance to another. Or export and import this records from one instance to other. But make sure the sequences are altered 🙂 The below script list all the forms in Oracle Applications […]

, , ,

Payment Due Calculation on AP invoice

Payables calculates payment Due Date using following values: – Goods Received Date + Receipt Acceptance Days– Invoice Date– Terms Date Payables populates the Payment Due Date with the most recent date among the above dates. The logic is:Most Recent( Goods Received Date + Receipt Acceptance Days, Invoice Date, Terms Date ) Goods Received Date:             […]

, , , , ,

Enable/Disable Concurrent program parameter based on Other Parameter

Based on a request, here is the details on how parameter can be enabled/disabled based another parameter value.Below is the requirementThere are 2 valuesets parameter. If for parameter 1 user selects Yes then the other paramter should be enabled whereas if No is selected then the parameter should remain disabled. This can be achieved by […]

, , ,

FNDLOAD Syntax in R12

In the following links I have discussed on how to migrate1) Concurrent Programs2) Value sets from one instance to another using FNDLOAD. Now I will try to cover several other objects that can be migrated using FNDLOAD.The syntax for moving any objects using FNDLOAD is almost the same except few changes. Following is the list […]

, , , , , ,

API to create Item Category

The item categories can be created using item import when Items are created. They can also be created using APIs discussed below: Following are the steps to Check and/or Create Item Categories1) Create Category Segment combinations2) If the enforce list is checked for category then insert category combinations in the enforce list3) Create/Update/Delete Category Assignments […]