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
This
was occurred when I click the preview in rtf.
Solution
------------
2)
Used to_number (String)
3)
Routine FDPREP cannot read the file
/oraapp/ERP/apps/apps_st/appl/ar/12.0.0/reports/US/ XXST_AR_INV_INTER.rep.
Check
if the file exists under correct product directory.
Solution
------------
3)
In above error observe carefully there is a space in front of .rep file name. Means
in executable remove space and
Save
4)
Enter Password:
REP-0004:
Warning: Unable to open user preference file.
REP-1316: After
Report Trigger references column 'inv_max' at wrong frequency.
REP-0069:
Internal error
REP-57054:
In-process job terminated: Terminated with error:
REP-1316: After
Report Trigger references column 'inv_max' at wrong frequency.
Solution
------------
4)
Here inv_max is in group in RDF data model but I took this field or formula
column or summary column in after report trigger
So
this error occurs what I do is I created that field (summary column) in report
level not group level so it was rectified.
07-Jun-2013
------------
5)
Enter Password:
REP-0004:
Warning: Unable to open user preference file.
REP-1401:
'cf_vend_nameformula': Fatal PL/SQL error occurred.
ORA-06502:
PL/SQL: numeric or value error
REP-0069:
Internal error
REP-57054:
In-process job terminated: Terminated with error:
REP-1401:
'cf_vend_nameformula': Fatal PL/SQL error occurred.
ORA-06502:
PL/SQL: numeric or value error
Solution
------------
5)
This error occurred because that formula column has a number data type but it returns
varchar values
So
I changed data type as char and size 100 then submit report works fine.
07-06-2013
----------
6)
Enter Password:
REP-0004:
Warning: Unable to open user preference file.
REP-1416:
'beforereport': User exit 'FND'. IAF GET: unknown column 'P_CONC_REQUEST_ID'.
REP-0069:
Internal error
REP-57054:
In-process job terminated: Terminated with error:
REP-1416:
'beforereport': User exit 'FND'. IAF GET: unknown column 'P_CONC_REQUEST_ID'.
Solution
-------------
6)
Whenever we use user exits in report without creating P_CONC_REQUEST_ID
parameter then this error will occur.
Action
---------
To
achieve this error you should create P_CONC_REQUEST_ID in user parameters of
your report.
17-Jun-2013
-------------------
Error:
Solution
------------
Use
errbuf and retcode in procedure because those are mandatory parameters.
19-Jun-2013
-------------------
Error
--------
REP-0091:
Invalid value for parameter 'P_VENDOR_NAME'.
Solution
------------
This
error occurred because in rdf P_VENDOR_NAME parameter having only 40 size but
value maximum is 58 so it occurred.
Action
---------
Increase
that widthto100 like below then it will solve.
20-Jun-2013
-------------------
Error
--------
Enter Password:
REP-0004: Warning: Unable to open user preference file.
MSG-01001: You have not defined your system parameters or your installation is incomplete.
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated: Terminated with error:
REP-1419: MSG-01001: You have not defined your system parameters or your installation is incomplete.
REP-1419: 'beforereport': PL/SQL program aborted.
Solution
-----------
In
Rdf Before Report Trigger if we forgot to give any Procedure/Parameter then
this error will occurred.
26-Jun-2013
-------------------
Error
--------
ORA-28115:
policy with check option violation occurred in package(package
name)
Solution
=======
This error
occurred when I call the standard package AP_AID_TABLE_HANDLER_PKG.INSERT_ROW
To insert data
into ap_invoice_distributions_all.
While inserting
into base table it will validate data. So if your data does not satisfy
validations then this error occurred.
Action
======
Check the data
if any validations violated then rectify it and insert through That API then it
will get success.
10-Jul-2013
==========
Error:
--SQLException
java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
Solution
=========
In ,xml file
there are 4 queries used by joining with union all.
So one of that
have different data type. But in my
query both are date data types.
But one query
having just date column name and one query have like this….
to_char(jpr.accounting_date,'YYYY-MM-DD"T"hh:mi:ss')
So this error
occurred.
Action
=====
In all queries I
used to_char for that column then it
was rectified and completed normal.
10-Jul-2013
==========
Error:
After creating
adhoc roles in workflow getting below error second time run.
Error Name WF_DUP_ROLE
Error Message 395: Duplicate role
Error Message 395: Duplicate role
Action
----------
Hai,
comment below
code then it will give any
error.
wf_directory.CreateAdHocRole(role_name =>
,
role_display_name
=>);
wf_directory.AddUsersToAdHocRole(role_name => '
'
, role_users
=> ' ' );because once you created role and assigned to user then no need to
do it again and again. so comment that code and check it.
31-Jul-2013
-------------------
Error: ORA-01861 Literal does not match format string
Solution:
Problem with date format.
In valuset I
used below condition.
and
to_char(payment_date) between to_char(:$FLEX$.FND_STANDARD_DATE) and
to_char(:$FLEX$.FND_STANDARD_DATE1)
Here
fnd_standard_date1 returns date format as “'YYYY/MM/DD HH24:MI:SS'” so it cause
this error.
Action
----------
So finally I
used like this then was worked fine.
and
to_char(payment_date,'YYYY/MM/DD HH24:MI:SS') between to_char(:$FLEX$.FND_STANDARD_DATE)
and to_char(:$FLEX$.FND_STANDARD_DATE1)
Excellent work Mr.
ReplyDelete