Inconsistent Catalog View while executing a Oracle Stored Procedure from Java

This error is usually observed when a custom object that is either missing or its grants is missing is being used as a parameter in the stored procedure being called from Java.
To avoid this make sure your custom object is created and the user which is executing the procedure using the type has grants on it.

Using Nextval and Currval for Sequences

I was accessing a sequence HZ_PARTY_NUMBER_S from my APPS schema. when I executed the query it gave me the error:

SQL> SELECT hz_party_number_s.nextval FROM DUAL;

ORA-08002: sequence HZ_PARTY_NUMBER_S.CURRVAL is not yet defined in this session


After a couple of hit s on Google i learned that: "To access a sequence for the first time, you must refer to sequence.NEXTVAL before you can refer to sequence.CURRVAL. The first reference to NEXTVALreturns the initial value of the sequence."


also given were much useful info regarding sequences. so here you go:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls1016.htm

All the best with your sequences!

Invoice Register Report Output to HTML

Some days ago our Accounts Dept. submitted this query to me :
We are unable to open some standard reports (Account Receivable & Account Payable) in HTML. For example, Transaction Register in AR, Adjustment Register in AR, Invoice Register in Payables.

I executed these reports from the concurrent manager and saw that they are showing o/p as TEXT .


My first approach was to go to the Sys Admin responsibility --> Concurrent -> Programs --> Define form
I queried(F11 to enter query mode and Ctrl+F11 to query) for "Invoice Register" report and in the Output section changed the Output from text to HTML, Saved and exit.
When I executed Invoice Register from AP responsibility it finished with an Error not creating the O/p file.
The error read...
+---------------------------------------------------------------------------+
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this operating system.
APP-FND-01630: Cannot open file D:\oracle\PROD\inst\apps\PROD_techlogixof\appltmp\OF4BA.tmp for reading

Cause: USDINS encountered an error when attempting to open file D:\oracle\PROD\inst\apps\PROD_techlogixof\appltmp\OF4BA.tmp for reading.

Action: Verify that the file name is correct and that the environment variables controlling that filename are correct.

Action: If the file is opened in read mode, check that the file exists. Check that you have privileges to read the file in the file directory. Contact your system administrator to obtain read privileges.

Action: If the file is opened in write or append mode, check that you have privileges to create and write files in the file directory. Contact your system administrator to obtain create and write privileges.
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 595735.

Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+


It didn't helped in any way .

I checked the reports.log file located at D:\oracle\PROD\inst\apps\PROD_techlogixof\logs\appl\conc\log
and it said:
----------------------------------------------------------------------------------------------------------------------------------
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1212: Object 'M_currency_GRPFR' is not fully enclosed by its enclosing object 'Body'.
----------------------------------------------------------------------------------------------------------------------------------
 I picked up the report executable by querying the name for it from Sys Admin responsibility --> Concurrent ->Programs -->Executable and  readjusted the frame that wqas giving the error. Compiled and executed my report again with the changes.


Still when i executed the report from the Conc Manager it keeps executing successfully for TEXT style but not for HTML. 
In the end I changed the Cols from 132-->null and Rows from 45--> null and Style A4 in the Style options and Viola the report executed sucessfully with HTML output!


That's what helps, you've got to try every possibility. I adjusted the Rows and Cols later according to my Accounts people and the issue was resolved.




FYI:

Conc Manager Log Directory:
D:\oracle\PROD\inst\apps\PROD_techlogixof\logs\appl\conc\log
Conc Manager Output Directory:
D:\oracle\PROD\inst\apps\PROD_techlogixof\logs\appl\conc\out