Page 1 of 1
Error while defining new Customer in new AR org.
Posted: Sat Mar 24, 2007 7:06 am
by vikasurunkar
Hi All,
I am working on Test Vision Instance. Trying to define a new customer but I am facing the error as below -
<b>ORA-06550: line 1, column 7:
PLS-00201: identifier 'ARP_STAX_5641.ENABLE_TRIGGERS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "APPS.ARP_STAX", line 371</b>
While creating new AR Org n customer I m following the same steps given in the ERPstuff Fin doc.
Waiting for reply.
Thanks in advance to all.
Vikas A. Urunkar
Posted: Tue Mar 27, 2007 3:49 am
by vijayasarathyr
HI,
I have faced same problem (triggers). You need to ask your technical guy to enable triggers for this table. Once this is done, then you will be able to enter customer in AR.
Posted: Wed Mar 28, 2007 12:40 am
by anu_uma
Hi,
Have you Recompiled any objects ?
Generally these ORA-6550 error occurs on when a new form Instance
Below given are the details from Metalink
Source Metalink
When trying to open the Remit-to Addresses form, you encounter the following error:
ORA-06550: line 1, column 7:
PLS-00905: object APPS.ARP_STAX_165 is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "APPS.ARP_STAX", line 371
After clicking the Details button:
<b>ORA-06550: line 1, column 7:
PLS-00905: object APPS.ARP_STAX_165 is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "APPS.ARP_STAX", line 371</b>
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06550.
After clicking OK:
FRM-40105 Unable to resolve reference to address_style
You have recompiled the Remit Address Information and Sales Tax Location flexfields per notes on
MetaLink but that did not resolve the error.
CauseThere is an invalid object (object APPS.ARP_STAX_165 is invalid).
SolutionRecompile your invalid object(s) and retest.
Pls refer the Note:27443.1 in Metalink
Rgds,
Uma
Posted: Thu Mar 29, 2007 1:41 am
by vikasurunkar
Thank you Anu and vijayasarathy for your inputs.
Hi Anu, I have not recompiled any objects. And am not able to resolve it.
Can you put some more light on it.
Posted: Thu Mar 29, 2007 3:39 am
by admin
Pl follow the metalink note,
Subject: Error Creating Customer PLS-00201: identifier 'ARP_STAX_101.ENABLE_TRIGGERS' must be declared
Doc ID: Note:364140.1 Type: PROBLEM
Last Revision Date: 19-MAY-2006 Status: PUBLISHED
Posted: Mon Mar 30, 2009 7:04 pm
by myso
hi all
i faced the same problem and i think that concurrent request to generate tax location flex filed does not completed successfully(stay pending & standby) WHY??
i hope to know!!!!!!!!!!!!!1