My Oracle Support Banner

Portugal: Error While Installing SAF-T PT Package Installsaftsncpt.Zip In Xxocspt_saft_snc_pkg: ORA-00904 REGEXP_REPLACE: invalid identifier ORA-04063 ORA-04068 (Doc ID 1330844.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financials for EMEA - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
INSTALLSAFTSNCPT.zip
XXOCSPT_SAFT_SNC_PKG
REGEXP_REPLACE
REPORT:SAFT-PT SNC Criação de Indices


Symptoms

When attempting to install SAF-T PT package INSTALLSAFTSNCPT.zip , the following error occurs.

ERROR
-----------------------

1. One new Invalid
=======================

When we ran the script install_saft_pt_app.sh got below error.


Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY XXOCSPT_SAFT_SNC_PKG:

LINE/COL ERROR

100/15 PL/SQL: SQL Statement ignored
100/64 PL/SQL: ORA-00904: "REGEXP_REPLACE": invalid identifier




2. Conc. Prog SAFT-PT SNC Criação de Indices completed with errors
=====================================================================

**Starts**11-MAY-2011 20:41:27
ORACLE error 4068 in FDPSTP

Cause: FDPSTP failed due to ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.XXOCSPT_SAFT_SNC_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at lin


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.