Home » Applications » Oracle Fusion Apps & E-Business Suite » FRM-30187
FRM-30187 [message #248647] Fri, 29 June 2007 19:35 Go to next message
asterisk
Messages: 4
Registered: June 2007
Junior Member
Hi,

I am getting this error when I tried to compile a standard form:

FRM-30187: Size of CHAR column in record group must be between 1 and 2000.
Record Group QF_TAXPAYER_ID
Form: ARXCUDCI

FRM-30085: Unable to adjust form for output.

Form not created


I changed a column in the record group QF_TAXPAYER_ID but the character is not more than 9 bytes.

Here is the original query:

select distinct c.cust_account_id,
       party.jgzz_fiscal_code , 
       substrb(party.party_name,1,50) party_name, 
       c.account_number,
       party.tax_reference, 
       party.party_number, 
       party.party_id,
       party.person_first_name,
       party.person_last_name ,
       c.account_name account_description
from hz_cust_accounts c,
     hz_parties party 
where c.party_id = party.party_id
  and party.party_type = :ctrlcustomer_type
order by c.account_number


and here is the changed query:

select distinct c.cust_account_id,
       trim(LPAD(substr(party.JGZZ_FISCAL_CODE,
         length(party.JGZZ_FISCAL_CODE)-3,4),
         length(party.JGZZ_FISCAL_CODE),'X')) jgzz_fiscal_code,
       substrb(party.party_name,1,50) party_name, 
       c.account_number,
       party.tax_reference, 
       party.party_number, 
       party.party_id,
       party.person_first_name,
       party.person_last_name ,
       c.account_name account_description
from hz_cust_accounts c,
     hz_parties party 
where c.party_id = party.party_id
  and party.party_type = :ctrl.customer_type
order by c.account_number


Can you please suggest what is wrong?
Re: FRM-30187 [message #248889 is a reply to message #248647] Mon, 02 July 2007 10:29 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
If the length(party.JGZZ_FISCAL_CODE) is <=3 you will get into trouble.
Re: FRM-30187 [message #248897 is a reply to message #248889] Mon, 02 July 2007 10:50 Go to previous messageGo to next message
asterisk
Messages: 4
Registered: June 2007
Junior Member
why?.......
Re: FRM-30187 [message #248898 is a reply to message #248889] Mon, 02 July 2007 10:53 Go to previous messageGo to next message
asterisk
Messages: 4
Registered: June 2007
Junior Member
I have a question?.......is it right to modify the standard form?....or shud i make changes in the custom.pll? or is it possible to change it from forms personlization?
Re: FRM-30187 [message #249141 is a reply to message #248897] Tue, 03 July 2007 08:40 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
asterisk wrote on Mon, 02 July 2007 10:50
why?.......


If you really cannot figure out why, then maybe you should not be touching production code.
Re: FRM-30187 [message #252738 is a reply to message #248898] Thu, 19 July 2007 18:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: FRM-30187 [message #252933 is a reply to message #252738] Fri, 20 July 2007 14:01 Go to previous messageGo to next message
asterisk
Messages: 4
Registered: June 2007
Junior Member
the form error does not show again as I realized i can't cant change the record query of the standard form, nor is the option available in forms personalization anymore. I know I have to change it in Custom.pll but dont know how?
Can you help me with that?
Re: FRM-30187 [message #253187 is a reply to message #252933] Mon, 23 July 2007 01:32 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I have moved your query to the 'Applications' forum.

David
Previous Topic: Price protection
Next Topic: Need help again..plz
Goto Forum:
  


Current Time: Sun Dec 04 17:00:47 CST 2016

Total time taken to generate the page: 0.03842 seconds