ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
CHART OF ACCOUNTS

FRM 40654 error on Updation of DFF on Customer Addresses

Date: Tue, 22 Jun 1999 13:17:28 -0700
From: Satish Reddy SReddy@zilog.com
Subject: Desc Flex on Cust Addresses

hi folks

We have desc flex on Cust addresses.We already have some of the attributes populated but when we try to add or change the values.It gives Error Frm-40654:record has been updated,requery block to see change.

But when u requery,it is still same old values.So basically we are not able to update the flexfields.I took a look at the flex definition.It is working in One instance but not in another.Definitions are same across instances.

We don't have custom triggers on RA_ADDRESSES_ALL.I took a look at the standard triggers,but they are handling only attr1 to attr10 in ra_adresses_all.

Any help would be appreciated.
thanks in advance.

Date: Tue, 22 Jun 1999 16:29:04 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: Re: Desc Flex on Cust Addresses

Hi,

If it happening for attribute7 then it is a bug and you can ask for the patch from Oracle. It works if the value for the attribute7 is not populated i.e. if it is null.

Feel free to contact.. Thanks, MOHAN

Date: Tue, 22 Jun 1999 13:43:47 -0700
From: Satish Reddy SReddy@zilog.com
Subject: RE: Desc Flex on Cust Addresses

I am using attribute15 to attribute10.

Date: Tue, 22 Jun 1999 16:55:26 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: RE: Desc Flex on Cust Addresses

Then just try ltrim and rtrim on the values you are populating . Hope this works for you....

MOHAN

Date: Tue, 22 Jun 1999 14:02:58 -0700
From: Satish Reddy SReddy@zilog.com
Cc: "'mthanika@camail2.harvard.edu'" mthanika@camail2.harvard.edu
Subject: RE: Desc Flex on Cust Addresses

i am not using custom triggers on this tables.

Thanks

From: Chadda, Alok [SMTP:achadda@kpmg.com]
Sent: Wednesday, June 23, 1999 1:50 PM
Subject: RE: Desc Flex on Cust Addresses

Hi, I have experience same problem but it was due to some special character or blank character in the flexfield segment. I was populating the segment using program and some how my program was assigning the space character.

HTH Alok

Date: Thu, 24 Jun 1999 10:17:31 +0200
From: "Sjoquist, Randy (AFIS)" Randy.Sjoquist@fao.org
Subject: RE: Desc Flex on Cust Addresses

I have a simple trim script (given below) that will fix this problem. The app automatically trims each field in the form. Here it removes the space. The result is a conflict between the database and the form. Hence the requery record message. This script can be run across the board or by vendor id.

This problem likely is due to conversion.

Randy

