Frequent Errors in Oracle apps

10-may-2013

-----------------

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.

Solution

------------

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

13-may-2013

-------------

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

How to Add TNS names?

D:\DevSuiteHome_2\NETWORK\ADMIN

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.

Solution
---------

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