Protected by Copyscape Web Copyright Protection Software

Search This Blog

Friday, June 28, 2013

Frequent Errors in Oracle apps

1) Error in Report while generating .XMl file.

REP-0069: Internal error
REP-57054: In-process job terminated: Terminated with error:
REP-1401: '': Fatal PL/SQL error occurred.

1) It shows this error because in formula column I wrote end if before RETURN clause.
So i wrote end if after the return clause then it will compile successfully


2) Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert to number

How to Add TNS names?


here in  last i added below tns code with ash symbols also.

How to change the report heading based on type?

In Ar invoice report Display Credit memo for type credit memo and debit memo for debit memo type invoices.


For this i took A form field in heading and increase size by ctrl+{ buttons or manually increase size because it is heading.

Then in  that form field write below code.

<?xdofx:if to_char(TYPE)='INV'  then ’TAX INVOICE’else if to_char(TYPE)='CM' then ’CREDIT MEMO’ else  ’DEBIT MEMO’ end if?>

The rtf Look like below...