update po_vendor_sites_all
set
TP_HEADER_ID= ltrim(rtrim(TP_HEADER_ID)),
PAY_ON_CODE= ltrim(rtrim(PAY_ON_CODE)),
DEFAULT_PAY_SITE_ID= ltrim(rtrim(DEFAULT_PAY_SITE_ID)),
PAY_ON_RECEIPT_SUMMARY_CODE= ltrim(rtrim(PAY_ON_RECEIPT_SUMMARY_CODE)),
INVOICE_AMOUNT_LIMIT= ltrim(rtrim(INVOICE_AMOUNT_LIMIT)),
PAY_DATE_BASIS_LOOKUP_CODE= ltrim(rtrim(PAY_DATE_BASIS_LOOKUP_CODE)),
ALWAYS_TAKE_DISC_FLAG= ltrim(rtrim(ALWAYS_TAKE_DISC_FLAG)),
INVOICE_CURRENCY_CODE= ltrim(rtrim(INVOICE_CURRENCY_CODE)),
PAYMENT_CURRENCY_CODE= ltrim(rtrim(PAYMENT_CURRENCY_CODE)),
HOLD_ALL_PAYMENTS_FLAG= ltrim(rtrim(HOLD_ALL_PAYMENTS_FLAG)),
HOLD_FUTURE_PAYMENTS_FLAG= ltrim(rtrim(HOLD_FUTURE_PAYMENTS_FLAG)),
HOLD_REASON= ltrim(rtrim(HOLD_REASON)),
HOLD_UNMATCHED_INVOICES_FLAG= ltrim(rtrim(HOLD_UNMATCHED_INVOICES_FLAG)),
AP_TAX_ROUNDING_RULE= ltrim(rtrim(AP_TAX_ROUNDING_RULE)),
AUTO_TAX_CALC_FLAG= ltrim(rtrim(AUTO_TAX_CALC_FLAG)),
AUTO_TAX_CALC_OVERRIDE= ltrim(rtrim(AUTO_TAX_CALC_OVERRIDE)),
AMOUNT_INCLUDES_TAX_FLAG= ltrim(rtrim(AMOUNT_INCLUDES_TAX_FLAG)),
EXCLUSIVE_PAYMENT_FLAG= ltrim(rtrim(EXCLUSIVE_PAYMENT_FLAG)),
TAX_REPORTING_SITE_FLAG= ltrim(rtrim(TAX_REPORTING_SITE_FLAG)),
ATTRIBUTE_CATEGORY= ltrim(rtrim(ATTRIBUTE_CATEGORY)),
ATTRIBUTE1= ltrim(rtrim(ATTRIBUTE1)),
ATTRIBUTE2= ltrim(rtrim(ATTRIBUTE2)),
ATTRIBUTE3= ltrim(rtrim(ATTRIBUTE3)),
ATTRIBUTE4= ltrim(rtrim(ATTRIBUTE4)),
ATTRIBUTE5= ltrim(rtrim(ATTRIBUTE5)),
ATTRIBUTE6= ltrim(rtrim(ATTRIBUTE6)),
ATTRIBUTE7= ltrim(rtrim(ATTRIBUTE7)),
ATTRIBUTE8= ltrim(rtrim(ATTRIBUTE8)),
ATTRIBUTE9= ltrim(rtrim(ATTRIBUTE9)),
ATTRIBUTE10= ltrim(rtrim(ATTRIBUTE10)),
ATTRIBUTE11= ltrim(rtrim(ATTRIBUTE11)),
ATTRIBUTE12= ltrim(rtrim(ATTRIBUTE12)),
ATTRIBUTE13= ltrim(rtrim(ATTRIBUTE13)),
ATTRIBUTE14= ltrim(rtrim(ATTRIBUTE14)),
ATTRIBUTE15= ltrim(rtrim(ATTRIBUTE15)),
REQUEST_ID= ltrim(rtrim(REQUEST_ID)),
PROGRAM_APPLICATION_ID= ltrim(rtrim(PROGRAM_APPLICATION_ID)),
PROGRAM_ID= ltrim(rtrim(PROGRAM_ID)),
VALIDATION_NUMBER= ltrim(rtrim(VALIDATION_NUMBER)),
EXCLUDE_FREIGHT_FROM_DISCOUNT= ltrim(rtrim(EXCLUDE_FREIGHT_FROM_DISCOUNT)),
VAT_REGISTRATION_NUM= ltrim(rtrim(VAT_REGISTRATION_NUM)),
OFFSET_VAT_CODE= ltrim(rtrim(OFFSET_VAT_CODE)),
ORG_ID= ltrim(rtrim(ORG_ID)),
CHECK_DIGITS= ltrim(rtrim(CHECK_DIGITS)),
BANK_NUMBER= ltrim(rtrim(BANK_NUMBER)),
ADDRESS_LINE4= ltrim(rtrim(ADDRESS_LINE4)),
COUNTY= ltrim(rtrim(COUNTY)),
ADDRESS_STYLE= ltrim(rtrim(ADDRESS_STYLE)),
LANGUAGE= ltrim(rtrim(LANGUAGE)),
ALLOW_AWT_FLAG= ltrim(rtrim(ALLOW_AWT_FLAG)),
AWT_GROUP_ID= ltrim(rtrim(AWT_GROUP_ID)),
GLOBAL_ATTRIBUTE1= ltrim(rtrim(GLOBAL_ATTRIBUTE1)),
GLOBAL_ATTRIBUTE2= ltrim(rtrim(GLOBAL_ATTRIBUTE2)),
GLOBAL_ATTRIBUTE3= ltrim(rtrim(GLOBAL_ATTRIBUTE3)),
GLOBAL_ATTRIBUTE4= ltrim(rtrim(GLOBAL_ATTRIBUTE4)),
GLOBAL_ATTRIBUTE5= ltrim(rtrim(GLOBAL_ATTRIBUTE5)),
GLOBAL_ATTRIBUTE6= ltrim(rtrim(GLOBAL_ATTRIBUTE6)),
GLOBAL_ATTRIBUTE7= ltrim(rtrim(GLOBAL_ATTRIBUTE7)),
GLOBAL_ATTRIBUTE8= ltrim(rtrim(GLOBAL_ATTRIBUTE8)),
GLOBAL_ATTRIBUTE9= ltrim(rtrim(GLOBAL_ATTRIBUTE9)),
GLOBAL_ATTRIBUTE10= ltrim(rtrim(GLOBAL_ATTRIBUTE10)),
GLOBAL_ATTRIBUTE11= ltrim(rtrim(GLOBAL_ATTRIBUTE11)),
GLOBAL_ATTRIBUTE12= ltrim(rtrim(GLOBAL_ATTRIBUTE12)),
GLOBAL_ATTRIBUTE13= ltrim(rtrim(GLOBAL_ATTRIBUTE13)),
GLOBAL_ATTRIBUTE14= ltrim(rtrim(GLOBAL_ATTRIBUTE14)),
GLOBAL_ATTRIBUTE15= ltrim(rtrim(GLOBAL_ATTRIBUTE15)),
GLOBAL_ATTRIBUTE16= ltrim(rtrim(GLOBAL_ATTRIBUTE16)),
GLOBAL_ATTRIBUTE17= ltrim(rtrim(GLOBAL_ATTRIBUTE17)),
GLOBAL_ATTRIBUTE18= ltrim(rtrim(GLOBAL_ATTRIBUTE18)),
GLOBAL_ATTRIBUTE19= ltrim(rtrim(GLOBAL_ATTRIBUTE19)),
GLOBAL_ATTRIBUTE20= ltrim(rtrim(GLOBAL_ATTRIBUTE20)),
GLOBAL_ATTRIBUTE_CATEGORY= ltrim(rtrim(GLOBAL_ATTRIBUTE_CATEGORY)),
EDI_TRANSACTION_HANDLING= ltrim(rtrim(EDI_TRANSACTION_HANDLING)),
EDI_ID_NUMBER= ltrim(rtrim(EDI_ID_NUMBER)),
EDI_PAYMENT_METHOD= ltrim(rtrim(EDI_PAYMENT_METHOD)),
EDI_PAYMENT_FORMAT= ltrim(rtrim(EDI_PAYMENT_FORMAT)),
EDI_REMITTANCE_METHOD= ltrim(rtrim(EDI_REMITTANCE_METHOD)),
BANK_CHARGE_BEARER= ltrim(rtrim(BANK_CHARGE_BEARER)),
EDI_REMITTANCE_INSTRUCTION= ltrim(rtrim(EDI_REMITTANCE_INSTRUCTION)),
BANK_BRANCH_TYPE= ltrim(rtrim(BANK_BRANCH_TYPE)),
VENDOR_SITE_ID= ltrim(rtrim(VENDOR_SITE_ID)),
LAST_UPDATED_BY= ltrim(rtrim(LAST_UPDATED_BY)),
VENDOR_ID= ltrim(rtrim(VENDOR_ID)),
VENDOR_SITE_CODE= ltrim(rtrim(VENDOR_SITE_CODE)),
VENDOR_SITE_CODE_ALT= ltrim(rtrim(VENDOR_SITE_CODE_ALT)),
LAST_UPDATE_LOGIN= ltrim(rtrim(LAST_UPDATE_LOGIN)),
CREATED_BY= ltrim(rtrim(CREATED_BY)),
PURCHASING_SITE_FLAG= ltrim(rtrim(PURCHASING_SITE_FLAG)),
RFQ_ONLY_SITE_FLAG= ltrim(rtrim(RFQ_ONLY_SITE_FLAG)),
PAY_SITE_FLAG= ltrim(rtrim(PAY_SITE_FLAG)),
ATTENTION_AR_FLAG= ltrim(rtrim(ATTENTION_AR_FLAG)),
ADDRESS_LINE1= ltrim(rtrim(ADDRESS_LINE1)),
ADDRESS_LINES_ALT= ltrim(rtrim(ADDRESS_LINES_ALT)),
ADDRESS_LINE2= ltrim(rtrim(ADDRESS_LINE2)),
ADDRESS_LINE3= ltrim(rtrim(ADDRESS_LINE3)),
CITY= ltrim(rtrim(CITY)),
STATE= ltrim(rtrim(STATE)),
ZIP= ltrim(rtrim(ZIP)),
PROVINCE= ltrim(rtrim(PROVINCE)),
COUNTRY= ltrim(rtrim(COUNTRY)),
AREA_CODE= ltrim(rtrim(AREA_CODE)),
PHONE= ltrim(rtrim(PHONE)),
CUSTOMER_NUM= ltrim(rtrim(CUSTOMER_NUM)),
SHIP_TO_LOCATION_ID= ltrim(rtrim(SHIP_TO_LOCATION_ID)),
BILL_TO_LOCATION_ID= ltrim(rtrim(BILL_TO_LOCATION_ID)),
SHIP_VIA_LOOKUP_CODE= ltrim(rtrim(SHIP_VIA_LOOKUP_CODE)),
FREIGHT_TERMS_LOOKUP_CODE= ltrim(rtrim(FREIGHT_TERMS_LOOKUP_CODE)),
FOB_LOOKUP_CODE= ltrim(rtrim(FOB_LOOKUP_CODE)),
FAX= ltrim(rtrim(FAX)),
FAX_AREA_CODE= ltrim(rtrim(FAX_AREA_CODE)),
TELEX= ltrim(rtrim(TELEX)),
PAYMENT_METHOD_LOOKUP_CODE= ltrim(rtrim(PAYMENT_METHOD_LOOKUP_CODE)),
BANK_ACCOUNT_NAME= ltrim(rtrim(BANK_ACCOUNT_NAME)),
BANK_ACCOUNT_NUM= ltrim(rtrim(BANK_ACCOUNT_NUM)),
BANK_NUM= ltrim(rtrim(BANK_NUM)),
BANK_ACCOUNT_TYPE= ltrim(rtrim(BANK_ACCOUNT_TYPE)),
TERMS_DATE_BASIS= ltrim(rtrim(TERMS_DATE_BASIS)),
CURRENT_CATALOG_NUM= ltrim(rtrim(CURRENT_CATALOG_NUM)),
VAT_CODE= ltrim(rtrim(VAT_CODE)),
DISTRIBUTION_SET_ID= ltrim(rtrim(DISTRIBUTION_SET_ID)),
ACCTS_PAY_CODE_COMBINATION_ID= ltrim(rtrim(ACCTS_PAY_CODE_COMBINATION_ID)),
PREPAY_CODE_COMBINATION_ID= ltrim(rtrim(PREPAY_CODE_COMBINATION_ID)),
PAY_GROUP_LOOKUP_CODE= ltrim(rtrim(PAY_GROUP_LOOKUP_CODE)),
PAYMENT_PRIORITY= ltrim(rtrim(PAYMENT_PRIORITY)),
TERMS_ID= ltrim(rtrim(TERMS_ID))
where vendor_id = 11522 and
(ltrim(rtrim(TP_HEADER_ID))!=TP_HEADER_ID
or ltrim(rtrim(PAY_ON_CODE))!=PAY_ON_CODE
or ltrim(rtrim(DEFAULT_PAY_SITE_ID))!=DEFAULT_PAY_SITE_ID
or ltrim(rtrim(PAY_ON_RECEIPT_SUMMARY_CODE))!=PAY_ON_RECEIPT_SUMMARY_CODE
or ltrim(rtrim(INVOICE_AMOUNT_LIMIT))!=INVOICE_AMOUNT_LIMIT
or ltrim(rtrim(PAY_DATE_BASIS_LOOKUP_CODE))!=PAY_DATE_BASIS_LOOKUP_CODE
or ltrim(rtrim(ALWAYS_TAKE_DISC_FLAG))!=ALWAYS_TAKE_DISC_FLAG
or ltrim(rtrim(INVOICE_CURRENCY_CODE))!=INVOICE_CURRENCY_CODE
or ltrim(rtrim(PAYMENT_CURRENCY_CODE))!=PAYMENT_CURRENCY_CODE
or ltrim(rtrim(HOLD_ALL_PAYMENTS_FLAG))!=HOLD_ALL_PAYMENTS_FLAG
or ltrim(rtrim(HOLD_FUTURE_PAYMENTS_FLAG))!=HOLD_FUTURE_PAYMENTS_FLAG
or ltrim(rtrim(HOLD_REASON))!=HOLD_REASON
or ltrim(rtrim(HOLD_UNMATCHED_INVOICES_FLAG))!=HOLD_UNMATCHED_INVOICES_FLAG
or ltrim(rtrim(AP_TAX_ROUNDING_RULE))!=AP_TAX_ROUNDING_RULE
or ltrim(rtrim(AUTO_TAX_CALC_FLAG))!=AUTO_TAX_CALC_FLAG
or ltrim(rtrim(AUTO_TAX_CALC_OVERRIDE))!=AUTO_TAX_CALC_OVERRIDE
or ltrim(rtrim(AMOUNT_INCLUDES_TAX_FLAG))!=AMOUNT_INCLUDES_TAX_FLAG
or ltrim(rtrim(EXCLUSIVE_PAYMENT_FLAG))!=EXCLUSIVE_PAYMENT_FLAG
or ltrim(rtrim(TAX_REPORTING_SITE_FLAG))!=TAX_REPORTING_SITE_FLAG
or ltrim(rtrim(ATTRIBUTE_CATEGORY))!=ATTRIBUTE_CATEGORY
or ltrim(rtrim(ATTRIBUTE1))!=ATTRIBUTE1
or ltrim(rtrim(ATTRIBUTE2))!=ATTRIBUTE2
or ltrim(rtrim(ATTRIBUTE3))!=ATTRIBUTE3
or ltrim(rtrim(ATTRIBUTE4))!=ATTRIBUTE4
or ltrim(rtrim(ATTRIBUTE5))!=ATTRIBUTE5
or ltrim(rtrim(ATTRIBUTE6))!=ATTRIBUTE6
or ltrim(rtrim(ATTRIBUTE7))!=ATTRIBUTE7
or ltrim(rtrim(ATTRIBUTE8))!=ATTRIBUTE8
or ltrim(rtrim(ATTRIBUTE9))!=ATTRIBUTE9
or ltrim(rtrim(ATTRIBUTE10))!=ATTRIBUTE10
or ltrim(rtrim(ATTRIBUTE11))!=ATTRIBUTE11
or ltrim(rtrim(ATTRIBUTE12))!=ATTRIBUTE12
or ltrim(rtrim(ATTRIBUTE13))!=ATTRIBUTE13
or ltrim(rtrim(ATTRIBUTE14))!=ATTRIBUTE14
or ltrim(rtrim(ATTRIBUTE15))!=ATTRIBUTE15
or ltrim(rtrim(REQUEST_ID))!=REQUEST_ID
or ltrim(rtrim(PROGRAM_APPLICATION_ID))!=PROGRAM_APPLICATION_ID
or ltrim(rtrim(PROGRAM_ID))!=PROGRAM_ID
or ltrim(rtrim(VALIDATION_NUMBER))!=VALIDATION_NUMBER
or
ltrim(rtrim(EXCLUDE_FREIGHT_FROM_DISCOUNT))!=EXCLUDE_FREIGHT_FROM_DISCOUNT
or ltrim(rtrim(VAT_REGISTRATION_NUM))!=VAT_REGISTRATION_NUM
or ltrim(rtrim(OFFSET_VAT_CODE))!=OFFSET_VAT_CODE
or ltrim(rtrim(ORG_ID))!=ORG_ID
or ltrim(rtrim(CHECK_DIGITS))!=CHECK_DIGITS
or ltrim(rtrim(BANK_NUMBER))!=BANK_NUMBER
or ltrim(rtrim(ADDRESS_LINE4))!=ADDRESS_LINE4
or ltrim(rtrim(COUNTY))!=COUNTY
or ltrim(rtrim(ADDRESS_STYLE))!=ADDRESS_STYLE
or ltrim(rtrim(LANGUAGE))!=LANGUAGE
or ltrim(rtrim(ALLOW_AWT_FLAG))!=ALLOW_AWT_FLAG
or ltrim(rtrim(AWT_GROUP_ID))!=AWT_GROUP_ID
or ltrim(rtrim(GLOBAL_ATTRIBUTE1))!=GLOBAL_ATTRIBUTE1
or ltrim(rtrim(GLOBAL_ATTRIBUTE2))!=GLOBAL_ATTRIBUTE2
or ltrim(rtrim(GLOBAL_ATTRIBUTE3))!=GLOBAL_ATTRIBUTE3
or ltrim(rtrim(GLOBAL_ATTRIBUTE4))!=GLOBAL_ATTRIBUTE4
or ltrim(rtrim(GLOBAL_ATTRIBUTE5))!=GLOBAL_ATTRIBUTE5
or ltrim(rtrim(GLOBAL_ATTRIBUTE6))!=GLOBAL_ATTRIBUTE6
or ltrim(rtrim(GLOBAL_ATTRIBUTE7))!=GLOBAL_ATTRIBUTE7
or ltrim(rtrim(GLOBAL_ATTRIBUTE8))!=GLOBAL_ATTRIBUTE8
or ltrim(rtrim(GLOBAL_ATTRIBUTE9))!=GLOBAL_ATTRIBUTE9
or ltrim(rtrim(GLOBAL_ATTRIBUTE10))!=GLOBAL_ATTRIBUTE10
or ltrim(rtrim(GLOBAL_ATTRIBUTE11))!=GLOBAL_ATTRIBUTE11
or ltrim(rtrim(GLOBAL_ATTRIBUTE12))!=GLOBAL_ATTRIBUTE12
or ltrim(rtrim(GLOBAL_ATTRIBUTE13))!=GLOBAL_ATTRIBUTE13
or ltrim(rtrim(GLOBAL_ATTRIBUTE14))!=GLOBAL_ATTRIBUTE14
or ltrim(rtrim(GLOBAL_ATTRIBUTE15))!=GLOBAL_ATTRIBUTE15
or ltrim(rtrim(GLOBAL_ATTRIBUTE16))!=GLOBAL_ATTRIBUTE16
or ltrim(rtrim(GLOBAL_ATTRIBUTE17))!=GLOBAL_ATTRIBUTE17
or ltrim(rtrim(GLOBAL_ATTRIBUTE18))!=GLOBAL_ATTRIBUTE18
or ltrim(rtrim(GLOBAL_ATTRIBUTE19))!=GLOBAL_ATTRIBUTE19
or ltrim(rtrim(GLOBAL_ATTRIBUTE20))!=GLOBAL_ATTRIBUTE20
or ltrim(rtrim(GLOBAL_ATTRIBUTE_CATEGORY))!=GLOBAL_ATTRIBUTE_CATEGORY
or ltrim(rtrim(EDI_TRANSACTION_HANDLING))!=EDI_TRANSACTION_HANDLING
or ltrim(rtrim(EDI_ID_NUMBER))!=EDI_ID_NUMBER
or ltrim(rtrim(EDI_PAYMENT_METHOD))!=EDI_PAYMENT_METHOD
or ltrim(rtrim(EDI_PAYMENT_FORMAT))!=EDI_PAYMENT_FORMAT
or ltrim(rtrim(EDI_REMITTANCE_METHOD))!=EDI_REMITTANCE_METHOD
or ltrim(rtrim(BANK_CHARGE_BEARER))!=BANK_CHARGE_BEARER
or ltrim(rtrim(EDI_REMITTANCE_INSTRUCTION))!=EDI_REMITTANCE_INSTRUCTION
or ltrim(rtrim(BANK_BRANCH_TYPE))!=BANK_BRANCH_TYPE
or ltrim(rtrim(VENDOR_SITE_ID))!=VENDOR_SITE_ID
or ltrim(rtrim(LAST_UPDATED_BY))!=LAST_UPDATED_BY
or ltrim(rtrim(VENDOR_ID))!=VENDOR_ID
or ltrim(rtrim(VENDOR_SITE_CODE))!=VENDOR_SITE_CODE
or ltrim(rtrim(VENDOR_SITE_CODE_ALT))!=VENDOR_SITE_CODE_ALT
or ltrim(rtrim(LAST_UPDATE_LOGIN))!=LAST_UPDATE_LOGIN
or ltrim(rtrim(CREATED_BY))!=CREATED_BY
or ltrim(rtrim(PURCHASING_SITE_FLAG))!=PURCHASING_SITE_FLAG
or ltrim(rtrim(RFQ_ONLY_SITE_FLAG))!=RFQ_ONLY_SITE_FLAG
or ltrim(rtrim(PAY_SITE_FLAG))!=PAY_SITE_FLAG
or ltrim(rtrim(ATTENTION_AR_FLAG))!=ATTENTION_AR_FLAG
or ltrim(rtrim(ADDRESS_LINE1))!=ADDRESS_LINE1
or ltrim(rtrim(ADDRESS_LINES_ALT))!=ADDRESS_LINES_ALT
or ltrim(rtrim(ADDRESS_LINE2))!=ADDRESS_LINE2
or ltrim(rtrim(ADDRESS_LINE3))!=ADDRESS_LINE3
or ltrim(rtrim(CITY))!=CITY
or ltrim(rtrim(STATE))!=STATE
or ltrim(rtrim(ZIP))!=ZIP
or ltrim(rtrim(PROVINCE))!=PROVINCE
or ltrim(rtrim(COUNTRY))!=COUNTRY
or ltrim(rtrim(AREA_CODE))!=AREA_CODE
or ltrim(rtrim(PHONE))!=PHONE
or ltrim(rtrim(CUSTOMER_NUM))!=CUSTOMER_NUM
or ltrim(rtrim(SHIP_TO_LOCATION_ID))!=SHIP_TO_LOCATION_ID
or ltrim(rtrim(BILL_TO_LOCATION_ID))!=BILL_TO_LOCATION_ID
or ltrim(rtrim(SHIP_VIA_LOOKUP_CODE))!=SHIP_VIA_LOOKUP_CODE
or ltrim(rtrim(FREIGHT_TERMS_LOOKUP_CODE))!=FREIGHT_TERMS_LOOKUP_CODE
or ltrim(rtrim(FOB_LOOKUP_CODE))!=FOB_LOOKUP_CODE
or ltrim(rtrim(FAX))!=FAX
or ltrim(rtrim(FAX_AREA_CODE))!=FAX_AREA_CODE
or ltrim(rtrim(TELEX))!=TELEX
or ltrim(rtrim(PAYMENT_METHOD_LOOKUP_CODE))!=PAYMENT_METHOD_LOOKUP_CODE
or ltrim(rtrim(BANK_ACCOUNT_NAME))!=BANK_ACCOUNT_NAME
or ltrim(rtrim(BANK_ACCOUNT_NUM))!=BANK_ACCOUNT_NUM
or ltrim(rtrim(BANK_NUM))!=BANK_NUM
or ltrim(rtrim(BANK_ACCOUNT_TYPE))!=BANK_ACCOUNT_TYPE
or ltrim(rtrim(TERMS_DATE_BASIS))!=TERMS_DATE_BASIS
or ltrim(rtrim(CURRENT_CATALOG_NUM))!=CURRENT_CATALOG_NUM
or ltrim(rtrim(VAT_CODE))!=VAT_CODE
or ltrim(rtrim(DISTRIBUTION_SET_ID))!=DISTRIBUTION_SET_ID
or
ltrim(rtrim(ACCTS_PAY_CODE_COMBINATION_ID))!=ACCTS_PAY_CODE_COMBINATION_ID
or ltrim(rtrim(PREPAY_CODE_COMBINATION_ID))!=PREPAY_CODE_COMBINATION_ID
or ltrim(rtrim(PAY_GROUP_LOOKUP_CODE))!=PAY_GROUP_LOOKUP_CODE
or ltrim(rtrim(PAYMENT_PRIORITY))!=PAYMENT_PRIORITY
or ltrim(rtrim(TERMS_ID))!=TERMS_ID)
or (ltrim(rtrim(TP_HEADER_ID)) is null
or ltrim(rtrim(PAY_ON_CODE))is null
or ltrim(rtrim(DEFAULT_PAY_SITE_ID))is null
or ltrim(rtrim(PAY_ON_RECEIPT_SUMMARY_CODE))is null
or ltrim(rtrim(INVOICE_AMOUNT_LIMIT))is null
or ltrim(rtrim(PAY_DATE_BASIS_LOOKUP_CODE))is null
or ltrim(rtrim(ALWAYS_TAKE_DISC_FLAG))is null
or ltrim(rtrim(INVOICE_CURRENCY_CODE))is null
or ltrim(rtrim(PAYMENT_CURRENCY_CODE))is null
or ltrim(rtrim(HOLD_ALL_PAYMENTS_FLAG))is null
or ltrim(rtrim(HOLD_FUTURE_PAYMENTS_FLAG))is null
or ltrim(rtrim(HOLD_REASON))is null
or ltrim(rtrim(HOLD_UNMATCHED_INVOICES_FLAG))is null
or ltrim(rtrim(AP_TAX_ROUNDING_RULE))is null
or ltrim(rtrim(AUTO_TAX_CALC_FLAG))is null
or ltrim(rtrim(AUTO_TAX_CALC_OVERRIDE))is null
or ltrim(rtrim(AMOUNT_INCLUDES_TAX_FLAG))is null
or ltrim(rtrim(EXCLUSIVE_PAYMENT_FLAG))is null
or ltrim(rtrim(TAX_REPORTING_SITE_FLAG))is null
or ltrim(rtrim(ATTRIBUTE_CATEGORY))is null
or ltrim(rtrim(ATTRIBUTE1))is null
or ltrim(rtrim(ATTRIBUTE2))is null
or ltrim(rtrim(ATTRIBUTE3))is null
or ltrim(rtrim(ATTRIBUTE4))is null
or ltrim(rtrim(ATTRIBUTE5))is null
or ltrim(rtrim(ATTRIBUTE6))is null
or ltrim(rtrim(ATTRIBUTE7))is null
or ltrim(rtrim(ATTRIBUTE8))is null
or ltrim(rtrim(ATTRIBUTE9))is null
or ltrim(rtrim(ATTRIBUTE10))is null
or ltrim(rtrim(ATTRIBUTE11))is null
or ltrim(rtrim(ATTRIBUTE12))is null
or ltrim(rtrim(ATTRIBUTE13))is null
or ltrim(rtrim(ATTRIBUTE14))is null
or ltrim(rtrim(ATTRIBUTE15))is null
or ltrim(rtrim(REQUEST_ID))is null
or ltrim(rtrim(PROGRAM_APPLICATION_ID))is null
or ltrim(rtrim(PROGRAM_ID))is null
or ltrim(rtrim(VALIDATION_NUMBER))is null
or ltrim(rtrim(EXCLUDE_FREIGHT_FROM_DISCOUNT))is null
or ltrim(rtrim(VAT_REGISTRATION_NUM))is null
or ltrim(rtrim(OFFSET_VAT_CODE))is null
or ltrim(rtrim(ORG_ID))is null
or ltrim(rtrim(CHECK_DIGITS))is null
or ltrim(rtrim(BANK_NUMBER))is null
or ltrim(rtrim(ADDRESS_LINE4))is null
or ltrim(rtrim(COUNTY))is null
or ltrim(rtrim(ADDRESS_STYLE))is null
or ltrim(rtrim(LANGUAGE))is null
or ltrim(rtrim(ALLOW_AWT_FLAG))is null
or ltrim(rtrim(AWT_GROUP_ID))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE1))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE2))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE3))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE4))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE5))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE6))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE7))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE8))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE9))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE10))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE11))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE12))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE13))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE14))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE15))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE16))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE17))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE18))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE19))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE20))is null
or ltrim(rtrim(GLOBAL_ATTRIBUTE_CATEGORY))is null
or ltrim(rtrim(EDI_TRANSACTION_HANDLING))is null
or ltrim(rtrim(EDI_ID_NUMBER))is null
or ltrim(rtrim(EDI_PAYMENT_METHOD))is null
or ltrim(rtrim(EDI_PAYMENT_FORMAT))is null
or ltrim(rtrim(EDI_REMITTANCE_METHOD))is null
or ltrim(rtrim(BANK_CHARGE_BEARER))is null
or ltrim(rtrim(EDI_REMITTANCE_INSTRUCTION))is null
or ltrim(rtrim(BANK_BRANCH_TYPE))is null
or ltrim(rtrim(VENDOR_SITE_ID))is null
or ltrim(rtrim(LAST_UPDATED_BY))is null
or ltrim(rtrim(VENDOR_ID))is null
or ltrim(rtrim(VENDOR_SITE_CODE))is null
or ltrim(rtrim(VENDOR_SITE_CODE_ALT))is null
or ltrim(rtrim(LAST_UPDATE_LOGIN))is null
or ltrim(rtrim(CREATED_BY))is null
or ltrim(rtrim(PURCHASING_SITE_FLAG))is null
or ltrim(rtrim(RFQ_ONLY_SITE_FLAG))is null
or ltrim(rtrim(PAY_SITE_FLAG))is null
or ltrim(rtrim(ATTENTION_AR_FLAG))is null
or ltrim(rtrim(ADDRESS_LINE1))is null
or ltrim(rtrim(ADDRESS_LINES_ALT))is null
or ltrim(rtrim(ADDRESS_LINE2))is null
or ltrim(rtrim(ADDRESS_LINE3))is null
or ltrim(rtrim(CITY))is null
or ltrim(rtrim(STATE))is null
or ltrim(rtrim(ZIP))is null
or ltrim(rtrim(PROVINCE))is null
or ltrim(rtrim(COUNTRY))is null
or ltrim(rtrim(AREA_CODE))is null
or ltrim(rtrim(PHONE))is null
or ltrim(rtrim(CUSTOMER_NUM))is null
or ltrim(rtrim(SHIP_TO_LOCATION_ID))is null
or ltrim(rtrim(BILL_TO_LOCATION_ID))is null
or ltrim(rtrim(SHIP_VIA_LOOKUP_CODE))is null
or ltrim(rtrim(FREIGHT_TERMS_LOOKUP_CODE))is null
or ltrim(rtrim(FOB_LOOKUP_CODE))is null
or ltrim(rtrim(FAX))is null
or ltrim(rtrim(FAX_AREA_CODE))is null
or ltrim(rtrim(TELEX))is null
or ltrim(rtrim(PAYMENT_METHOD_LOOKUP_CODE))is null
or ltrim(rtrim(BANK_ACCOUNT_NAME))is null
or ltrim(rtrim(BANK_ACCOUNT_NUM))is null
or ltrim(rtrim(BANK_NUM))is null
or ltrim(rtrim(BANK_ACCOUNT_TYPE))is null
or ltrim(rtrim(TERMS_DATE_BASIS))is null
or ltrim(rtrim(CURRENT_CATALOG_NUM))is null
or ltrim(rtrim(VAT_CODE))is null
or ltrim(rtrim(DISTRIBUTION_SET_ID))is null
or ltrim(rtrim(ACCTS_PAY_CODE_COMBINATION_ID))is null
or ltrim(rtrim(PREPAY_CODE_COMBINATION_ID))is null
or ltrim(rtrim(PAY_GROUP_LOOKUP_CODE))is null
or ltrim(rtrim(PAYMENT_PRIORITY))is null
or ltrim(rtrim(TERMS_ID))is null)

