[Oracle] An error occurred while attempting to establish FNDFS_

An error occurred while attempting to establish FNDFS_ when view concurrent log

solutions :

Update profile option :

a) “RRA: Enabled”/FS_ENABLED should be set to  “Yes”

b) “RRA: Service Prefix”/FS_SVC_PREFIX  should be  null-ed out , no spaces allowed

 

 

[Oracle Apps] Remove forward button from PO Notification Page

To remove “forward” and “approve and forward” you have to custom po notification workflow,

1. Open PO Notification workflow

2. Expand Lookup type and delete”approve and forward” and “forward” under po approval action

result :

[oracle] Create dblink sintax

Create database link “DEV_TO_PROD”
connect to apps
identified by apps
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.30)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = dev)
)
)’;

[Xml Publisher] Missing equals sign between attribute and attribute value

Symptoms :

When you open the  Report which is generated in XML format, you get the following error : Missing equals sign between attribute and attribute value. Error processing resource ‘file.XXXXXX… ————————-^

Cause : There are spaces in the XML tag (APPLICATIONS TEMPLATE REPORT) in the property pallet of header report

Solution :  for example your report name is “report register pembelian”, check report property pallete in “xml tag” column, then erase spaces between xml tag name

before : REPORT REGISTER PEMBELIAN

after     : REPORTREGISTERPEMBELIAN

then after uploaded the report, you can re-submit it.

Change Solaris System Date

Syntax :  date mmddhhmmyy (Login as Root)

Example : date 0104123010  =  Mon Jan 4 12:30:00 2010

if you have Oracle Applications installed in solaris machine, please shut down all application and db oracle before change the solaris system date (especially for backdated system date)..

[oracle]How to Compile Invalid Object

how to compile invalid object :

login sqlplus as sysdba

1. >  sqlplus / as sysdba

2. > execute : EXEC UTL_RECOMP.RECOMP_PARALLEL(8);  8 -> number of parallel process

[oracle] how to commit inside trigger

you can comit inside trigger using pragma autonomous_transaction;

example :

CREATE OR REPLACE TRIGGER APPS.SJA_WSH_NEW_DELIVERIES
BEFORE INSERT
ON WSH_NEW_DELIVERIES
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
DECLARE
vvar varchar2(320);
vtag1 varchar2(320);
vtag2 varchar2(320);
vtag3 varchar2(320);
vyear varchar2(320);
vrowid number;
vtmpg varchar2(320);
vinsert varchar2(320);
pragma autonomous_transaction;
BEGIN
select  mpv.ATTRIBUTE8  INTO  vvar from
mtl_parameters mpv
where :new.organization_id = mpv.ORGANIZATION_ID;
if vvar is null then
:new.name := (:new.name||’A1′);
else

select substr(vvar,10,6) into vtag1 from dual;

select to_number(substr(vvar,5,4)) into vtag2 from dual;

select substr(vvar,0,3)  into vtag3 from dual;

SELECT TO_NUMBER(TO_CHAR(SYSDATE,’RRRR’)) into vyear FROM DUAL;

if vyear <>  vtag2 then

vinsert:=(vtag3||’.'||vyear||’.'||’000001′);

commit;

update mtl_parameters set attribute8 = vinsert
where organization_id = :new.organization_id;

:new.name := vinsert;
else

vtmpg := lpad(to_char(to_number(vtag1)+1),6,’0′);
vinsert:=(vtag3||’.'||vyear||’.'||vtmpg);

:new.name := vinsert;

update mtl_parameters set attribute8 = vinsert
where organization_id = :new.organization_id;
commit;

end if;

end if;

exception when no_data_found then
:new.name := (:new.name||’B2′);
when others then
:new.name := (:new.name||’B1′);
end;
/

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_. There may be a network configuration problem, or the TNS listener on node FNDFS_ may not be running. Please contact your system administrator.

Error when tools->copy log file in oracle apps

solution : In the Profile Option, set profile value = “RRA: Enabled” to Yes

Cannot copy log from concurrent programs (oracle apps) error:An error occurred while attempting to establish an Applications File Server connection with the node

Cannot copy log from concurrent programs (oracle apps)

Error :

An error occurred while attempting to establish an Applications File Server connection with the node…….

Solution :

In the Profile Option –>system –> RRA ->RRA: Enabled is set as No in Site Level. Make it to Yes.

Save and Logout and Retest the Issue.

Reference Note id : 419142.1

Cek definition file (pld)

go to the file path and use  ” grep -i ‘$head’ ” (without “) to check definitions

ex:
# grep -i ‘$head’ INVMTXIT.pll
FDRCSID(‘$Header: INVMTXIT.pld 115.54 2004/05/26 16:58:14