Error while defining new Customer in new AR org.

[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

[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.

[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

[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.

[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

[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