VAT DFF - Not to appear in Form

Date: Thu, 01 Jul 1999 11:44:16 -0400
From: "Tony Marchegiano" TMarchegiano@mail.nbme.org
Subject: GL: VAT Descriptive Flex

Hi all,

I'm trying to disable the Value Added Tax popup descriptive flexfield window in the journal lines entry zone of the enter journals forms, which our Finance deaprtment does not need. Can someone direct me on the proper path to close this down ??? You can reply directly to me or to the whole list. We are on 10.7 char mode on Digital Unix.

Thanks,
Tony Marchegiano
National Board of Medical Examiners
tmarchegiano@mail.nbme.org

Date: Thu, 1 Jul 1999 12:01:19 -0400
From: "Feeney, Brian" Brian.feeney@MercerMC.com
Subject: RE: VAT Descriptive Flex

Here's how we disabled those fields for GL:

In the GL Super User responsibility:

go to \ Navigate Setup Financials Flexfields Descriptive Segments

hit page down so you are in the second zone of the form (Descriptive Flexfields) with the cursor in the Title field

run a query as follows: \ Query Enter then enter %Value Added Tax% and execute the query

This will bring up the information for the Descriptive Flexfield you want to disable.

Change the Freeze Flexfield Definition field from Yes to No and save the change.

then Hit page Down to go to the Context Field Values Zone of the form

Go to the Field Names No and Yes and hit page down on each to reveal the Segment Zone information. Change the Display field from Yes to No on each and save your changes.

Then page up to the Descriptive Flexfield Zone and change the Freeze Flexfield Definition field from No to Yes and save the change.

This should disable the pop-up boxes in GL for you.

Brian

Adding new DFF

Date: Mon, 28 Jun 1999 06:18:37 PDT
From: simon daniel ora_apps@hotmail.com
Subject: adding new descriptive field !!

Hi AOL GURUS,

I want to add a new descriptive flex field in oracle purchasing, enter PO header screen. right now one descriptive flex field is already in place. I would like to know if anyone has tried adding another..Would appreciate all suggestions in this regard

Cioa..
Simon D

Date: Mon, 28 Jun 1999 09:37:19 -0400
From: "Cunningham, Ronald" rcunningham@noblestar.com
Subject: RE: adding new descriptive field !!

Simon,

Normally, this would be accomplished by defining more segments to the original dff for the form. This is fairly easy. If you absolutely have to add another entire dff, you are talking about a major customization. I'm sure this can be done but I have never seen it.

Ron
Ronald A. Cunningham
Oracle Consultant
Noble(star Systems Corporation
http://www.noblestar.com
Email: rcunningham@noblestar.com
Phone (Voice Mail): 703.464.4000
Phone (Home Voice/TDD): 803.732.1713
FAX (Home): 803.749.8878

Date: Mon, 28 Jun 1999 08:49:17 -0500
From: "Aronovici, Sarah" Aronovis@augsburgfortress.org
Subject: RE: adding new descriptive field !!

One other idea would be to create a context-sensitive DFF if you only need this DFF for just certain cases.

Sarah

x-------------x

Date: Mon, 19 Jul 1999 16:25:44 +0530
From: Nuku Dinkar nsd18102@trishul.icil.co.in
Subject: How to attach Descriptive Flexfield to Form in Rel 11

Hi,

I would like to know how Descriptive flexfield is attached to form in Rel 11 after it is registered & Segments have been attached to it ?

Is there any form by which i can select a Block & attach Descriptive flexfield to it ?

Thanks in advance, Nukul

Date: Mon, 19 Jul 1999 12:21:48 +0100
From: rchalton@dunnes-stores.ie
Subject: Re: How to attach Descriptive Flexfield to Form in Rel 11
You need to do the following in your form:

Create a displayed field to hold your concatenated segment values (the [ ] field).

Create fields (normally hidden) for each of the flexfield columns in your table (teh one used for your flex).

In the form-level WHEN-NEW-FORM-INSTANCE, call FND_DESCR_FLEX.DEFINE, setting BLOCK parameter to the name of the block containing your [ ] field, the FIELD parameter to the name of your [ ] field, the APPL_SHORT_NAME parameter to the short name of your application and the DESC_FLEX_NAME parameter to the name of your descriptive flex.

In the form-level WHEN-NEW-ITEM-INSTANCE, WHEN-VALIDATE-ITEM, PRE-INSERT, PRE-UPDATE, POST-QUERY and PRE-QUERY triggers place a call to FND_FLEX.EVENT as follows:
FND_FLEX.EVENT ( 'TRIGGER_NAME');
where TRIGGER_NAME is the name of the trigger, e.g. in the PRE-QUERY
trigger .... FND_FLEX.EVENT('PRE-QUERY');

That should do it. RobC

Descriptive Flexfields for AR

Date: Tue, 23 Mar 1999 09:02:50 -0600
From: "Puchniak, Stan"
Subject: AR: DFF on Enter Customer

We are running 10.7 character and have a DFF defined for the enter customer form. This DFF was created with no edits and now we would like to attach value sets to the two segment DFF. Also, it would be preferred to make it context sensitive. On our test system I performed the cleanup of Attribute1 and Attribute2 of AR.RA_Customers. I created the value sets and context sensitive flexfields. For example, segment one has possible values of "A, B, C or D". The LOV for segment 2 is dependent on segment 1. Our legacy system uses these fields from AR.RA_Customers so I must continue to use Attribute1 and Attribute2. With the change, everything appears to work fine and the tables are updated properly. The problem I have is that you cannot see the values previously defined for the customer through the form once the change is made. All changes/additions are displayed correctly on the form. Does anyone know of any problems this change may cause? Is there a better way to have the same result making the changes to the DFF?

TIA, Stan

Date: Tue, 23 Mar 1999 10:37:35 -0500
From: Sateesh Reddy
Subject: Re: AR: DFF on Enter Customer

Hi stan Populate attribute category column for previously defined customers with correct context sensitive value.

Sateesh Reddy Harvard University 617-495-1717

Setup Context Sensitive DFF

Date: Tue, 14 Sep 1999 08:11:35 -0500
From: "HANCOCK, David" dhancock@shl.com
To: oraapps-l@cpa.qc.ca
Subject: Descriptive Flexfield Setup

Hi All:

Is anyone familiar with setting up context sensitive descriptive flexfields? I am looking for any literature, or advice, that would guide me through setting up dff's that are dependant on user values chosen in other dff's. Your input is valued.

Dave Hancock
888-319-1178

Date: Tue, 14 Sep 1999 07:05:01 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Descriptive Flexfield Setup

Hi,
The descriptive flexfields which are already part of the form are simple to set up.
You could take the window help. But consider if this helps:

1.Navigate to the setting up of the Descriptive ff form and by default the global data elements is set up.
2.You can add context after this by giving a user defined context.
3.You can click on the segments for the user defined context and choose the prompts and attach the relevant columns in the underlying table . You could also attach relevant valuesets needed.
4.For every context you can also set up the reference field which means that when the cursor navigates to the reference field the dff pops up.

Hope this helps,
good luck,
Murthy.