1 2 Previous Next 19 Replies Latest reply on Sep 21, 2013 5:56 AM by rmotiani Go to original post
      • 15. Re: Unable to launch seeded iProcurment Shopping Cart page from jDeveloper
        user1672924
        Hi Keerthi,

        I am happy to tell you that the customization is working as expected, all thanks to you.
        Your solution worked perfectly fine.

        The only issue(if at all it is one) is that since I have used fnd_messages in my code whenever I am changing the message in EBS it doesn't reflect in the page and as per earlier posts in this forum we have to bounce the application server to reflect the updated message,which really is a major disappointment.

        And yes,I deployed and re-deployed the extended controller without bouncing the Application server,so I guess it was a myth that server bounce is mandatory. :-)

        Finally thanks to your step-by-step guidance which made this customisation a possibility even though it was a very minor one.I am sorry I couldn't give you the 10 points for correct answer as the link for the same is not appearing in your latest post.

        Regards,
        Anushka
        • 16. Re: Unable to launch seeded iProcurment Shopping Cart page from jDeveloper
          user1672924
          Hi Keerthi,

          The link for marking an answer as correct re-appeared so I have marked your post as correct.
          I hope this post will be helpful to others who face the same issue.

          Thanks a lot again. :-)

          Regards,
          Anushka
          • 17. Re: Unable to launch seeded iProcurment Shopping Cart page from jDeveloper
            keerthioaf
            Hi Anushka ,

            Thanks for the update , and Glad to know that you 've fixed the issue , i believe the you must have overridden the controller class multiple times
            hence you would need to server bounce .

            There is way to bypass Apache bounce , here is the link

            Re: Why to bounce server after deployment?

            --Keerthi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
            • 18. Re: Unable to launch seeded iProcurment Shopping Cart page from jDeveloper
              user1672924
              Hi Keerthi,

              That is the exact approach that I have followed for deploying the class files.

              But the issue is with fnd_messsages.I can change the name of the message every time I want to update the message,but then I will have to change the message name in the controller java file also and re-deploy it.Also I will have to change the controller name in the page.As you can imagine it's not practical.

              But its not a big deal because we will decide on the final exception message and bounce the server once as a one-time activity,from there on it should be smooth sailing.

              Thanks again for your help.

              Regards,
              Anushka
              • 19. Re: Unable to launch seeded iProcurment Shopping Cart page from jDeveloper
                rmotiani

                Dear All,

                 

                I am trying to run standard iProcurement Shopping cart page through jDevloper10g in R12.1.3 instance but on click of "View Cart and checkout button"

                it gives an exception as "ArrayIndexOutOfBoundsException".

                 

                I had copied these .class & .xml files under Myclasses -> oracle.apps.icx and oracle.apps.po and oracle.apps.fnd was same which comes part of the standard OA tutorial.

                I copied same under Myprojects as well.

                 

                When I access the page directly from the instance it works fine. Problem is only through jDeveloper.

                Please advice what is missing here.

                 

                I tried debugging as well in jDEV and below is the log of the same. I noticed every time when VO is called, while binding numeric values it throws error.

                 

                Regards

                Rohit

                ======================

                Debug Info

                ======================

                13/09/20 09:22:12 [403] BC4J Property jbo.use.pers.coll='false' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [404] BC4J Property jbo.pers.max.rows.per.node='70' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [405] BC4J Property jbo.pers.max.active.nodes='30' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [406] Skipping empty Property jbo.pcoll.mgr from System Default

                13/09/20 09:22:12 [407] BC4J Property jbo.txn_table_name='FND_PS_TXN' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [408] BC4J Property jbo.txn_seq_name='FND_PS_TXN_S' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [409] BC4J Property jbo.txn_seq_inc='1' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [410] BC4J Property jbo.control_table_name='FND_PCOLL_CONTROL' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [411] BC4J Property jbo.stringmanager.factory.class='use_default' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [412] BC4J Property jbo.domain.date.suppress_zero_time='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [413] BC4J Property jbo.domain.bind_sql_date='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [414] BC4J Property jbo.domain.string.as.bytes.for.raw='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [415] BC4J Property jbo.fetch.mode='AS.NEEDED' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [416] BC4J Property jbo.323.compatible='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [417] BC4J Property jbo.903.compatible='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [418] Skipping empty Property JBODynamicObjectsPackage from System Default

                13/09/20 09:22:12 [419] BC4J Property MetaObjectContextFactory='oracle.jbo.mom.xml.DefaultMomContextFactory' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [420] BC4J Property jbo.load.components.lazily='false' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [421] BC4J Property MetaObjectContext='oracle.adf.mds.jbo.JBODefManager' -->(MetaObjectManager) from System Property

                13/09/20 09:22:12 [422] BC4J Property java.naming.factory.initial='oracle.jbo.common.JboInitialContextFactory' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [423] BC4J Property IsLazyLoadingTrue='true' -->(MetaObjectManager) from /oracle/jbo/server/jboserver.properties resource

                13/09/20 09:22:12 [424] BC4J Property oracle.jbo.usemds='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [425] BC4J Property oracle.adfm.usemds='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [426] BC4J Property ActivateSharedDataHandle='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [427] Skipping empty Property HandleName from System Default

                13/09/20 09:22:12 [428] Skipping empty Property Factory-Substitution-List from System Default

                13/09/20 09:22:12 [429] Skipping empty Property jbo.project from System Default

                13/09/20 09:22:12 [430] BC4J Property jbo.max.cursors='50' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [431] BC4J Property jbo.dofailover='false' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [432] BC4J Property jbo.ampool.writecookietoclient='true' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [433] BC4J Property jbo.doconnectionpooling='false' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [434] BC4J Property jbo.recyclethreshold='10' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [435] BC4J Property jbo.ampool.dynamicjdbccredentials='true' -->(Configuration) from System Default

                13/09/20 09:22:12 [436] BC4J Property jbo.ampool.resetnontransactionalstate='false' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [437] BC4J Property jbo.ampool.sessioncookiefactoryclass='oracle.apps.fnd.framework.webui.OAHttpSessionCookieFactory' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [438] BC4J Property jbo.ampool.connectionstrategyclass='oracle.apps.fnd.framework.OAConnectionStrategy' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [439] BC4J Property jbo.ampool.maxpoolsize='2147483647' -->(Configuration) from System Default

                13/09/20 09:22:12 [440] BC4J Property jbo.ampool.initpoolsize='0' -->(Configuration) from System Default

                13/09/20 09:22:12 [441] BC4J Property jbo.ampool.monitorsleepinterval='300000' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [442] BC4J Property jbo.ampool.minavailablesize='0' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [443] BC4J Property jbo.ampool.maxavailablesize='10' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [444] BC4J Property jbo.ampool.maxinactiveage='180000' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [445] BC4J Property jbo.ampool.timetolive='3600000' -->(Configuration) from System Default

                13/09/20 09:22:12 [446] BC4J Property jbo.ampool.doampooling='true' -->(Configuration) from System Default

                13/09/20 09:22:12 [447] BC4J Property jbo.ampool.isuseexclusive='true' -->(Configuration) from System Default

                13/09/20 09:22:12 [448] BC4J Property jbo.passivationstore='database' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [449] BC4J Property jbo.saveforlater='false' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [450] BC4J Property jbo.snapshotstore.undo='persistent' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [451] BC4J Property jbo.maxpassivationstacksize='10' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [452] BC4J Property jbo.txn.handleafterpostexc='false' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [453] BC4J Property jbo.connectfailover='true' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [454] BC4J Property jbo.maxpoolcookieage='-1' -->(Configuration) from System Default

                13/09/20 09:22:12 [455] BC4J Property PoolClassName='oracle.apps.fnd.framework.OAApplicationPoolImpl' -->(Configuration) from Client Environment

                13/09/20 09:22:12 [456] BC4J Property jbo.maxpoolsize='5' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [457] BC4J Property jbo.initpoolsize='0' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [458] BC4J Property jbo.poolrequesttimeout='5000' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [459] BC4J Property jbo.poolmonitorsleepinterval='600000' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [460] BC4J Property jbo.poolminavailablesize='5' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [461] BC4J Property jbo.poolmaxavailablesize='25' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [462] BC4J Property jbo.poolmaxinactiveage='600000' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [463] BC4J Property jbo.pooltimetolive='3600000' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [464] BC4J Property RELEASE_MODE='Stateful' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [465] BC4J Property jbo.assoc.consistent='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [466] BC4J Property jbo.viewlink.consistent='DEFAULT' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [467] BC4J Property jbo.passivation.TrackInsert='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [468] Skipping empty Property jbo.ViewCriteriaAdapter from System Default

                13/09/20 09:22:12 [469] BC4J Property jbo.SQLBuilder='oracle.apps.fnd.framework.server.OAOracleSQLBuilderImpl' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [470] BC4J Property jbo.ConnectionPoolManager='oracle.apps.fnd.framework.server.OAConnectionPoolManagerImpl' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:12 [471] BC4J Property jbo.TypeMapEntries='Oracle' -->(MetaObjectManager) from /oracle/jbo/server/jboserver.properties resource

                13/09/20 09:22:12 [472] Skipping empty Property jbo.sql92.JdbcDriverClass from System Default

                13/09/20 09:22:12 [473] BC4J Property jbo.sql92.LockTrailer='FOR UPDATE' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [474] BC4J Property jbo.jdbc.trace='true' -->(MetaObjectManager) from System Property

                13/09/20 09:22:12 [475] BC4J Property jbo.abstract.base.check='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [476] BC4J Property jbo.assoc.where.early.set='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [477] BC4J Property jbo.sql92.DbTimeQuery='select sysdate from dual' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [478] BC4J Property oracle.jbo.defineColumnLength='as_chars' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [479] BC4J Property jbo.jdbc_bytes_conversion='jdbc' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [480] Skipping empty Property jbo.tmpdir from System Default

                13/09/20 09:22:12 [481] Skipping empty Property jbo.server.internal_connection from System Default

                13/09/20 09:22:12 [482] Skipping empty Property SessionClass from System Default

                13/09/20 09:22:12 [483] Skipping empty Property TransactionFactory from System Default

                13/09/20 09:22:12 [484] Skipping empty Property jbo.def.mgr.listener from System Default

                13/09/20 09:22:12 [485] BC4J Property jbo.debugoutput='console' -->(Diagnostic) from System Property

                13/09/20 09:22:12 [486] BC4J Property jbo.debug.prefix='DBG: ' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:12 [487] BC4J Property jbo.logging.show.timing='false' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:12 [488] BC4J Property jbo.logging.show.function='false' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:12 [489] BC4J Property jbo.logging.show.level='false' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:12 [490] BC4J Property jbo.logging.show.linecount='true' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:12 [491] BC4J Property jbo.logging.trace.threshold='9' -->(Diagnostic) from System Property

                13/09/20 09:22:12 [492] BC4J Property jbo.jdbc.driver.verbose='true' -->(Diagnostic) from System Property

                13/09/20 09:22:12 [493] BC4J Property oracle.home='C:\jDev10g\jdevbin' -->(Diagnostic) from System Property

                13/09/20 09:22:12 [494] Skipping empty Property oc4j.name from System Default

                13/09/20 09:22:12 [495] BC4J Property jbo.ejb.txntimeout='1830' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [496] BC4J Property jbo.ejb.txntype='global' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [497] BC4J Property jbo.ejb.txn.disconnect_on_completion='false' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [498] Skipping empty Property jbo.ejb.useampool from System Default

                13/09/20 09:22:12 [499] Skipping empty Property oracle.jbo.schema from System Default

                13/09/20 09:22:12 [500] BC4J Property jbo.xml.validation='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [501] BC4J Property ord.RetrievePath='ordDeliverMedia' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [502] BC4J Property ord.HttpMaxMemory='102400' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [503] Skipping empty Property ord.HttpTempDir from System Default

                13/09/20 09:22:12 [504] BC4J Property ord.wmp.classid='clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [505] BC4J Property ord.qp.classid='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [506] BC4J Property ord.rp.classid='clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [507] BC4J Property ord.wmp.codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [508] BC4J Property ord.qp.codebase='http://www.apple.com/qtactivex/qtplugin.cab' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [509] Skipping empty Property ord.rp.codebase from System Default

                13/09/20 09:22:12 [510] BC4J Property ord.wmp.plugins.page='http://www.microsoft.com/isapi/redir.dll?prd=windows&sbp=mediaplayer&ar=Media&sba=Plugin&' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [511] BC4J Property ord.qp.plugins.page='http://www.apple.com/quicktime/download/' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [512] BC4J Property ord.rp.plugins.page='http://www.real.com/player/' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [513] BC4J Property jbo.security.enforce='None' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [514] BC4J Property jbo.security.loginmodule='oracle.security.jazn.tools.Admintool' -->(SessionImpl) from System Default

                13/09/20 09:22:12 [515] Skipping empty Property jbo.security.config from System Default

                13/09/20 09:22:12 [516] BC4J Property jbo.server.useNullDbTransaction='true' -->(SessionImpl) from Client Environment

                13/09/20 09:22:12 [517] BC4J Property jbo.domain.reopenblobstream='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:12 [518] Copying unknown Client property (Sid='1528') to session

                13/09/20 09:22:12 [519] Copying unknown Client property (DBC_FILE_NAME='C:\jDev10g\jdevhome\jdev\dbc_files\secure\EGLDEV2.dbc.dbc') to session

                13/09/20 09:22:12 [520] Copying unknown Client property (ApplicationModuleName='oracle.apps.icx.por.req.server.RequisitionAM') to session

                13/09/20 09:22:12 [521] Copying unknown Client property (DB_HOST_NAME='eglfdbd1.rhb.my') to session

                13/09/20 09:22:12 [522] Copying unknown Client property (OADeveloperMode='1') to session

                13/09/20 09:22:12 [523] Copying unknown Client property (OA_JSP_MODE='Y') to session

                13/09/20 09:22:12 [524] Copying unknown Client property (java.naming.factory.url.pkgs='oracle.oc4j.naming.url') to session

                13/09/20 09:22:12 [525] Copying unknown Client property (ConnectMode='Local') to session

                13/09/20 09:22:12 [526] Copying unknown Client property (COOKIE_ID='qkLJ4a8mNoGGEj4VYXZ9rNoo6N') to session

                13/09/20 09:22:12 [527] Copying unknown Client property (OADiagnostic='1') to session

                13/09/20 09:22:12 [528] Copying unknown Client property (ServerName='172.30.90.61') to session

                13/09/20 09:22:12 [529] Copying unknown Client property (JndiPath='test') to session

                13/09/20 09:22:12 [530] Copying unknown Client property (FNDNAM='APPS') to session

                13/09/20 09:22:12 [531] Copying unknown Client property (ImageBase='OA_MEDIA\') to session

                13/09/20 09:22:12 [532] Copying unknown Client property (jbo.applicationmoduleclassname='oracle.apps.icx.por.req.server.RequisitionAM') to session

                13/09/20 09:22:12 [533] Copying unknown Client property (jbo.jdbc.connectstring='jdbc:oracle:thin:APPLSYSPUB/PUB@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=eglfdbd1.rhb.my)(PORT=1528)))(CONNECT_DATA=(SID=1528)))') to session

                13/09/20 09:22:12 [534] Copying unknown Client property (GWYUID='APPLSYSPUB/PUB') to session

                13/09/20 09:22:12 [535] Copying unknown Client property (ServerPort='8988') to session

                13/09/20 09:22:12 [536] }} finished loading BC4J properties

                13/09/20 09:22:12 [537] -----------------------------------------------------------

                13/09/20 09:22:12 [538] Connected to Oracle JBO Server - Version: 10.1.3.41.57

                13/09/20 09:22:12 [539] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:12 [540] CSMessageBundle (language base) being initialized

                13/09/20 09:22:12 [541] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:12 [542] Business Object Browsing may be unavailable

                13/09/20 09:22:12 [543] Loading from XML file /oracle/apps/icx/por/req/server/RequisitionAM.xml

                13/09/20 09:22:12 [544] Created root application module: 'oracle.apps.icx.por.req.server.RequisitionAM'

                13/09/20 09:22:12 [545] Locale is: 'en_US'

                13/09/20 09:22:12 [546] ApplicationPoolImpl.resourceStateChanged wasn't release related. No notify invoked.

                13/09/20 09:22:12 [547] OAApplicationPoolImpl.setConnectionReleaseLevel was called with isReleased = false, isReserved = false

                13/09/20 09:22:12 [548] mPCollUsePMgr is false

                13/09/20 09:22:12 [549] ViewObjectImpl.mDefaultMaxRowsPerNode is 70

                13/09/20 09:22:12 [550] ViewObjectImpl.mDefaultMaxActiveNodes is 30

                13/09/20 09:22:12 [551] Oracle SQLBuilder: Registered driver: oracle.jdbc.driver.OracleDriver

                13/09/20 09:22:12 [552] import java.util.*;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [553] import java.sql.*;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [554] import java.io.*;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [555] public class JDBCCalls  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [556] {  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [557]    public Connection conn = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [558]    public CallableStatement cStmt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [559]    public PreparedStatement pStmt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [560]    public Statement stmt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [561]    public ResultSet rslt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [562]    public static void main(String argv[])  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [563]    {  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [564]       DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [565]       conn = DriverManager.getConnection("jdbc:oracle:thin:APPLSYSPUB/PUB@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=eglfdbd1.rhb.my)(PORT=1528)))(CONNECT_DATA=(SID=1528)))", /*properties*/);  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [566]       conn.setAutoCommit(false);  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [567] Successfully logged in

                13/09/20 09:22:12 [568] JDBCDriverVersion: 10.1.0.5.0

                13/09/20 09:22:12 [569] DatabaseProductName: Oracle

                13/09/20 09:22:12 [570] DatabaseProductVersion: Oracle Database 11g Release 11.1.0.0.0 - Production

                13/09/20 09:22:12 [571] Root application module, oracle.apps.icx.por.req.server.RequisitionAM, was created at 2013-09-20 09:22:12.35

                13/09/20 09:22:12 [572] setConnectionReleaseLevel - Set connection release level to 0

                13/09/20 09:22:12 [573]       cStmt = conn.prepareCall("begin dbms_application_info.set_module(:1, :2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [574]       cStmt = conn.prepareCall("BEGIN mo_global.init(:1); END;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [575] OAPB: Page Securing Expression = ${oa.FunctionSecurity.ICX_POR_SHOPPING_CART}

                13/09/20 09:22:12 [576]

                <ICX_SessionValues_Diagnostics - ICX Cookie = qkLJ4a8mNoGGEj4VYXZ9rNoo6N>: WebRequestUtil.validateContext is called.

                13/09/20 09:22:12 [577]

                <ICX_SessionValues_Diagnostics - ICX Cookie = qkLJ4a8mNoGGEj4VYXZ9rNoo6N>: WebRequestUtil.validateContext returned status = VALID.

                ICX Session Values after WebRequestUtil.validateContext:

                ===========================================================================

                <ICX_SessionValues_Diagnostics - ICX Cookie = qkLJ4a8mNoGGEj4VYXZ9rNoo6N>:

                Current ICX Session (Oracle Applications User Session) Values:

                1. User ID (DB, ICX_SESSIONS) = 1118

                2. Responsibility ID (DB, ICX_SESSIONS) = 21584

                3. Responsibility Application ID (DB, ICX_SESSIONS) = 178

                4. Org ID (DB, ICX_SESSIONS) = 88

                5. Org ID (DB, CLIENT_INFO) = -1

                6. Org ID (ProfileStore.getProfile) = 88

                7. Org ID (ProfileStore.getSpecificProfile with new ICX_SESSIONS values) = 88

                8. Employee ID (DB, FND_GLOBAL.EMPLOYEE_ID) = 157

                9. Employee ID (AppsContext.getFNDGlobal) = 157

                10. Function ID (DB, ICX_SESSIONS) = -1

                11. Security Group ID (DB, ICX_SESSIONS) = 0

                ===========================================================================

                 

                13/09/20 09:22:12 [578]       cStmt = conn.prepareCall("BEGIN mo_global.init(:1); END;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [579] New Language Code = null

                13/09/20 09:22:12 [580] Current Language Code = US

                13/09/20 09:22:12 [581] _1>#q computed SQLStmtBufLen: 64, actual=24, storing=54

                13/09/20 09:22:12 [582] select sysdate from dual

                13/09/20 09:22:12 [583]       pStmt = conn.prepareStatement("select sysdate from dual");  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [584] *** createViewAttributeDefImpls: oracle.jdbc.driver.T4CPreparedStatement@2bc102

                13/09/20 09:22:12 [585] Bind params for ViewObject: _1

                13/09/20 09:22:12 [586] Column count: 1

                13/09/20 09:22:12 [587] Column count: 1

                13/09/20 09:22:12 [588] ViewObject: _1 Created new QUERY statement

                13/09/20 09:22:12 [589] _1>#q old SQLStmtBufLen: 54, actual=24, storing=54

                13/09/20 09:22:12 [590] select sysdate from dual

                13/09/20 09:22:12 [591]       pStmt = conn.prepareStatement("select sysdate from dual");  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [592] Bind params for ViewObject: _1

                13/09/20 09:22:12 [593] ViewObject: _1 close prepared statements...

                13/09/20 09:22:12 [594]       pStmt.close();  // JBO-JDBC-INTERACT

                13/09/20 09:22:12 [595] ##### QueryCollection.finl no RowFilter

                13/09/20 09:22:13 [596] Loading from XML file /oracle/apps/ak/region/server/server.xml

                13/09/20 09:22:13 [597] Loading from individual XML files

                13/09/20 09:22:13 [598] Loading the Containees for the Package 'oracle.apps.ak.region.server.server'.

                13/09/20 09:22:13 [599] Loading from XML file /oracle/apps/ak/region/server/AkAmParameterRegistryVO.xml

                13/09/20 09:22:13 [600] ViewDef: oracle.apps.ak.region.server.AkAmParameterRegistryVO using glue class

                13/09/20 09:22:13 [601] Column count: 2

                13/09/20 09:22:13 [602] ViewObject: AkAmParameterRegistryVO Created new QUERY statement

                13/09/20 09:22:13 [603] AkAmParameterRegistryVO>#q computed SQLStmtBufLen: 140, actual=100, storing=130

                13/09/20 09:22:13 [604] select PARAM_NAME, PARAM_SOURCE

                from AK_AM_PARAMETER_REGISTRY

                where APPLICATIONMODULE_DEFN_NAME = :1

                13/09/20 09:22:13 [605]       pStmt = conn.prepareStatement("select PARAM_NAME, PARAM_SOURCE

                from AK_AM_PARAMETER_REGISTRY

                where APPLICATIONMODULE_DEFN_NAME = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:13 [606] Bind params for ViewObject: AkAmParameterRegistryVO

                13/09/20 09:22:13 [607] Binding param 1: oracle.apps.icx.por.req.server.RequisitionAM

                13/09/20 09:22:13 [608]       pStmt.setObject(1, "oracle.apps.icx.por.req.server.RequisitionAM");  // JBO-JDBC-INTERACT

                13/09/20 09:22:13 [609] Column count: 4

                13/09/20 09:22:13 [610] ViewObject: FndApplicationVO_2 close prepared statements...

                13/09/20 09:22:13 [611] ViewObject: FndApplicationVO_2 Created new QUERY statement

                13/09/20 09:22:13 [612] FndApplicationVO_2>#q computed SQLStmtBufLen: 277, actual=259, storing=289

                13/09/20 09:22:13 [613] SELECT * FROM (select application_short_name||'  '||to_char(application_id)||'  '||application_name application, application_id, application_short_name, application_name

                from fnd_application_vl) QRSLT  WHERE (application_id=:1) ORDER BY application_short_name

                13/09/20 09:22:13 [614]       pStmt = conn.prepareStatement("SELECT * FROM (select application_short_name||'  '||to_char(application_id)||'  '||application_name application, application_id, application_short_name, application_name

                from fnd_application_vl) QRSLT  WHERE (application_id=:1) ORDER BY application_short_name");  // JBO-JDBC-INTERACT

                13/09/20 09:22:13 [615] Bind params for ViewObject: FndApplicationVO_2

                13/09/20 09:22:13 [616] Binding param 1: 0

                13/09/20 09:22:13 [617]       pStmt.setObject(1, new Integer(0));  // JBO-JDBC-INTERACT

                13/09/20 09:22:13 [618] Could not find method:getApplicationShortName in oracle.apps.fnd.framework.server.OAViewRowImpl__Glue__ - oracle.apps.fnd.framework.server.OAViewRowImpl__Glue__.getApplicationShortName()

                13/09/20 09:22:13 [619] Could not find method:getApplicationShortName in oracle.apps.fnd.framework.server.OAViewRowImpl - oracle.apps.fnd.framework.server.OAViewRowImpl.getApplicationShortName()

                13/09/20 09:22:13 [620] Could not find method:getApplicationShortName in oracle.jbo.server.OAJboViewRowImpl - oracle.jbo.server.OAJboViewRowImpl.getApplicationShortName()

                13/09/20 09:22:13 [621] Could not find method:getApplicationShortName in oracle.jbo.server.ViewRowServiceImpl - oracle.jbo.server.ViewRowServiceImpl.getApplicationShortName()

                13/09/20 09:22:13 [622] Could not find method:setApplicationShortName in oracle.apps.fnd.framework.server.OAViewRowImpl__Glue__ - oracle.apps.fnd.framework.server.OAViewRowImpl__Glue__.setApplicationShortName(java.lang.String)

                13/09/20 09:22:13 [623] Could not find method:setApplicationShortName in oracle.apps.fnd.framework.server.OAViewRowImpl - oracle.apps.fnd.framework.server.OAViewRowImpl.setApplicationShortName(java.lang.String)

                13/09/20 09:22:13 [624] Could not find method:setApplicationShortName in oracle.jbo.server.OAJboViewRowImpl - oracle.jbo.server.OAJboViewRowImpl.setApplicationShortName(java.lang.String)

                13/09/20 09:22:13 [625] Could not find method:setApplicationShortName in oracle.jbo.server.ViewRowServiceImpl - oracle.jbo.server.ViewRowServiceImpl.setApplicationShortName(java.lang.String)

                13/09/20 09:22:13 [626] ViewObject: FndApplicationVO_2 close prepared statements...

                13/09/20 09:22:13 [627]       pStmt.close();  // JBO-JDBC-INTERACT

                13/09/20 09:22:13 [628] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [629] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [630] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [631] ##### QueryCollection.finl no RowFilter

                13/09/20 09:22:13 [632] Loading from XML file /oracle/apps/icx/por/req/server/PoRequisitionLinesVO.xml

                13/09/20 09:22:13 [633] Loading from XML file /oracle/apps/icx/por/schema/server/server.xml

                13/09/20 09:22:13 [634] Loading from individual XML files

                13/09/20 09:22:13 [635] Loading the Containees for the Package 'oracle.apps.icx.por.schema.server.server'.

                13/09/20 09:22:13 [636] Loading from XML file /oracle/apps/icx/por/schema/server/PoRequisitionLineEO.xml

                13/09/20 09:22:13 [637] Loading from XML file /oracle/apps/icx/por/schema/server/PoRequisitionLineEO.xml

                13/09/20 09:22:13 [638] Loading from XML file /oracle/apps/icx/por/schema/server/PoRequisitionHeaderEO.xml

                13/09/20 09:22:13 [639] Loading from XML file /oracle/apps/icx/por/schema/server/PorItemAttributeValueEO.xml

                13/09/20 09:22:13 [640] ViewRowSetImpl's jbo.viewlink.consistent = default (2)

                13/09/20 09:22:13 [641] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [642] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [643] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [644] Loading from XML file /oracle/apps/icx/por/req/server/PoRequisitionHeadersVO.xml

                13/09/20 09:22:13 [645] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [646] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [647] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [648] Loading from XML file /oracle/apps/icx/por/req/server/ReqHeaderToReqLinesVL.xml

                13/09/20 09:22:13 [649] Loading from XML file /oracle/apps/icx/por/schema/server/ReqHeaderToReqLinesAO.xml

                13/09/20 09:22:13 [650] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [651] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [652] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [653] Loading from XML file /oracle/apps/icx/por/req/server/ReqLineToDistributionsVL.xml

                13/09/20 09:22:13 [654] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [655] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [656] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [657] Loading from XML file /oracle/apps/icx/por/req/server/PoReqDistributionsVO.xml

                13/09/20 09:22:13 [658] Loading from XML file /oracle/apps/icx/por/schema/server/PoReqDistributionEO.xml

                13/09/20 09:22:13 [659] Loading from XML file /oracle/apps/icx/por/schema/server/PoReqDistributionEO.xml

                13/09/20 09:22:13 [660] Loading from XML file /oracle/apps/icx/por/schema/server/ReqLineToDistributionsAO.xml

                13/09/20 09:22:13 [661] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [662] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [663] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [664] Loading from XML file /oracle/apps/icx/por/req/server/ReqLineToInfoTemplatesVL.xml

                13/09/20 09:22:13 [665] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [666] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [667] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [668] Loading from XML file /oracle/apps/icx/por/req/server/PorInfoTemplatesVO.xml

                13/09/20 09:22:13 [669] Loading from XML file /oracle/apps/icx/por/schema/server/PorTemplateInfoEO.xml

                13/09/20 09:22:13 [670] Loading from XML file /oracle/apps/icx/por/schema/server/PorTemplateInfoEO.xml

                13/09/20 09:22:13 [671] Loading from XML file /oracle/apps/icx/por/schema/server/ReqLineToInfoTemplatesAO.xml

                13/09/20 09:22:13 [672] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [673] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [674] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [675] Loading from XML file /oracle/apps/icx/por/req/server/ReqLineToOneTimeLocationsVL.xml

                13/09/20 09:22:13 [676] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [677] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [678] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [679] Loading from XML file /oracle/apps/icx/por/req/server/OneTimeLocationsVO.xml

                13/09/20 09:22:13 [680] Loading from XML file /oracle/apps/icx/por/schema/server/ReqLineToItemAttrValuesAO.xml

                13/09/20 09:22:13 [681] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [682] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [683] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [684] Loading from XML file /oracle/apps/icx/por/req/server/ReqLineToReqSuppliersVL.xml

                13/09/20 09:22:13 [685] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [686] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:13 [687] Business Object Browsing may be unavailable

                13/09/20 09:22:13 [688] Loading from XML file /oracle/apps/icx/por/req/server/PoReqSuppliersVO.xml

                13/09/20 09:22:13 [689] Loading from XML file /oracle/apps/icx/por/schema/server/PoRequisitionSupplierEO.xml

                13/09/20 09:22:13 [690] Loading from XML file /oracle/apps/icx/por/schema/server/ReqLineToReqSuppliersAO.xml

                13/09/20 09:22:13 [691] addBreadCrumb: N

                13/09/20 09:22:14 [692] No XML file /oracle/apps/icx/por/req/server/server.xml for metaobject oracle.apps.icx.por.req.server.server

                13/09/20 09:22:14 [693] Cannot Load parent Package : oracle.apps.icx.por.req.server.server

                13/09/20 09:22:14 [694] Business Object Browsing may be unavailable

                13/09/20 09:22:14 [695] Loading from XML file /oracle/apps/icx/por/req/server/ActiveReqHeaderVO.xml

                13/09/20 09:22:14 [696] Column count: 1

                13/09/20 09:22:14 [697] ViewObject: ActiveReqHeaderVO Created new QUERY statement

                13/09/20 09:22:14 [698] ActiveReqHeaderVO>#q computed SQLStmtBufLen: 180, actual=140, storing=170

                13/09/20 09:22:14 [699] SELECT requisition_header_id

                FROM po_requisition_headers_all

                WHERE active_shopping_cart_flag = 'Y'

                AND last_updated_by = :1

                AND org_id = :2

                13/09/20 09:22:14 [700]       pStmt = conn.prepareStatement("SELECT requisition_header_id

                FROM po_requisition_headers_all

                WHERE active_shopping_cart_flag = 'Y'

                AND last_updated_by = :1

                AND org_id = :2");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [701] Bind params for ViewObject: ActiveReqHeaderVO

                13/09/20 09:22:14 [702] Binding param 1: 1118

                13/09/20 09:22:14 [703]       pStmt.setObject(1, new Integer(1118));  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [704] Binding param 2: 88

                13/09/20 09:22:14 [705]       pStmt.setObject(2, new Integer(88));  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [706] Column count: 84

                13/09/20 09:22:14 [707] ViewObject: PoRequisitionHeadersVO Created new QUERY statement

                13/09/20 09:22:14 [708] PoRequisitionHeadersVO>#q computed SQLStmtBufLen: 3336, actual=3246, storing=3276

                13/09/20 09:22:14 [709] SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE,         PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE,          PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID,          PoRequisitionHeaderEO.CLOSED_CODE,         PoRequisitionHeaderEO.ORG_ID,          PoRequisitionHeaderEO.DESCRIPTION,         PoRequisitionHeaderEO.AUTHORIZATION_STATUS,          PoRequisitionHeaderEO.NOTE_TO_AUTHORIZER,         PoRequisitionHeaderEO.TYPE_LOOKUP_CODE,          PoRequisitionHeaderEO.TRANSFERRED_TO_OE_FLAG,          PoRequisitionHeaderEO.ATTRIBUTE_CATEGORY,         PoRequisitionHeaderEO.ON_LINE_FLAG,          PoRequisitionHeaderEO.PRELIMINARY_RESEARCH_FLAG,          PoRequisitionHeaderEO.RESEARCH_COMPLETE_FLAG,         PoRequisitionHeaderEO.PREPARER_FINISHED_FLAG,          PoRequisitionHeaderEO.PREPARER_FINISHED_DATE,          PoRequisitionHeaderEO.AGENT_RETURN_FLAG,         PoRequisitionHeaderEO.AGENT_RETURN_NOTE,          PoRequisitionHeaderEO.CANCEL_FLAG,         PoRequisitionHeaderEO.USSGL_TRANSACTION_CODE,          PoRequisitionHeaderEO.GOVERNMENT_CONTEXT,         PoRequisitionHeaderEO.REQUEST_ID,          PoRequisitionHeaderEO.PROGRAM_APPLICATION_ID,          PoRequisitionHeaderEO.PROGRAM_ID,         PoRequisitionHeaderEO.REQUISITION_HEADER_ID,          PoRequisitionHeaderEO.PREPARER_ID,         PoRequisitionHeaderEO.LAST_UPDATE_DATE,          PoRequisitionHeaderEO.LAST_UPDATED_BY,         PoRequisitionHeaderEO.SEGMENT1,          PoRequisitionHeaderEO.SUMMARY_FLAG,         PoRequisitionHeaderEO.ENABLED_FLAG,          PoRequisitionHeaderEO.START_DATE_ACTIVE,         PoRequisitionHeaderEO.END_DATE_ACTIVE,          PoRequisitionHeaderEO.LAST_UPDATE_LOGIN,         PoRequisitionHeaderEO.CREATION_DATE,          PoRequisitionHeaderEO.CREATED_BY,         PoRequisitionHeaderEO.WF_ITEM_TYPE,          PoRequisitionHeaderEO.WF_ITEM_KEY,         PoRequisitionHeaderEO.EMERGENCY_PO_NUM,          PoRequisitionHeaderEO.PCARD_ID,         PoRequisitionHeaderEO.APPS_SOURCE_CODE,          PoRequisitionHeaderEO.SEGMENT2,         PoRequisitionHeaderEO.SEGMENT3,          PoRequisitionHeaderEO.SEGMENT4,         PoRequisitionHeaderEO.SEGMENT5,          PoRequisitionHeaderEO.ATTRIBUTE1,         PoRequisitionHeaderEO.ATTRIBUTE2,          PoRequisitionHeaderEO.ATTRIBUTE3,         PoRequisitionHeaderEO.ATTRIBUTE4,          PoRequisitionHeaderEO.ATTRIBUTE5,         PoRequisitionHeaderEO.ATTRIBUTE6,          PoRequisitionHeaderEO.ATTRIBUTE7,         PoRequisitionHeaderEO.ATTRIBUTE8,          PoRequisitionHeaderEO.ATTRIBUTE9,         PoRequisitionHeaderEO.ATTRIBUTE10,          PoRequisitionHeaderEO.ATTRIBUTE11,         PoRequisitionHeaderEO.ATTRIBUTE12,          PoRequisitionHeaderEO.ATTRIBUTE13,         PoRequisitionHeaderEO.ATTRIBUTE14,          PoRequisitionHeaderEO.ATTRIBUTE15,         PoRequisitionHeaderEO.CBC_ACCOUNTING_DATE,          PoRequisitionHeaderEO.CHANGE_PENDING_FLAG,         PoRequisitionHeaderEO.CONTRACTOR_REQUISITION_FLAG,          PoRequisitionHeaderEO.ACTIVE_SHOPPING_CART_FLAG,          PoRequisitionHeaderEO.CONTRACTOR_STATUS,         PoRequisitionHeaderEO.SUPPLIER_NOTIFIED_FLAG,          PoRequisitionHeaderEO.EMERGENCY_PO_ORG_ID FROM PO_REQUISITION_HEADERS_ALL PoRequisitionHeaderEO WHERE requisition_header_id = :1

                13/09/20 09:22:14 [710]       pStmt = conn.prepareStatement("SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE,         PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE,          PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID,          PoRequisitionHeaderEO.CLOSED_CODE,         PoRequisitionHeaderEO.ORG_ID,          PoRequisitionHeaderEO.DESCRIPTION,         PoRequisitionHeaderEO.AUTHORIZATION_STATUS,          PoRequisitionHeaderEO.NOTE_TO_AUTHORIZER,         PoRequisitionHeaderEO.TYPE_LOOKUP_CODE,          PoRequisitionHeaderEO.TRANSFERRED_TO_OE_FLAG,          PoRequisitionHeaderEO.ATTRIBUTE_CATEGORY,         PoRequisitionHeaderEO.ON_LINE_FLAG,          PoRequisitionHeaderEO.PRELIMINARY_RESEARCH_FLAG,          PoRequisitionHeaderEO.RESEARCH_COMPLETE_FLAG,         PoRequisitionHeaderEO.PREPARER_FINISHED_FLAG,          PoRequisitionHeaderEO.PREPARER_FINISHED_DATE,          PoRequisitionHeaderEO.AGENT_RETURN_FLAG,         PoRequisitionHeaderEO.AGENT_RETURN_NOTE,          PoRequisitionHeaderEO.CANCEL_FLAG,         PoRequisitionHeaderEO.USSGL_TRANSACTION_CODE,          PoRequisitionHeaderEO.GOVERNMENT_CONTEXT,         PoRequisitionHeaderEO.REQUEST_ID,          PoRequisitionHeaderEO.PROGRAM_APPLICATION_ID,          PoRequisitionHeaderEO.PROGRAM_ID,         PoRequisitionHeaderEO.REQUISITION_HEADER_ID,          PoRequisitionHeaderEO.PREPARER_ID,         PoRequisitionHeaderEO.LAST_UPDATE_DATE,          PoRequisitionHeaderEO.LAST_UPDATED_BY,         PoRequisitionHeaderEO.SEGMENT1,          PoRequisitionHeaderEO.SUMMARY_FLAG,         PoRequisitionHeaderEO.ENABLED_FLAG,          PoRequisitionHeaderEO.START_DATE_ACTIVE,         PoRequisitionHeaderEO.END_DATE_ACTIVE,          PoRequisitionHeaderEO.LAST_UPDATE_LOGIN,         PoRequisitionHeaderEO.CREATION_DATE,          PoRequisitionHeaderEO.CREATED_BY,         PoRequisitionHeaderEO.WF_ITEM_TYPE,          PoRequisitionHeaderEO.WF_ITEM_KEY,         PoRequisitionHeaderEO.EMERGENCY_PO_NUM,          PoRequisitionHeaderEO.PCARD_ID,         PoRequisitionHeaderEO.APPS_SOURCE_CODE,          PoRequisitionHeaderEO.SEGMENT2,         PoRequisitionHeaderEO.SEGMENT3,          PoRequisitionHeaderEO.SEGMENT4,         PoRequisitionHeaderEO.SEGMENT5,          PoRequisitionHeaderEO.ATTRIBUTE1,         PoRequisitionHeaderEO.ATTRIBUTE2,          PoRequisitionHeaderEO.ATTRIBUTE3,         PoRequisitionHeaderEO.ATTRIBUTE4,          PoRequisitionHeaderEO.ATTRIBUTE5,         PoRequisitionHeaderEO.ATTRIBUTE6,          PoRequisitionHeaderEO.ATTRIBUTE7,         PoRequisitionHeaderEO.ATTRIBUTE8,          PoRequisitionHeaderEO.ATTRIBUTE9,         PoRequisitionHeaderEO.ATTRIBUTE10,          PoRequisitionHeaderEO.ATTRIBUTE11,         PoRequisitionHeaderEO.ATTRIBUTE12,          PoRequisitionHeaderEO.ATTRIBUTE13,         PoRequisitionHeaderEO.ATTRIBUTE14,          PoRequisitionHeaderEO.ATTRIBUTE15,         PoRequisitionHeaderEO.CBC_ACCOUNTING_DATE,          PoRequisitionHeaderEO.CHANGE_PENDING_FLAG,         PoRequisitionHeaderEO.CONTRACTOR_REQUISITION_FLAG,          PoRequisitionHeaderEO.ACTIVE_SHOPPING_CART_FLAG,          PoRequisitionHeaderEO.CONTRACTOR_STATUS,         PoRequisitionHeaderEO.SUPPLIER_NOTIFIED_FLAG,          PoRequisitionHeaderEO.EMERGENCY_PO_ORG_ID FROM PO_REQUISITION_HEADERS_ALL PoRequisitionHeaderEO WHERE requisition_header_id = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [711] Bind params for ViewObject: PoRequisitionHeadersVO

                13/09/20 09:22:14 [712] Binding param 1: 6122

                13/09/20 09:22:14 [713] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [714]       pStmt.setObject(1, "6122");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [715] Column count: 430

                13/09/20 09:22:14 [716] ViewObject: PoRequisitionLinesVO close prepared statements...

                13/09/20 09:22:14 [717] ViewObject: PoRequisitionLinesVO Created new QUERY statement

                13/09/20 09:22:14 [718] PoRequisitionLinesVO>#q computed SQLStmtBufLen: 9060, actual=8966, storing=8996

                13/09/20 09:22:14 [719] SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,         PoRequisitionLineEO.REQUISITION_HEADER_ID,         PoRequisitionLineEO.LINE_NUM,         PoRequisitionLineEO.LAST_UPDATE_DATE,         PoRequisitionLineEO.LAST_UPDATED_BY,         PoRequisitionLineEO.LAST_UPDATE_LOGIN,         PoRequisitionLineEO.CREATION_DATE,         PoRequisitionLineEO.CREATED_BY,         PoRequisitionLineEO.DELIVER_TO_LOCATION_ID,         PoRequisitionLineEO.TO_PERSON_ID,         PoRequisitionLineEO.ITEM_DESCRIPTION,         PoRequisitionLineEO.CATEGORY_ID,         PoRequisitionLineEO.UNIT_MEAS_LOOKUP_CODE,         PoRequisitionLineEO.UNIT_PRICE,         PoRequisitionLineEO.QUANTITY,         PoRequisitionLineEO.LINE_TYPE_ID,         PoRequisitionLineEO.SOURCE_TYPE_CODE,         PoRequisitionLineEO.ITEM_ID,         PoRequisitionLineEO.ITEM_REVISION,         PoRequisitionLineEO.QUANTITY_DELIVERED,         PoRequisitionLineEO.SUGGESTED_BUYER_ID,         PoRequisitionLineEO.ENCUMBERED_FLAG,         PoRequisitionLineEO.RFQ_REQUIRED_FLAG,         PoRequisitionLineEO.NEED_BY_DATE,         PoRequisitionLineEO.LINE_LOCATION_ID,         PoRequisitionLineEO.MODIFIED_BY_AGENT_FLAG,         PoRequisitionLineEO.PARENT_REQ_LINE_ID,         PoRequisitionLineEO.JUSTIFICATION,         PoRequisitionLineEO.NOTE_TO_AGENT,         PoRequisitionLineEO.NOTE_TO_RECEIVER,         PoRequisitionLineEO.PURCHASING_AGENT_ID,         PoRequisitionLineEO.DOCUMENT_TYPE_CODE,         PoRequisitionLineEO.BLANKET_PO_HEADER_ID,         PoRequisitionLineEO.BLANKET_PO_LINE_NUM,         PoRequisitionLineEO.CURRENCY_CODE,         PoRequisitionLineEO.RATE_TYPE,         PoRequisitionLineEO.RATE_DATE,         PoRequisitionLineEO.RATE,         PoRequisitionLineEO.CURRENCY_UNIT_PRICE,         PoRequisitionLineEO.SUGGESTED_VENDOR_NAME,         PoRequisitionLineEO.SUGGESTED_VENDOR_LOCATION,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT,         PoRequisitionLineEO.SUGGESTED_VENDOR_PHONE,         PoRequisitionLineEO.SUGGESTED_VENDOR_PRODUCT_CODE,         PoRequisitionLineEO.UN_NUMBER_ID,         PoRequisitionLineEO.HAZARD_CLASS_ID,         PoRequisitionLineEO.MUST_USE_SUGG_VENDOR_FLAG,         PoRequisitionLineEO.REFERENCE_NUM,         PoRequisitionLineEO.ON_RFQ_FLAG,         PoRequisitionLineEO.URGENT_FLAG,         PoRequisitionLineEO.CANCEL_FLAG,         PoRequisitionLineEO.SOURCE_ORGANIZATION_ID,         PoRequisitionLineEO.SOURCE_SUBINVENTORY,         PoRequisitionLineEO.DESTINATION_TYPE_CODE,         PoRequisitionLineEO.DESTINATION_ORGANIZATION_ID,         PoRequisitionLineEO.DESTINATION_SUBINVENTORY,         PoRequisitionLineEO.QUANTITY_CANCELLED,         PoRequisitionLineEO.CANCEL_DATE,         PoRequisitionLineEO.CANCEL_REASON,         PoRequisitionLineEO.CLOSED_CODE,         PoRequisitionLineEO.AGENT_RETURN_NOTE,         PoRequisitionLineEO.CHANGED_AFTER_RESEARCH_FLAG,         PoRequisitionLineEO.VENDOR_ID,         PoRequisitionLineEO.VENDOR_SITE_ID,         PoRequisitionLineEO.VENDOR_CONTACT_ID,         PoRequisitionLineEO.RESEARCH_AGENT_ID,         PoRequisitionLineEO.ON_LINE_FLAG,         PoRequisitionLineEO.WIP_ENTITY_ID,         PoRequisitionLineEO.WIP_LINE_ID,         PoRequisitionLineEO.WIP_REPETITIVE_SCHEDULE_ID,         PoRequisitionLineEO.WIP_OPERATION_SEQ_NUM,         PoRequisitionLineEO.WIP_RESOURCE_SEQ_NUM,         PoRequisitionLineEO.ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.DESTINATION_CONTEXT,         PoRequisitionLineEO.INVENTORY_SOURCE_CONTEXT,         PoRequisitionLineEO.VENDOR_SOURCE_CONTEXT,         PoRequisitionLineEO.BOM_RESOURCE_ID,         PoRequisitionLineEO.REQUEST_ID,         PoRequisitionLineEO.PROGRAM_APPLICATION_ID,         PoRequisitionLineEO.PROGRAM_ID,         PoRequisitionLineEO.PROGRAM_UPDATE_DATE,         PoRequisitionLineEO.USSGL_TRANSACTION_CODE,         PoRequisitionLineEO.GOVERNMENT_CONTEXT,         PoRequisitionLineEO.CLOSED_REASON,         PoRequisitionLineEO.CLOSED_DATE,         PoRequisitionLineEO.TRANSACTION_REASON_CODE,         PoRequisitionLineEO.QUANTITY_RECEIVED,         PoRequisitionLineEO.SOURCE_REQ_LINE_ID,         PoRequisitionLineEO.ORG_ID,         PoRequisitionLineEO.KANBAN_CARD_ID,         PoRequisitionLineEO.CATALOG_TYPE,         PoRequisitionLineEO.CATALOG_SOURCE,         PoRequisitionLineEO.MANUFACTURER_ID,         PoRequisitionLineEO.MANUFACTURER_NAME,         PoRequisitionLineEO.MANUFACTURER_PART_NUMBER,         PoRequisitionLineEO.REQUESTER_EMAIL,         PoRequisitionLineEO.REQUESTER_FAX,         PoRequisitionLineEO.REQUESTER_PHONE,         PoRequisitionLineEO.UNSPSC_CODE,         PoRequisitionLineEO.OTHER_CATEGORY_CODE,         PoRequisitionLineEO.SUPPLIER_DUNS,         PoRequisitionLineEO.TAX_STATUS_INDICATOR,         PoRequisitionLineEO.PCARD_FLAG,         PoRequisitionLineEO.NEW_SUPPLIER_FLAG,         PoRequisitionLineEO.AUTO_RECEIVE_FLAG,         PoRequisitionLineEO.TAX_USER_OVERRIDE_FLAG,         PoRequisitionLineEO.TAX_CODE_ID,         PoRequisitionLineEO.NOTE_TO_VENDOR,         PoRequisitionLineEO.OKE_CONTRACT_VERSION_ID,         PoRequisitionLineEO.OKE_CONTRACT_HEADER_ID,         PoRequisitionLineEO.ITEM_SOURCE_ID,         PoRequisitionLineEO.SUPPLIER_REF_NUMBER,         PoRequisitionLineEO.SECONDARY_UNIT_OF_MEASURE,         PoRequisitionLineEO.SECONDARY_QUANTITY,         PoRequisitionLineEO.PREFERRED_GRADE,         PoRequisitionLineEO.SECONDARY_QUANTITY_RECEIVED,         PoRequisitionLineEO.SECONDARY_QUANTITY_CANCELLED,         PoRequisitionLineEO.AUCTION_HEADER_ID,         PoRequisitionLineEO.AUCTION_DISPLAY_NUMBER,         PoRequisitionLineEO.AUCTION_LINE_NUMBER,         PoRequisitionLineEO.REQS_IN_POOL_FLAG,         PoRequisitionLineEO.VMI_FLAG,         PoRequisitionLineEO.ATTRIBUTE1,         PoRequisitionLineEO.ATTRIBUTE2,         PoRequisitionLineEO.ATTRIBUTE3,         PoRequisitionLineEO.ATTRIBUTE4,         PoRequisitionLineEO.ATTRIBUTE5,         PoRequisitionLineEO.ATTRIBUTE6,         PoRequisitionLineEO.ATTRIBUTE7,         PoRequisitionLineEO.ATTRIBUTE8,         PoRequisitionLineEO.ATTRIBUTE9,         PoRequisitionLineEO.ATTRIBUTE10,         PoRequisitionLineEO.ATTRIBUTE11,         PoRequisitionLineEO.ATTRIBUTE12,         PoRequisitionLineEO.ATTRIBUTE13,         PoRequisitionLineEO.ATTRIBUTE14,         PoRequisitionLineEO.ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE1,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE2,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE3,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE4,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE5,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE6,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE7,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE8,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE9,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE10,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE11,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE12,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE13,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE14,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE16,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE17,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE18,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE19,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE20,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.BID_NUMBER,         PoRequisitionLineEO.BID_LINE_NUMBER,         PoRequisitionLineEO.AMOUNT,         PoRequisitionLineEO.CURRENCY_AMOUNT,         PoRequisitionLineEO.NONCAT_TEMPLATE_ID,         PoRequisitionLineEO.JOB_ID,         PoRequisitionLineEO.CONTACT_INFORMATION,         PoRequisitionLineEO.CANDIDATE_SCREENING_REQD_FLAG,         PoRequisitionLineEO.SUGGESTED_SUPPLIER_FLAG,         PoRequisitionLineEO.ASSIGNMENT_END_DATE,         PoRequisitionLineEO.OVERTIME_ALLOWED_FLAG,         PoRequisitionLineEO.CONTRACTOR_REQUISITION_FLAG,         PoRequisitionLineEO.LABOR_REQ_LINE_ID,         PoRequisitionLineEO.JOB_LONG_DESCRIPTION,         PoRequisitionLineEO.CONTRACTOR_STATUS,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_FAX,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_EMAIL,         PoRequisitionLineEO.CANDIDATE_FIRST_NAME,         PoRequisitionLineEO.CANDIDATE_LAST_NAME,         PoRequisitionLineEO.ASSIGNMENT_START_DATE,         PoRequisitionLineEO.ORDER_TYPE_LOOKUP_CODE,         PoRequisitionLineEO.PURCHASE_BASIS,         PoRequisitionLineEO.MATCHING_BASIS,         PoRequisitionLineEO.NEGOTIATED_BY_PREPARER_FLAG,         PoRequisitionLineEO.BASE_UNIT_PRICE,         PoRequisitionLineEO.AT_SOURCING_FLAG,         PoRequisitionLineEO.TAX_ATTRIBUTE_UPDATE_CODE,         PoRequisitionLineEO.DROP_SHIP_FLAG,         PoRequisitionLineEO.SHIP_METHOD,         PoRequisitionLineEO.ESTIMATED_PICKUP_DATE,         PoRequisitionLineEO.SUPPLIER_NOTIFIED_FOR_CANCEL,         PoRequisitionLineEO.TAX_NAME FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO WHERE PoRequisitionLineEO.REQUISITION_HEADER_ID = :1 ORDER BY Line_NUM ASC

                13/09/20 09:22:14 [720]       pStmt = conn.prepareStatement("SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,         PoRequisitionLineEO.REQUISITION_HEADER_ID,         PoRequisitionLineEO.LINE_NUM,         PoRequisitionLineEO.LAST_UPDATE_DATE,         PoRequisitionLineEO.LAST_UPDATED_BY,         PoRequisitionLineEO.LAST_UPDATE_LOGIN,         PoRequisitionLineEO.CREATION_DATE,         PoRequisitionLineEO.CREATED_BY,         PoRequisitionLineEO.DELIVER_TO_LOCATION_ID,         PoRequisitionLineEO.TO_PERSON_ID,         PoRequisitionLineEO.ITEM_DESCRIPTION,         PoRequisitionLineEO.CATEGORY_ID,         PoRequisitionLineEO.UNIT_MEAS_LOOKUP_CODE,         PoRequisitionLineEO.UNIT_PRICE,         PoRequisitionLineEO.QUANTITY,         PoRequisitionLineEO.LINE_TYPE_ID,         PoRequisitionLineEO.SOURCE_TYPE_CODE,         PoRequisitionLineEO.ITEM_ID,         PoRequisitionLineEO.ITEM_REVISION,         PoRequisitionLineEO.QUANTITY_DELIVERED,         PoRequisitionLineEO.SUGGESTED_BUYER_ID,         PoRequisitionLineEO.ENCUMBERED_FLAG,         PoRequisitionLineEO.RFQ_REQUIRED_FLAG,         PoRequisitionLineEO.NEED_BY_DATE,         PoRequisitionLineEO.LINE_LOCATION_ID,         PoRequisitionLineEO.MODIFIED_BY_AGENT_FLAG,         PoRequisitionLineEO.PARENT_REQ_LINE_ID,         PoRequisitionLineEO.JUSTIFICATION,         PoRequisitionLineEO.NOTE_TO_AGENT,         PoRequisitionLineEO.NOTE_TO_RECEIVER,         PoRequisitionLineEO.PURCHASING_AGENT_ID,         PoRequisitionLineEO.DOCUMENT_TYPE_CODE,         PoRequisitionLineEO.BLANKET_PO_HEADER_ID,         PoRequisitionLineEO.BLANKET_PO_LINE_NUM,         PoRequisitionLineEO.CURRENCY_CODE,         PoRequisitionLineEO.RATE_TYPE,         PoRequisitionLineEO.RATE_DATE,         PoRequisitionLineEO.RATE,         PoRequisitionLineEO.CURRENCY_UNIT_PRICE,         PoRequisitionLineEO.SUGGESTED_VENDOR_NAME,         PoRequisitionLineEO.SUGGESTED_VENDOR_LOCATION,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT,         PoRequisitionLineEO.SUGGESTED_VENDOR_PHONE,         PoRequisitionLineEO.SUGGESTED_VENDOR_PRODUCT_CODE,         PoRequisitionLineEO.UN_NUMBER_ID,         PoRequisitionLineEO.HAZARD_CLASS_ID,         PoRequisitionLineEO.MUST_USE_SUGG_VENDOR_FLAG,         PoRequisitionLineEO.REFERENCE_NUM,         PoRequisitionLineEO.ON_RFQ_FLAG,         PoRequisitionLineEO.URGENT_FLAG,         PoRequisitionLineEO.CANCEL_FLAG,         PoRequisitionLineEO.SOURCE_ORGANIZATION_ID,         PoRequisitionLineEO.SOURCE_SUBINVENTORY,         PoRequisitionLineEO.DESTINATION_TYPE_CODE,         PoRequisitionLineEO.DESTINATION_ORGANIZATION_ID,         PoRequisitionLineEO.DESTINATION_SUBINVENTORY,         PoRequisitionLineEO.QUANTITY_CANCELLED,         PoRequisitionLineEO.CANCEL_DATE,         PoRequisitionLineEO.CANCEL_REASON,         PoRequisitionLineEO.CLOSED_CODE,         PoRequisitionLineEO.AGENT_RETURN_NOTE,         PoRequisitionLineEO.CHANGED_AFTER_RESEARCH_FLAG,         PoRequisitionLineEO.VENDOR_ID,         PoRequisitionLineEO.VENDOR_SITE_ID,         PoRequisitionLineEO.VENDOR_CONTACT_ID,         PoRequisitionLineEO.RESEARCH_AGENT_ID,         PoRequisitionLineEO.ON_LINE_FLAG,         PoRequisitionLineEO.WIP_ENTITY_ID,         PoRequisitionLineEO.WIP_LINE_ID,         PoRequisitionLineEO.WIP_REPETITIVE_SCHEDULE_ID,         PoRequisitionLineEO.WIP_OPERATION_SEQ_NUM,         PoRequisitionLineEO.WIP_RESOURCE_SEQ_NUM,         PoRequisitionLineEO.ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.DESTINATION_CONTEXT,         PoRequisitionLineEO.INVENTORY_SOURCE_CONTEXT,         PoRequisitionLineEO.VENDOR_SOURCE_CONTEXT,         PoRequisitionLineEO.BOM_RESOURCE_ID,         PoRequisitionLineEO.REQUEST_ID,         PoRequisitionLineEO.PROGRAM_APPLICATION_ID,         PoRequisitionLineEO.PROGRAM_ID,         PoRequisitionLineEO.PROGRAM_UPDATE_DATE,         PoRequisitionLineEO.USSGL_TRANSACTION_CODE,         PoRequisitionLineEO.GOVERNMENT_CONTEXT,         PoRequisitionLineEO.CLOSED_REASON,         PoRequisitionLineEO.CLOSED_DATE,         PoRequisitionLineEO.TRANSACTION_REASON_CODE,         PoRequisitionLineEO.QUANTITY_RECEIVED,         PoRequisitionLineEO.SOURCE_REQ_LINE_ID,         PoRequisitionLineEO.ORG_ID,         PoRequisitionLineEO.KANBAN_CARD_ID,         PoRequisitionLineEO.CATALOG_TYPE,         PoRequisitionLineEO.CATALOG_SOURCE,         PoRequisitionLineEO.MANUFACTURER_ID,         PoRequisitionLineEO.MANUFACTURER_NAME,         PoRequisitionLineEO.MANUFACTURER_PART_NUMBER,         PoRequisitionLineEO.REQUESTER_EMAIL,         PoRequisitionLineEO.REQUESTER_FAX,         PoRequisitionLineEO.REQUESTER_PHONE,         PoRequisitionLineEO.UNSPSC_CODE,         PoRequisitionLineEO.OTHER_CATEGORY_CODE,         PoRequisitionLineEO.SUPPLIER_DUNS,         PoRequisitionLineEO.TAX_STATUS_INDICATOR,         PoRequisitionLineEO.PCARD_FLAG,         PoRequisitionLineEO.NEW_SUPPLIER_FLAG,         PoRequisitionLineEO.AUTO_RECEIVE_FLAG,         PoRequisitionLineEO.TAX_USER_OVERRIDE_FLAG,         PoRequisitionLineEO.TAX_CODE_ID,         PoRequisitionLineEO.NOTE_TO_VENDOR,         PoRequisitionLineEO.OKE_CONTRACT_VERSION_ID,         PoRequisitionLineEO.OKE_CONTRACT_HEADER_ID,         PoRequisitionLineEO.ITEM_SOURCE_ID,         PoRequisitionLineEO.SUPPLIER_REF_NUMBER,         PoRequisitionLineEO.SECONDARY_UNIT_OF_MEASURE,         PoRequisitionLineEO.SECONDARY_QUANTITY,         PoRequisitionLineEO.PREFERRED_GRADE,         PoRequisitionLineEO.SECONDARY_QUANTITY_RECEIVED,         PoRequisitionLineEO.SECONDARY_QUANTITY_CANCELLED,         PoRequisitionLineEO.AUCTION_HEADER_ID,         PoRequisitionLineEO.AUCTION_DISPLAY_NUMBER,         PoRequisitionLineEO.AUCTION_LINE_NUMBER,         PoRequisitionLineEO.REQS_IN_POOL_FLAG,         PoRequisitionLineEO.VMI_FLAG,         PoRequisitionLineEO.ATTRIBUTE1,         PoRequisitionLineEO.ATTRIBUTE2,         PoRequisitionLineEO.ATTRIBUTE3,         PoRequisitionLineEO.ATTRIBUTE4,         PoRequisitionLineEO.ATTRIBUTE5,         PoRequisitionLineEO.ATTRIBUTE6,         PoRequisitionLineEO.ATTRIBUTE7,         PoRequisitionLineEO.ATTRIBUTE8,         PoRequisitionLineEO.ATTRIBUTE9,         PoRequisitionLineEO.ATTRIBUTE10,         PoRequisitionLineEO.ATTRIBUTE11,         PoRequisitionLineEO.ATTRIBUTE12,         PoRequisitionLineEO.ATTRIBUTE13,         PoRequisitionLineEO.ATTRIBUTE14,         PoRequisitionLineEO.ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE1,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE2,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE3,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE4,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE5,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE6,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE7,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE8,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE9,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE10,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE11,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE12,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE13,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE14,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE16,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE17,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE18,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE19,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE20,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.BID_NUMBER,         PoRequisitionLineEO.BID_LINE_NUMBER,         PoRequisitionLineEO.AMOUNT,         PoRequisitionLineEO.CURRENCY_AMOUNT,         PoRequisitionLineEO.NONCAT_TEMPLATE_ID,         PoRequisitionLineEO.JOB_ID,         PoRequisitionLineEO.CONTACT_INFORMATION,         PoRequisitionLineEO.CANDIDATE_SCREENING_REQD_FLAG,         PoRequisitionLineEO.SUGGESTED_SUPPLIER_FLAG,         PoRequisitionLineEO.ASSIGNMENT_END_DATE,         PoRequisitionLineEO.OVERTIME_ALLOWED_FLAG,         PoRequisitionLineEO.CONTRACTOR_REQUISITION_FLAG,         PoRequisitionLineEO.LABOR_REQ_LINE_ID,         PoRequisitionLineEO.JOB_LONG_DESCRIPTION,         PoRequisitionLineEO.CONTRACTOR_STATUS,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_FAX,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_EMAIL,         PoRequisitionLineEO.CANDIDATE_FIRST_NAME,         PoRequisitionLineEO.CANDIDATE_LAST_NAME,         PoRequisitionLineEO.ASSIGNMENT_START_DATE,         PoRequisitionLineEO.ORDER_TYPE_LOOKUP_CODE,         PoRequisitionLineEO.PURCHASE_BASIS,         PoRequisitionLineEO.MATCHING_BASIS,         PoRequisitionLineEO.NEGOTIATED_BY_PREPARER_FLAG,         PoRequisitionLineEO.BASE_UNIT_PRICE,         PoRequisitionLineEO.AT_SOURCING_FLAG,         PoRequisitionLineEO.TAX_ATTRIBUTE_UPDATE_CODE,         PoRequisitionLineEO.DROP_SHIP_FLAG,         PoRequisitionLineEO.SHIP_METHOD,         PoRequisitionLineEO.ESTIMATED_PICKUP_DATE,         PoRequisitionLineEO.SUPPLIER_NOTIFIED_FOR_CANCEL,         PoRequisitionLineEO.TAX_NAME FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO WHERE PoRequisitionLineEO.REQUISITION_HEADER_ID = :1 ORDER BY Line_NUM ASC");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [721] Bind params for ViewObject: PoRequisitionLinesVO

                13/09/20 09:22:14 [722] Binding param 1: 6122

                13/09/20 09:22:14 [723] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [724]       pStmt.setObject(1, "6122");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [725] BC4JDeployPlatform: LOCAL

                13/09/20 09:22:14 [726] Propertymanager: skipping reload of file and system based properties

                13/09/20 09:22:14 [727] {{ begin Loading BC4J properties

                13/09/20 09:22:14 [728] -----------------------------------------------------------

                13/09/20 09:22:14 [729] BC4J Property jbo.default.language='en' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [730] BC4J Property jbo.default.country='US' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [731] Skipping empty Property jbo.default.locale.variant from System Default

                13/09/20 09:22:14 [732] BC4J Property DeployPlatform='LOCAL' -->(SessionImpl) from Client Environment

                13/09/20 09:22:14 [733] Skipping empty Property ConnectionMode from System Default

                13/09/20 09:22:14 [734] Skipping empty Property HostName from System Default

                13/09/20 09:22:14 [735] Skipping empty Property ConnectionPort from System Default

                13/09/20 09:22:14 [736] BC4J Property jbo.locking.mode='pessimistic' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [737] BC4J Property jbo.txn.disconnect_level='1' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:14 [738] Skipping empty Property ApplicationPath from System Default

                13/09/20 09:22:14 [739] Skipping empty Property AppModuleJndiName from System Default

                13/09/20 09:22:14 [740] Skipping empty Property java.naming.security.principal from System Default

                13/09/20 09:22:14 [741] Skipping empty Property java.naming.security.credentials from System Default

                13/09/20 09:22:14 [742] Skipping empty Property jbo.user.principal from System Default

                13/09/20 09:22:14 [743] BC4J Property jbo.simulate.remote='false' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [744] BC4J Property jbo.security.context='oracle.security.jazn' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [745] Skipping empty Property jbo.object.marshaller from System Default

                13/09/20 09:22:14 [746] BC4J Property jbo.use.pers.coll='false' -->(SessionImpl) from Client Environment

                13/09/20 09:22:14 [747] BC4J Property jbo.pers.max.rows.per.node='70' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [748] BC4J Property jbo.pers.max.active.nodes='30' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [749] Skipping empty Property jbo.pcoll.mgr from System Default

                13/09/20 09:22:14 [750] BC4J Property jbo.txn_table_name='PS_TXN' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [751] BC4J Property jbo.txn_seq_name='PS_TXN_seq' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [752] BC4J Property jbo.txn_seq_inc='1' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [753] BC4J Property jbo.control_table_name='PCOLL_CONTROL' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [754] BC4J Property jbo.stringmanager.factory.class='use_default' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [755] BC4J Property jbo.domain.date.suppress_zero_time='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [756] BC4J Property jbo.domain.bind_sql_date='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [757] BC4J Property jbo.domain.string.as.bytes.for.raw='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [758] BC4J Property jbo.fetch.mode='AS.NEEDED' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [759] BC4J Property jbo.323.compatible='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [760] BC4J Property jbo.903.compatible='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [761] Skipping empty Property JBODynamicObjectsPackage from System Default

                13/09/20 09:22:14 [762] BC4J Property MetaObjectContextFactory='oracle.jbo.mom.xml.DefaultMomContextFactory' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [763] BC4J Property jbo.load.components.lazily='false' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:14 [764] BC4J Property MetaObjectContext='oracle.adf.mds.jbo.JBODefManager' -->(MetaObjectManager) from System Property

                13/09/20 09:22:14 [765] BC4J Property java.naming.factory.initial='oracle.jbo.common.JboInitialContextFactory' -->(SessionImpl) from Client Environment

                13/09/20 09:22:14 [766] BC4J Property IsLazyLoadingTrue='true' -->(MetaObjectManager) from /oracle/jbo/server/jboserver.properties resource

                13/09/20 09:22:14 [767] BC4J Property oracle.jbo.usemds='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [768] BC4J Property oracle.adfm.usemds='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [769] BC4J Property ActivateSharedDataHandle='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [770] Skipping empty Property HandleName from System Default

                13/09/20 09:22:14 [771] Skipping empty Property Factory-Substitution-List from System Default

                13/09/20 09:22:14 [772] Skipping empty Property jbo.project from System Default

                13/09/20 09:22:14 [773] BC4J Property jbo.max.cursors='50' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [774] BC4J Property jbo.dofailover='false' -->(Configuration) from System Default

                13/09/20 09:22:14 [775] BC4J Property jbo.ampool.writecookietoclient='false' -->(Configuration) from System Default

                13/09/20 09:22:14 [776] BC4J Property jbo.doconnectionpooling='false' -->(Configuration) from System Default

                13/09/20 09:22:14 [777] BC4J Property jbo.recyclethreshold='10' -->(Configuration) from System Default

                13/09/20 09:22:14 [778] BC4J Property jbo.ampool.dynamicjdbccredentials='true' -->(Configuration) from System Default

                13/09/20 09:22:14 [779] BC4J Property jbo.ampool.resetnontransactionalstate='false' -->(SessionImpl) from Client Environment

                13/09/20 09:22:14 [780] BC4J Property jbo.ampool.sessioncookiefactoryclass='oracle.jbo.common.ampool.DefaultSessionCookieFactory' -->(Configuration) from System Default

                13/09/20 09:22:14 [781] BC4J Property jbo.ampool.connectionstrategyclass='oracle.jbo.common.ampool.DefaultConnectionStrategy' -->(Configuration) from System Default

                13/09/20 09:22:14 [782] BC4J Property jbo.ampool.maxpoolsize='2147483647' -->(Configuration) from System Default

                13/09/20 09:22:14 [783] BC4J Property jbo.ampool.initpoolsize='0' -->(Configuration) from System Default

                13/09/20 09:22:14 [784] BC4J Property jbo.ampool.monitorsleepinterval='600000' -->(Configuration) from System Default

                13/09/20 09:22:14 [785] BC4J Property jbo.ampool.minavailablesize='5' -->(Configuration) from System Default

                13/09/20 09:22:14 [786] BC4J Property jbo.ampool.maxavailablesize='25' -->(Configuration) from System Default

                13/09/20 09:22:14 [787] BC4J Property jbo.ampool.maxinactiveage='600000' -->(Configuration) from System Default

                13/09/20 09:22:14 [788] BC4J Property jbo.ampool.timetolive='3600000' -->(Configuration) from System Default

                13/09/20 09:22:14 [789] BC4J Property jbo.ampool.doampooling='true' -->(Configuration) from System Default

                13/09/20 09:22:14 [790] BC4J Property jbo.ampool.isuseexclusive='true' -->(Configuration) from System Default

                13/09/20 09:22:14 [791] BC4J Property jbo.passivationstore='null' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [792] BC4J Property jbo.saveforlater='false' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [793] BC4J Property jbo.snapshotstore.undo='persistent' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [794] BC4J Property jbo.maxpassivationstacksize='10' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [795] BC4J Property jbo.txn.handleafterpostexc='false' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [796] BC4J Property jbo.connectfailover='true' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [797] BC4J Property jbo.maxpoolcookieage='-1' -->(Configuration) from System Default

                13/09/20 09:22:14 [798] BC4J Property PoolClassName='oracle.jbo.common.ampool.ApplicationPoolImpl' -->(Configuration) from System Default

                13/09/20 09:22:14 [799] BC4J Property jbo.maxpoolsize='5' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:14 [800] BC4J Property jbo.initpoolsize='0' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [801] BC4J Property jbo.poolrequesttimeout='5000' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:14 [802] BC4J Property jbo.poolmonitorsleepinterval='600000' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [803] BC4J Property jbo.poolminavailablesize='5' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [804] BC4J Property jbo.poolmaxavailablesize='25' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [805] BC4J Property jbo.poolmaxinactiveage='600000' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [806] BC4J Property jbo.pooltimetolive='3600000' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [807] BC4J Property RELEASE_MODE='Stateful' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [808] BC4J Property jbo.assoc.consistent='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [809] BC4J Property jbo.viewlink.consistent='DEFAULT' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [810] BC4J Property jbo.passivation.TrackInsert='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [811] Skipping empty Property jbo.ViewCriteriaAdapter from System Default

                13/09/20 09:22:14 [812] BC4J Property jbo.SQLBuilder='oracle.apps.fnd.framework.server.OAOracleSQLBuilderImpl' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:14 [813] BC4J Property jbo.ConnectionPoolManager='oracle.apps.fnd.framework.server.OAConnectionPoolManagerImpl' -->(MetaObjectManager) from Client Environment

                13/09/20 09:22:14 [814] BC4J Property jbo.TypeMapEntries='Oracle' -->(MetaObjectManager) from /oracle/jbo/server/jboserver.properties resource

                13/09/20 09:22:14 [815] Skipping empty Property jbo.sql92.JdbcDriverClass from System Default

                13/09/20 09:22:14 [816] BC4J Property jbo.sql92.LockTrailer='FOR UPDATE' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [817] BC4J Property jbo.jdbc.trace='true' -->(MetaObjectManager) from System Property

                13/09/20 09:22:14 [818] BC4J Property jbo.abstract.base.check='true' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [819] BC4J Property jbo.assoc.where.early.set='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [820] BC4J Property jbo.sql92.DbTimeQuery='select sysdate from dual' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [821] BC4J Property oracle.jbo.defineColumnLength='as_chars' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [822] BC4J Property jbo.jdbc_bytes_conversion='jdbc' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [823] Skipping empty Property jbo.tmpdir from System Default

                13/09/20 09:22:14 [824] Skipping empty Property jbo.server.internal_connection from System Default

                13/09/20 09:22:14 [825] Skipping empty Property SessionClass from System Default

                13/09/20 09:22:14 [826] Skipping empty Property TransactionFactory from System Default

                13/09/20 09:22:14 [827] Skipping empty Property jbo.def.mgr.listener from System Default

                13/09/20 09:22:14 [828] BC4J Property jbo.debugoutput='console' -->(Diagnostic) from System Property

                13/09/20 09:22:14 [829] BC4J Property jbo.debug.prefix='DBG: ' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:14 [830] BC4J Property jbo.logging.show.timing='false' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:14 [831] BC4J Property jbo.logging.show.function='false' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:14 [832] BC4J Property jbo.logging.show.level='false' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:14 [833] BC4J Property jbo.logging.show.linecount='true' -->(Diagnostic) from /oracle/jbo/common/Diagnostic.properties resource

                13/09/20 09:22:14 [834] BC4J Property jbo.logging.trace.threshold='9' -->(Diagnostic) from System Property

                13/09/20 09:22:14 [835] BC4J Property jbo.jdbc.driver.verbose='true' -->(Diagnostic) from System Property

                13/09/20 09:22:14 [836] BC4J Property oracle.home='C:\jDev10g\jdevbin' -->(Diagnostic) from System Property

                13/09/20 09:22:14 [837] Skipping empty Property oc4j.name from System Default

                13/09/20 09:22:14 [838] BC4J Property jbo.ejb.txntimeout='1830' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [839] BC4J Property jbo.ejb.txntype='global' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [840] BC4J Property jbo.ejb.txn.disconnect_on_completion='false' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [841] Skipping empty Property jbo.ejb.useampool from System Default

                13/09/20 09:22:14 [842] Skipping empty Property oracle.jbo.schema from System Default

                13/09/20 09:22:14 [843] BC4J Property jbo.xml.validation='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [844] BC4J Property ord.RetrievePath='ordDeliverMedia' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [845] BC4J Property ord.HttpMaxMemory='102400' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [846] Skipping empty Property ord.HttpTempDir from System Default

                13/09/20 09:22:14 [847] BC4J Property ord.wmp.classid='clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [848] BC4J Property ord.qp.classid='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [849] BC4J Property ord.rp.classid='clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [850] BC4J Property ord.wmp.codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [851] BC4J Property ord.qp.codebase='http://www.apple.com/qtactivex/qtplugin.cab' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [852] Skipping empty Property ord.rp.codebase from System Default

                13/09/20 09:22:14 [853] BC4J Property ord.wmp.plugins.page='http://www.microsoft.com/isapi/redir.dll?prd=windows&sbp=mediaplayer&ar=Media&sba=Plugin&' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [854] BC4J Property ord.qp.plugins.page='http://www.apple.com/quicktime/download/' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [855] BC4J Property ord.rp.plugins.page='http://www.real.com/player/' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [856] BC4J Property jbo.security.enforce='None' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [857] BC4J Property jbo.security.loginmodule='oracle.security.jazn.tools.Admintool' -->(SessionImpl) from System Default

                13/09/20 09:22:14 [858] Skipping empty Property jbo.security.config from System Default

                13/09/20 09:22:14 [859] BC4J Property jbo.server.useNullDbTransaction='true' -->(SessionImpl) from Client Environment

                13/09/20 09:22:14 [860] BC4J Property jbo.domain.reopenblobstream='false' -->(MetaObjectManager) from System Default

                13/09/20 09:22:14 [861] Copying unknown Client property (LOCKING_MODE='2') to session

                13/09/20 09:22:14 [862] Copying unknown Client property (java.naming.factory.url.pkgs='oracle.oc4j.naming.url') to session

                13/09/20 09:22:14 [863] Copying unknown Client property (APPS_CONTEXT='[oracle.apps.fnd.common.AppsContext@1dce46d $Revision: 120.14.12010000.18 $ extends [oracle.apps.fnd.common.Context@1dce46d $Revision: 120.7.12010000.15 $  {sessionId=0x1dce46d,conn=oracle.jdbc.driver.T4CConnection@1942a3c,state=oracle.apps.fnd.common.StateStack@118e146}] {isDedicated=true}]') to session

                13/09/20 09:22:14 [864] }} finished loading BC4J properties

                13/09/20 09:22:14 [865] -----------------------------------------------------------

                13/09/20 09:22:14 [866] Connected to Oracle JBO Server - Version: 10.1.3.41.57

                13/09/20 09:22:14 [867] Created root application module: 'oracle.apps.fnd.framework.server.OAApplicationModule'

                13/09/20 09:22:14 [868] Locale is: 'en_US'

                13/09/20 09:22:14 [869] mPCollUsePMgr is false

                13/09/20 09:22:14 [870] ViewObjectImpl.mDefaultMaxRowsPerNode is 70

                13/09/20 09:22:14 [871] ViewObjectImpl.mDefaultMaxActiveNodes is 30

                13/09/20 09:22:14 [872] Oracle SQLBuilder: Registered driver: oracle.jdbc.driver.OracleDriver

                13/09/20 09:22:14 [873] import java.util.*;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [874] import java.sql.*;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [875] import java.io.*;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [876] public class JDBCCalls  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [877] {  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [878]    public Connection conn = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [879]    public CallableStatement cStmt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [880]    public PreparedStatement pStmt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [881]    public Statement stmt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [882]    public ResultSet rslt = null;  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [883]    public static void main(String argv[])  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [884]    {  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [885]       DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [886]       conn = DriverManager.getConnection("", /*properties*/);  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [887]       conn.setAutoCommit(false);  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [888] Successfully logged in

                13/09/20 09:22:14 [889] JDBCDriverVersion: 10.1.0.5.0

                13/09/20 09:22:14 [890] DatabaseProductName: Oracle

                13/09/20 09:22:14 [891] DatabaseProductVersion: Oracle Database 11g Release 11.1.0.0.0 - Production

                13/09/20 09:22:14 [892] Root application module, oracle.apps.fnd.framework.server.OAApplicationModule, was created at 2013-09-20 09:22:14.112

                13/09/20 09:22:14 [893] setConnectionReleaseLevel - Set connection release level to 0

                13/09/20 09:22:14 [894]       cStmt = conn.prepareCall("begin dbms_application_info.set_module(:1, :2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [895] In OADBTransactionImpl.rollback()

                13/09/20 09:22:14 [896]       conn.rollback();  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [897] *** closing jdbc connection now **** (oracle.jdbc.driver.T4CConnection@1942a3c)

                13/09/20 09:22:14 [898]       conn.rollback();  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [899]       cStmt = conn.prepareCall("begin dbms_application_info.set_module(:1, :2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [900] Resetting AM=OAApplicationModule

                13/09/20 09:22:14 [901] No XML file /oracle/apps/icx/por/common/server/server.xml for metaobject oracle.apps.icx.por.common.server.server

                13/09/20 09:22:14 [902] Cannot Load parent Package : oracle.apps.icx.por.common.server.server

                13/09/20 09:22:14 [903] Business Object Browsing may be unavailable

                13/09/20 09:22:14 [904] Loading from XML file /oracle/apps/icx/por/common/server/SystemInfoAM.xml

                13/09/20 09:22:14 [905]       cStmt = conn.prepareCall("begin :1 := po_core_s.get_product_install_status(:2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [906]       cStmt = conn.prepareCall("begin :1 := PA_PO_INTEGRATION.IS_PJC_11I10_ENABLED; end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [907]       cStmt = conn.prepareCall("begin :1 := PA_PO_INTEGRATION.IS_PJC_PO_CWK_INTG_ENAB; end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [908]       cStmt = conn.prepareCall("begin :1 := po_setup_s1.get_services_enabled_flag; end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [909] Loading from XML file /oracle/apps/icx/por/schema/server/RequisitionVAM.xml

                13/09/20 09:22:14 [910] Loading from XML file /oracle/apps/icx/por/schema/server/FinancialSystemParamsVVO.xml

                13/09/20 09:22:14 [911] Column count: 7

                13/09/20 09:22:14 [912] ViewObject: FinancialSystemParamsVVO Created new QUERY statement

                13/09/20 09:22:14 [913] FinancialSystemParamsVVO>#q computed SQLStmtBufLen: 362, actual=322, storing=352

                13/09/20 09:22:14 [914] SELECT fsp.set_of_books_id,

                    gls.currency_code,

                    fsp.inventory_organization_id,

                    NVL(fsp.req_encumbrance_flag, 'N'),

                    gls.chart_of_accounts_id,

                    NVL(fsp.purch_encumbrance_flag, 'N'),

                        fsp.business_group_id

                FROM financials_system_parameters fsp,

                    gl_sets_of_books gls

                WHERE fsp.set_of_books_id = gls.set_of_books_id

                13/09/20 09:22:14 [915]       pStmt = conn.prepareStatement("SELECT fsp.set_of_books_id,

                    gls.currency_code,

                    fsp.inventory_organization_id,

                    NVL(fsp.req_encumbrance_flag, 'N'),

                    gls.chart_of_accounts_id,

                    NVL(fsp.purch_encumbrance_flag, 'N'),

                        fsp.business_group_id

                FROM financials_system_parameters fsp,

                    gl_sets_of_books gls

                WHERE fsp.set_of_books_id = gls.set_of_books_id");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [916] Bind params for ViewObject: FinancialSystemParamsVVO

                13/09/20 09:22:14 [917] Clearing VO cache for FinancialSystemParamsVVO

                13/09/20 09:22:14 [918] Clear QueryCollection in cache for VO FinancialSystemParamsVVO

                13/09/20 09:22:14 [919] Loading from XML file /oracle/apps/icx/por/schema/server/FlexStructureCodeVVO.xml

                13/09/20 09:22:14 [920] Column count: 1

                13/09/20 09:22:14 [921] ViewObject: FlexStructureCodeVVO Created new QUERY statement

                13/09/20 09:22:14 [922] FlexStructureCodeVVO>#q computed SQLStmtBufLen: 174, actual=134, storing=164

                13/09/20 09:22:14 [923] SELECT id_flex_structure_code

                FROM fnd_id_flex_structures

                WHERE application_id = 101

                AND id_flex_code = 'GL#'

                AND id_flex_num = :1

                13/09/20 09:22:14 [924]       pStmt = conn.prepareStatement("SELECT id_flex_structure_code

                FROM fnd_id_flex_structures

                WHERE application_id = 101

                AND id_flex_code = 'GL#'

                AND id_flex_num = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [925] Bind params for ViewObject: FlexStructureCodeVVO

                13/09/20 09:22:14 [926] Binding param 1: 50348

                13/09/20 09:22:14 [927] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [928]       pStmt.setObject(1, "50348");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [929] Clearing VO cache for FlexStructureCodeVVO

                13/09/20 09:22:14 [930] Clear QueryCollection in cache for VO FlexStructureCodeVVO

                13/09/20 09:22:14 [931] Loading from XML file /oracle/apps/icx/por/schema/server/AmeTransactionTypeVVO.xml

                13/09/20 09:22:14 [932] Column count: 1

                13/09/20 09:22:14 [933] ViewObject: AmeTransactionTypeVVO Created new QUERY statement

                13/09/20 09:22:14 [934] AmeTransactionTypeVVO>#q computed SQLStmtBufLen: 146, actual=106, storing=136

                13/09/20 09:22:14 [935] SELECT ame_transaction_type

                FROM po_document_types

                WHERE document_type_code = :1

                AND document_subtype = :2

                13/09/20 09:22:14 [936]       pStmt = conn.prepareStatement("SELECT ame_transaction_type

                FROM po_document_types

                WHERE document_type_code = :1

                AND document_subtype = :2");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [937] Bind params for ViewObject: AmeTransactionTypeVVO

                13/09/20 09:22:14 [938] Binding param 1: REQUISITION

                13/09/20 09:22:14 [939]       pStmt.setObject(1, "REQUISITION");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [940] Binding param 2: PURCHASE

                13/09/20 09:22:14 [941]       pStmt.setObject(2, "PURCHASE");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [942] Column count: 1

                13/09/20 09:22:14 [943] ViewObject: AmeTransactionTypeVVO Reusing defined prepared Statement

                13/09/20 09:22:14 [944] Bind params for ViewObject: AmeTransactionTypeVVO

                13/09/20 09:22:14 [945] Binding param 1: REQUISITION

                13/09/20 09:22:14 [946]       pStmt.setObject(1, "REQUISITION");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [947] Binding param 2: INTERNAL

                13/09/20 09:22:14 [948]       pStmt.setObject(2, "INTERNAL");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [949] Column count: 1

                13/09/20 09:22:14 [950] ViewObject: AmeTransactionTypeVVO Reusing defined prepared Statement

                13/09/20 09:22:14 [951] Bind params for ViewObject: AmeTransactionTypeVVO

                13/09/20 09:22:14 [952] Binding param 1: CHANGE_REQUEST

                13/09/20 09:22:14 [953]       pStmt.setObject(1, "CHANGE_REQUEST");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [954] Binding param 2: REQUISITION

                13/09/20 09:22:14 [955]       pStmt.setObject(2, "REQUISITION");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [956] Clearing VO cache for AmeTransactionTypeVVO

                13/09/20 09:22:14 [957] Clear QueryCollection in cache for VO AmeTransactionTypeVVO

                13/09/20 09:22:14 [958]       stmt = conn.createStatement();  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [959]       cStmt = conn.prepareCall("      BEGIN              IGC_CBC_PO_GRP.is_cbc_enabled (              p_api_version    => 1.0             , p_init_msg_list => 'T'             , p_commit            => 'F'             , p_validation_level  => 100             , x_return_status     => :1            , x_msg_count         => :2            , x_msg_data          => :3            , x_cbc_enabled       => :4 );              END;  ");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [960]       cStmt = conn.prepareCall("begin :1 := po_core_s.get_product_install_status(:2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [961]       cStmt = conn.prepareCall("begin :1 := po_core_s.get_product_install_status(:2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [962] EntityRowSetImpl's jbo.assoc.consistent = true (1)

                13/09/20 09:22:14 [963] Column count: 67

                13/09/20 09:22:14 [964] ViewObject: PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO Created new QUERY statement

                13/09/20 09:22:14 [965] PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO>#q computed SQLStmtBufLen: 4039, actual=4007, storing=4037

                13/09/20 09:22:14 [966] SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE AS "InterfaceSourceCode", PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID AS "InterfaceSourceLineId", PoRequisitionHeaderEO.CLOSED_CODE AS "ClosedCode", PoRequisitionHeaderEO.ORG_ID AS "OrgId", PoRequisitionHeaderEO.DESCRIPTION AS "Description", PoRequisitionHeaderEO.AUTHORIZATION_STATUS AS "AuthorizationStatus", PoRequisitionHeaderEO.NOTE_TO_AUTHORIZER AS "NoteToAuthorizer", PoRequisitionHeaderEO.TYPE_LOOKUP_CODE AS "TypeLookupCode", PoRequisitionHeaderEO.TRANSFERRED_TO_OE_FLAG AS "TransferredToOeFlag", PoRequisitionHeaderEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoRequisitionHeaderEO.ON_LINE_FLAG AS "OnLineFlag", PoRequisitionHeaderEO.PRELIMINARY_RESEARCH_FLAG AS "PreliminaryResearchFlag", PoRequisitionHeaderEO.RESEARCH_COMPLETE_FLAG AS "ResearchCompleteFlag", PoRequisitionHeaderEO.PREPARER_FINISHED_FLAG AS "PreparerFinishedFlag", PoRequisitionHeaderEO.PREPARER_FINISHED_DATE AS "PreparerFinishedDate", PoRequisitionHeaderEO.AGENT_RETURN_FLAG AS "AgentReturnFlag", PoRequisitionHeaderEO.AGENT_RETURN_NOTE AS "AgentReturnNote", PoRequisitionHeaderEO.CANCEL_FLAG AS "CancelFlag", PoRequisitionHeaderEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoRequisitionHeaderEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoRequisitionHeaderEO.REQUEST_ID AS "RequestId", PoRequisitionHeaderEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoRequisitionHeaderEO.PROGRAM_ID AS "ProgramId", PoRequisitionHeaderEO.REQUISITION_HEADER_ID AS "RequisitionHeaderId", PoRequisitionHeaderEO.PREPARER_ID AS "PreparerId", PoRequisitionHeaderEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoRequisitionHeaderEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoRequisitionHeaderEO.SEGMENT1 AS "Segment1", PoRequisitionHeaderEO.SUMMARY_FLAG AS "SummaryFlag", PoRequisitionHeaderEO.ENABLED_FLAG AS "EnabledFlag", PoRequisitionHeaderEO.START_DATE_ACTIVE AS "StartDateActive", PoRequisitionHeaderEO.END_DATE_ACTIVE AS "EndDateActive", PoRequisitionHeaderEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoRequisitionHeaderEO.CREATION_DATE AS "CreationDate", PoRequisitionHeaderEO.CREATED_BY AS "CreatedBy", PoRequisitionHeaderEO.WF_ITEM_TYPE AS "WfItemType", PoRequisitionHeaderEO.WF_ITEM_KEY AS "WfItemKey", PoRequisitionHeaderEO.EMERGENCY_PO_NUM AS "EmergencyPoNum", PoRequisitionHeaderEO.PCARD_ID AS "PcardId", PoRequisitionHeaderEO.APPS_SOURCE_CODE AS "AppsSourceCode", PoRequisitionHeaderEO.SEGMENT2 AS "Segment2", PoRequisitionHeaderEO.SEGMENT3 AS "Segment3", PoRequisitionHeaderEO.SEGMENT4 AS "Segment4", PoRequisitionHeaderEO.SEGMENT5 AS "Segment5", PoRequisitionHeaderEO.ATTRIBUTE1 AS "Attribute1", PoRequisitionHeaderEO.ATTRIBUTE2 AS "Attribute2", PoRequisitionHeaderEO.ATTRIBUTE3 AS "Attribute3", PoRequisitionHeaderEO.ATTRIBUTE4 AS "Attribute4", PoRequisitionHeaderEO.ATTRIBUTE5 AS "Attribute5", PoRequisitionHeaderEO.ATTRIBUTE6 AS "Attribute6", PoRequisitionHeaderEO.ATTRIBUTE7 AS "Attribute7", PoRequisitionHeaderEO.ATTRIBUTE8 AS "Attribute8", PoRequisitionHeaderEO.ATTRIBUTE9 AS "Attribute9", PoRequisitionHeaderEO.ATTRIBUTE10 AS "Attribute10", PoRequisitionHeaderEO.ATTRIBUTE11 AS "Attribute11", PoRequisitionHeaderEO.ATTRIBUTE12 AS "Attribute12", PoRequisitionHeaderEO.ATTRIBUTE13 AS "Attribute13", PoRequisitionHeaderEO.ATTRIBUTE14 AS "Attribute14", PoRequisitionHeaderEO.ATTRIBUTE15 AS "Attribute15", PoRequisitionHeaderEO.CBC_ACCOUNTING_DATE AS "CbcAccountingDate", PoRequisitionHeaderEO.CHANGE_PENDING_FLAG AS "ChangePendingFlag", PoRequisitionHeaderEO.CONTRACTOR_REQUISITION_FLAG AS "ContractorRequisitionFlag", PoRequisitionHeaderEO.ACTIVE_SHOPPING_CART_FLAG AS "ActiveShoppingCartFlag", PoRequisitionHeaderEO.CONTRACTOR_STATUS AS "ContractorStatus", PoRequisitionHeaderEO.SUPPLIER_NOTIFIED_FLAG AS "SupplierNotifiedFlag", PoRequisitionHeaderEO.EMERGENCY_PO_ORG_ID AS "EmergencyPoOrgId" FROM PO_REQUISITION_HEADERS_ALL PoRequisitionHeaderEO WHERE PoRequisitionHeaderEO.REQUISITION_HEADER_ID = :1

                13/09/20 09:22:14 [967]       pStmt = conn.prepareStatement("SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE AS "InterfaceSourceCode", PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID AS "InterfaceSourceLineId", PoRequisitionHeaderEO.CLOSED_CODE AS "ClosedCode", PoRequisitionHeaderEO.ORG_ID AS "OrgId", PoRequisitionHeaderEO.DESCRIPTION AS "Description", PoRequisitionHeaderEO.AUTHORIZATION_STATUS AS "AuthorizationStatus", PoRequisitionHeaderEO.NOTE_TO_AUTHORIZER AS "NoteToAuthorizer", PoRequisitionHeaderEO.TYPE_LOOKUP_CODE AS "TypeLookupCode", PoRequisitionHeaderEO.TRANSFERRED_TO_OE_FLAG AS "TransferredToOeFlag", PoRequisitionHeaderEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoRequisitionHeaderEO.ON_LINE_FLAG AS "OnLineFlag", PoRequisitionHeaderEO.PRELIMINARY_RESEARCH_FLAG AS "PreliminaryResearchFlag", PoRequisitionHeaderEO.RESEARCH_COMPLETE_FLAG AS "ResearchCompleteFlag", PoRequisitionHeaderEO.PREPARER_FINISHED_FLAG AS "PreparerFinishedFlag", PoRequisitionHeaderEO.PREPARER_FINISHED_DATE AS "PreparerFinishedDate", PoRequisitionHeaderEO.AGENT_RETURN_FLAG AS "AgentReturnFlag", PoRequisitionHeaderEO.AGENT_RETURN_NOTE AS "AgentReturnNote", PoRequisitionHeaderEO.CANCEL_FLAG AS "CancelFlag", PoRequisitionHeaderEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoRequisitionHeaderEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoRequisitionHeaderEO.REQUEST_ID AS "RequestId", PoRequisitionHeaderEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoRequisitionHeaderEO.PROGRAM_ID AS "ProgramId", PoRequisitionHeaderEO.REQUISITION_HEADER_ID AS "RequisitionHeaderId", PoRequisitionHeaderEO.PREPARER_ID AS "PreparerId", PoRequisitionHeaderEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoRequisitionHeaderEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoRequisitionHeaderEO.SEGMENT1 AS "Segment1", PoRequisitionHeaderEO.SUMMARY_FLAG AS "SummaryFlag", PoRequisitionHeaderEO.ENABLED_FLAG AS "EnabledFlag", PoRequisitionHeaderEO.START_DATE_ACTIVE AS "StartDateActive", PoRequisitionHeaderEO.END_DATE_ACTIVE AS "EndDateActive", PoRequisitionHeaderEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoRequisitionHeaderEO.CREATION_DATE AS "CreationDate", PoRequisitionHeaderEO.CREATED_BY AS "CreatedBy", PoRequisitionHeaderEO.WF_ITEM_TYPE AS "WfItemType", PoRequisitionHeaderEO.WF_ITEM_KEY AS "WfItemKey", PoRequisitionHeaderEO.EMERGENCY_PO_NUM AS "EmergencyPoNum", PoRequisitionHeaderEO.PCARD_ID AS "PcardId", PoRequisitionHeaderEO.APPS_SOURCE_CODE AS "AppsSourceCode", PoRequisitionHeaderEO.SEGMENT2 AS "Segment2", PoRequisitionHeaderEO.SEGMENT3 AS "Segment3", PoRequisitionHeaderEO.SEGMENT4 AS "Segment4", PoRequisitionHeaderEO.SEGMENT5 AS "Segment5", PoRequisitionHeaderEO.ATTRIBUTE1 AS "Attribute1", PoRequisitionHeaderEO.ATTRIBUTE2 AS "Attribute2", PoRequisitionHeaderEO.ATTRIBUTE3 AS "Attribute3", PoRequisitionHeaderEO.ATTRIBUTE4 AS "Attribute4", PoRequisitionHeaderEO.ATTRIBUTE5 AS "Attribute5", PoRequisitionHeaderEO.ATTRIBUTE6 AS "Attribute6", PoRequisitionHeaderEO.ATTRIBUTE7 AS "Attribute7", PoRequisitionHeaderEO.ATTRIBUTE8 AS "Attribute8", PoRequisitionHeaderEO.ATTRIBUTE9 AS "Attribute9", PoRequisitionHeaderEO.ATTRIBUTE10 AS "Attribute10", PoRequisitionHeaderEO.ATTRIBUTE11 AS "Attribute11", PoRequisitionHeaderEO.ATTRIBUTE12 AS "Attribute12", PoRequisitionHeaderEO.ATTRIBUTE13 AS "Attribute13", PoRequisitionHeaderEO.ATTRIBUTE14 AS "Attribute14", PoRequisitionHeaderEO.ATTRIBUTE15 AS "Attribute15", PoRequisitionHeaderEO.CBC_ACCOUNTING_DATE AS "CbcAccountingDate", PoRequisitionHeaderEO.CHANGE_PENDING_FLAG AS "ChangePendingFlag", PoRequisitionHeaderEO.CONTRACTOR_REQUISITION_FLAG AS "ContractorRequisitionFlag", PoRequisitionHeaderEO.ACTIVE_SHOPPING_CART_FLAG AS "ActiveShoppingCartFlag", PoRequisitionHeaderEO.CONTRACTOR_STATUS AS "ContractorStatus", PoRequisitionHeaderEO.SUPPLIER_NOTIFIED_FLAG AS "SupplierNotifiedFlag", PoRequisitionHeaderEO.EMERGENCY_PO_ORG_ID AS "EmergencyPoOrgId" FROM PO_REQUISITION_HEADERS_ALL PoRequisitionHeaderEO WHERE PoRequisitionHeaderEO.REQUISITION_HEADER_ID = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [968] Bind params for ViewObject: PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO

                13/09/20 09:22:14 [969] For RowSet : PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO_0

                13/09/20 09:22:14 [970] Binding param 1: 6122

                13/09/20 09:22:14 [971] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [972]       pStmt.setObject(1, "6122");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [973] Loading from XML file /oracle/apps/icx/por/schema/server/EmployeeVVO.xml

                13/09/20 09:22:14 [974] Column count: 8

                13/09/20 09:22:14 [975] ViewObject: EmployeeVVO Created new QUERY statement

                13/09/20 09:22:14 [976] EmployeeVVO>#q computed SQLStmtBufLen: 1059, actual=1019, storing=1049

                13/09/20 09:22:14 [977] SELECT pap.full_name,              

                       pap.business_group_id,

                       pap.email_address,

                       hr_general.get_work_phone(pap.person_id) AS phone,

                       hr_general.get_phone_number(pap.person_id, 'WF') AS fax,

                       asgn.location_id,

                       pap.first_name,

                       pap.last_name

                FROM   per_all_people_f pap,

                       per_all_assignments_f asgn

                WHERE  pap.person_id = :1

                AND    asgn.person_id = pap.person_id

                AND    asgn.primary_flag = 'Y'

                AND    asgn.assignment_type IN ('E','C')

                AND    pap.effective_end_date in

                       ( SELECT min(pap2.effective_end_date)

                        FROM per_all_people_f pap2

                        WHERE pap2.person_id = pap.person_id

                        AND TRUNC(sysdate) <= pap2.effective_end_date )

                AND    asgn.effective_end_date in

                       ( select min(asgn2.effective_end_date)

                        from per_all_assignments_f asgn2

                        where asgn2.person_id = asgn.person_id

                        and asgn2.primary_flag = 'Y'       

                        and asgn2.assignment_type IN ('E','C')

                        and TRUNC(sysdate) <= asgn2.effective_end_date)

                13/09/20 09:22:14 [978]       pStmt = conn.prepareStatement("SELECT pap.full_name,              

                       pap.business_group_id,

                       pap.email_address,

                       hr_general.get_work_phone(pap.person_id) AS phone,

                       hr_general.get_phone_number(pap.person_id, 'WF') AS fax,

                       asgn.location_id,

                       pap.first_name,

                       pap.last_name

                FROM   per_all_people_f pap,

                       per_all_assignments_f asgn

                WHERE  pap.person_id = :1

                AND    asgn.person_id = pap.person_id

                AND    asgn.primary_flag = 'Y'

                AND    asgn.assignment_type IN ('E','C')

                AND    pap.effective_end_date in

                       ( SELECT min(pap2.effective_end_date)

                        FROM per_all_people_f pap2

                        WHERE pap2.person_id = pap.person_id

                        AND TRUNC(sysdate) <= pap2.effective_end_date )

                AND    asgn.effective_end_date in

                       ( select min(asgn2.effective_end_date)

                        from per_all_assignments_f asgn2

                        where asgn2.person_id = asgn.person_id

                        and asgn2.primary_flag = 'Y'       

                        and asgn2.assignment_type IN ('E','C')

                        and TRUNC(sysdate) <= asgn2.effective_end_date)");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [979] Bind params for ViewObject: EmployeeVVO

                13/09/20 09:22:14 [980] Binding param 1: 157

                13/09/20 09:22:14 [981] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [982]       pStmt.setObject(1, "157");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [983] Loading from XML file /oracle/apps/icx/por/schema/server/BuyerFromIdVVO.xml

                13/09/20 09:22:14 [984] Column count: 1

                13/09/20 09:22:14 [985] ViewObject: BuyerFromIdVVO Created new QUERY statement

                13/09/20 09:22:14 [986] BuyerFromIdVVO>#q computed SQLStmtBufLen: 331, actual=291, storing=321

                13/09/20 09:22:14 [987] SELECT pap.full_name

                FROM   per_all_people_f pap

                WHERE  pap.person_id = :1

                AND    pap.effective_end_date in

                       ( SELECT min(pap2.effective_end_date)

                        FROM per_all_people_f pap2

                        WHERE pap2.person_id = pap.person_id

                        AND TRUNC(sysdate) <= pap2.effective_end_date )

                13/09/20 09:22:14 [988]       pStmt = conn.prepareStatement("SELECT pap.full_name

                FROM   per_all_people_f pap

                WHERE  pap.person_id = :1

                AND    pap.effective_end_date in

                       ( SELECT min(pap2.effective_end_date)

                        FROM per_all_people_f pap2

                        WHERE pap2.person_id = pap.person_id

                        AND TRUNC(sysdate) <= pap2.effective_end_date )");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [989] Bind params for ViewObject: BuyerFromIdVVO

                13/09/20 09:22:14 [990] Binding param 1: 157

                13/09/20 09:22:14 [991] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [992]       pStmt.setObject(1, "157");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [993] Clearing VO cache for BuyerFromIdVVO

                13/09/20 09:22:14 [994] Clear QueryCollection in cache for VO BuyerFromIdVVO

                13/09/20 09:22:14 [995] Loading from XML file /oracle/apps/icx/por/schema/server/GetLookupMeaningVVO.xml

                13/09/20 09:22:14 [996] Column count: 1

                13/09/20 09:22:14 [997] ViewObject: GetLookupMeaningVVO Created new QUERY statement

                13/09/20 09:22:14 [998] GetLookupMeaningVVO>#q computed SQLStmtBufLen: 144, actual=104, storing=134

                13/09/20 09:22:14 [999] SELECT MEANING

                FROM   FND_LOOKUP_VALUES

                WHERE  LOOKUP_TYPE = :1

                AND LOOKUP_CODE = :2

                AND LANGUAGE = :3

                13/09/20 09:22:14 [1000]       pStmt = conn.prepareStatement("SELECT MEANING

                FROM   FND_LOOKUP_VALUES

                WHERE  LOOKUP_TYPE = :1

                AND LOOKUP_CODE = :2

                AND LANGUAGE = :3");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1001] Bind params for ViewObject: GetLookupMeaningVVO

                13/09/20 09:22:14 [1002] Binding param 1: DESTINATION TYPE

                13/09/20 09:22:14 [1003]       pStmt.setObject(1, "DESTINATION TYPE");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1004] Binding param 2: EXPENSE

                13/09/20 09:22:14 [1005]       pStmt.setObject(2, "EXPENSE");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1006] Binding param 3: US

                13/09/20 09:22:14 [1007]       pStmt.setObject(3, "US");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1008] Could not find method:getMeaning in oracle.apps.fnd.framework.server.OAViewRowImpl - oracle.apps.fnd.framework.server.OAViewRowImpl.getMeaning()

                13/09/20 09:22:14 [1009] Could not find method:getMeaning in oracle.jbo.server.OAJboViewRowImpl - oracle.jbo.server.OAJboViewRowImpl.getMeaning()

                13/09/20 09:22:14 [1010] Could not find method:getMeaning in oracle.jbo.server.ViewRowServiceImpl - oracle.jbo.server.ViewRowServiceImpl.getMeaning()

                13/09/20 09:22:14 [1011] Could not find method:setMeaning in oracle.apps.fnd.framework.server.OAViewRowImpl - oracle.apps.fnd.framework.server.OAViewRowImpl.setMeaning(java.lang.String)

                13/09/20 09:22:14 [1012] Could not find method:setMeaning in oracle.jbo.server.OAJboViewRowImpl - oracle.jbo.server.OAJboViewRowImpl.setMeaning(java.lang.String)

                13/09/20 09:22:14 [1013] Could not find method:setMeaning in oracle.jbo.server.ViewRowServiceImpl - oracle.jbo.server.ViewRowServiceImpl.setMeaning(java.lang.String)

                13/09/20 09:22:14 [1014] Loading from XML file /oracle/apps/icx/por/schema/server/LocationCodeVVO.xml

                13/09/20 09:22:14 [1015] Column count: 2

                13/09/20 09:22:14 [1016] ViewObject: LocationCodeVVO Created new QUERY statement

                13/09/20 09:22:14 [1017] LocationCodeVVO>#q computed SQLStmtBufLen: 240, actual=200, storing=230

                13/09/20 09:22:14 [1018] SELECT hrlt.location_code, hrl.inventory_organization_id

                FROM   hr_locations_all hrl, hr_locations_all_tl hrlt

                WHERE  hrl.location_id = :1

                and hrlt.location_id = hrl.location_id

                and hrlt.language = :2

                13/09/20 09:22:14 [1019]       pStmt = conn.prepareStatement("SELECT hrlt.location_code, hrl.inventory_organization_id

                FROM   hr_locations_all hrl, hr_locations_all_tl hrlt

                WHERE  hrl.location_id = :1

                and hrlt.location_id = hrl.location_id

                and hrlt.language = :2");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1020] Bind params for ViewObject: LocationCodeVVO

                13/09/20 09:22:14 [1021] Binding param 1: 142

                13/09/20 09:22:14 [1022] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1023]       pStmt.setObject(1, "142");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1024] Binding param 2: US

                13/09/20 09:22:14 [1025]       pStmt.setObject(2, "US");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1026] Clearing VO cache for LocationCodeVVO

                13/09/20 09:22:14 [1027] Clear QueryCollection in cache for VO LocationCodeVVO

                13/09/20 09:22:14 [1028] Column count: 8

                13/09/20 09:22:14 [1029] ViewObject: EmployeeVVO Reusing defined prepared Statement

                13/09/20 09:22:14 [1030] Bind params for ViewObject: EmployeeVVO

                13/09/20 09:22:14 [1031] Binding param 1: 157

                13/09/20 09:22:14 [1032] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1033]       pStmt.setObject(1, "157");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1034] Clearing VO cache for EmployeeVVO

                13/09/20 09:22:14 [1035] Clear QueryCollection in cache for VO EmployeeVVO

                13/09/20 09:22:14 [1036] Column count: 1

                13/09/20 09:22:14 [1037] ViewObject: GetLookupMeaningVVO Reusing defined prepared Statement

                13/09/20 09:22:14 [1038] Bind params for ViewObject: GetLookupMeaningVVO

                13/09/20 09:22:14 [1039] Binding param 1: POR_PCARD_ASSIGNED

                13/09/20 09:22:14 [1040]       pStmt.setObject(1, "POR_PCARD_ASSIGNED");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1041] Binding param 2: N

                13/09/20 09:22:14 [1042]       pStmt.setObject(2, "N");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1043] Binding param 3: US

                13/09/20 09:22:14 [1044]       pStmt.setObject(3, "US");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1045] Column count: 1

                13/09/20 09:22:14 [1046] ViewObject: GetLookupMeaningVVO Reusing defined prepared Statement

                13/09/20 09:22:14 [1047] Bind params for ViewObject: GetLookupMeaningVVO

                13/09/20 09:22:14 [1048] Binding param 1: YES_NO

                13/09/20 09:22:14 [1049]       pStmt.setObject(1, "YES_NO");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1050] Binding param 2: N

                13/09/20 09:22:14 [1051]       pStmt.setObject(2, "N");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1052] Binding param 3: US

                13/09/20 09:22:14 [1053]       pStmt.setObject(3, "US");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1054] Loading from XML file /oracle/apps/icx/por/schema/server/CategoryFromIdVVO.xml

                13/09/20 09:22:14 [1055] Column count: 2

                13/09/20 09:22:14 [1056] ViewObject: CategoryFromIdVVO Created new QUERY statement

                13/09/20 09:22:14 [1057] CategoryFromIdVVO>#q computed SQLStmtBufLen: 205, actual=165, storing=195

                13/09/20 09:22:14 [1058] SELECT mck.concatenated_segments, mcv.description

                FROM mtl_categories_kfv mck, mtl_categories_vl mcv

                WHERE mck.category_id = mcv.category_id

                AND mck.category_id = :1

                13/09/20 09:22:14 [1059]       pStmt = conn.prepareStatement("SELECT mck.concatenated_segments, mcv.description

                FROM mtl_categories_kfv mck, mtl_categories_vl mcv

                WHERE mck.category_id = mcv.category_id

                AND mck.category_id = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1060] Bind params for ViewObject: CategoryFromIdVVO

                13/09/20 09:22:14 [1061] Binding param 1: 1123

                13/09/20 09:22:14 [1062] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1063]       pStmt.setObject(1, "1123");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1064] Clearing VO cache for CategoryFromIdVVO

                13/09/20 09:22:14 [1065] Clear QueryCollection in cache for VO CategoryFromIdVVO

                13/09/20 09:22:14 [1066]       cStmt = conn.prepareCall("begin :1 := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(:2, :3); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1067] Loading from XML file /oracle/apps/icx/por/schema/server/TranslatedUomVVO.xml

                13/09/20 09:22:14 [1068] Column count: 2

                13/09/20 09:22:14 [1069] ViewObject: TranslatedUomVVO Created new QUERY statement

                13/09/20 09:22:14 [1070] TranslatedUomVVO>#q computed SQLStmtBufLen: 131, actual=91, storing=121

                13/09/20 09:22:14 [1071] SELECT unit_of_measure_tl, uom_code

                FROM mtl_units_of_measure_vl

                WHERE unit_of_measure = :1

                13/09/20 09:22:14 [1072]       pStmt = conn.prepareStatement("SELECT unit_of_measure_tl, uom_code

                FROM mtl_units_of_measure_vl

                WHERE unit_of_measure = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1073] Bind params for ViewObject: TranslatedUomVVO

                13/09/20 09:22:14 [1074] Binding param 1: EACH

                13/09/20 09:22:14 [1075]       pStmt.setObject(1, "EACH");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1076] Clearing VO cache for TranslatedUomVVO

                13/09/20 09:22:14 [1077] Clear QueryCollection in cache for VO TranslatedUomVVO

                13/09/20 09:22:14 [1078] Column count: 77

                13/09/20 09:22:14 [1079] ViewObject: PoReqDistributionsVO close prepared statements...

                13/09/20 09:22:14 [1080] ViewObject: PoReqDistributionsVO Created new QUERY statement

                13/09/20 09:22:14 [1081] PoReqDistributionsVO>#q computed SQLStmtBufLen: 3191, actual=3155, storing=3185

                13/09/20 09:22:14 [1082] SELECT PoReqDistributionEO.DISTRIBUTION_ID,         PoReqDistributionEO.LAST_UPDATE_DATE,          PoReqDistributionEO.LAST_UPDATED_BY,         PoReqDistributionEO.REQUISITION_LINE_ID,          PoReqDistributionEO.LAST_UPDATE_LOGIN,         PoReqDistributionEO.CREATION_DATE,          PoReqDistributionEO.CREATED_BY,         PoReqDistributionEO.DISTRIBUTION_NUM,          PoReqDistributionEO.SET_OF_BOOKS_ID,         PoReqDistributionEO.CODE_COMBINATION_ID,          PoReqDistributionEO.REQ_LINE_QUANTITY,         PoReqDistributionEO.ENCUMBERED_FLAG,          PoReqDistributionEO.GL_ENCUMBERED_DATE,         PoReqDistributionEO.GL_ENCUMBERED_PERIOD_NAME,          PoReqDistributionEO.GL_CANCELLED_DATE,         PoReqDistributionEO.FAILED_FUNDS_LOOKUP_CODE,          PoReqDistributionEO.ENCUMBERED_AMOUNT,         PoReqDistributionEO.BUDGET_ACCOUNT_ID,          PoReqDistributionEO.ACCRUAL_ACCOUNT_ID,         PoReqDistributionEO.VARIANCE_ACCOUNT_ID,          PoReqDistributionEO.PREVENT_ENCUMBRANCE_FLAG,          PoReqDistributionEO.ATTRIBUTE_CATEGORY,         PoReqDistributionEO.ATTRIBUTE1,          PoReqDistributionEO.ATTRIBUTE2,         PoReqDistributionEO.ATTRIBUTE3,          PoReqDistributionEO.ATTRIBUTE4,         PoReqDistributionEO.ATTRIBUTE5,          PoReqDistributionEO.ATTRIBUTE6,         PoReqDistributionEO.ATTRIBUTE7,          PoReqDistributionEO.ATTRIBUTE8,         PoReqDistributionEO.ATTRIBUTE9,          PoReqDistributionEO.ATTRIBUTE10,         PoReqDistributionEO.ATTRIBUTE11,          PoReqDistributionEO.ATTRIBUTE12,         PoReqDistributionEO.ATTRIBUTE13,          PoReqDistributionEO.ATTRIBUTE14,         PoReqDistributionEO.ATTRIBUTE15,          PoReqDistributionEO.USSGL_TRANSACTION_CODE,         PoReqDistributionEO.GOVERNMENT_CONTEXT,          PoReqDistributionEO.REQUEST_ID,         PoReqDistributionEO.PROGRAM_APPLICATION_ID,          PoReqDistributionEO.PROGRAM_ID,         PoReqDistributionEO.PROGRAM_UPDATE_DATE,          PoReqDistributionEO.PROJECT_ID,         PoReqDistributionEO.TASK_ID,          PoReqDistributionEO.EXPENDITURE_TYPE,         PoReqDistributionEO.PROJECT_ACCOUNTING_CONTEXT,          PoReqDistributionEO.EXPENDITURE_ORGANIZATION_ID,          PoReqDistributionEO.GL_CLOSED_DATE,         PoReqDistributionEO.SOURCE_REQ_DISTRIBUTION_ID,          PoReqDistributionEO.PROJECT_RELATED_FLAG,         PoReqDistributionEO.EXPENDITURE_ITEM_DATE,          PoReqDistributionEO.ORG_ID,         PoReqDistributionEO.ALLOCATION_TYPE,          PoReqDistributionEO.ALLOCATION_VALUE,         PoReqDistributionEO.AWARD_ID,          PoReqDistributionEO.END_ITEM_UNIT_NUMBER,         PoReqDistributionEO.RECOVERABLE_TAX,          PoReqDistributionEO.NONRECOVERABLE_TAX,         PoReqDistributionEO.RECOVERY_RATE,          PoReqDistributionEO.TAX_RECOVERY_OVERRIDE_FLAG,          PoReqDistributionEO.OKE_CONTRACT_LINE_ID,         PoReqDistributionEO.OKE_CONTRACT_DELIVERABLE_ID,          PoReqDistributionEO.REQ_LINE_AMOUNT,         PoReqDistributionEO.REQ_LINE_CURRENCY_AMOUNT,          PoReqDistributionEO.REQ_AWARD_ID FROM PO_REQ_DISTRIBUTIONS_ALL PoReqDistributionEO WHERE PoReqDistributionEO.REQUISITION_LINE_ID = :1

                13/09/20 09:22:14 [1083]       pStmt = conn.prepareStatement("SELECT PoReqDistributionEO.DISTRIBUTION_ID,         PoReqDistributionEO.LAST_UPDATE_DATE,          PoReqDistributionEO.LAST_UPDATED_BY,         PoReqDistributionEO.REQUISITION_LINE_ID,          PoReqDistributionEO.LAST_UPDATE_LOGIN,         PoReqDistributionEO.CREATION_DATE,          PoReqDistributionEO.CREATED_BY,         PoReqDistributionEO.DISTRIBUTION_NUM,          PoReqDistributionEO.SET_OF_BOOKS_ID,         PoReqDistributionEO.CODE_COMBINATION_ID,          PoReqDistributionEO.REQ_LINE_QUANTITY,         PoReqDistributionEO.ENCUMBERED_FLAG,          PoReqDistributionEO.GL_ENCUMBERED_DATE,         PoReqDistributionEO.GL_ENCUMBERED_PERIOD_NAME,          PoReqDistributionEO.GL_CANCELLED_DATE,         PoReqDistributionEO.FAILED_FUNDS_LOOKUP_CODE,          PoReqDistributionEO.ENCUMBERED_AMOUNT,         PoReqDistributionEO.BUDGET_ACCOUNT_ID,          PoReqDistributionEO.ACCRUAL_ACCOUNT_ID,         PoReqDistributionEO.VARIANCE_ACCOUNT_ID,          PoReqDistributionEO.PREVENT_ENCUMBRANCE_FLAG,          PoReqDistributionEO.ATTRIBUTE_CATEGORY,         PoReqDistributionEO.ATTRIBUTE1,          PoReqDistributionEO.ATTRIBUTE2,         PoReqDistributionEO.ATTRIBUTE3,          PoReqDistributionEO.ATTRIBUTE4,         PoReqDistributionEO.ATTRIBUTE5,          PoReqDistributionEO.ATTRIBUTE6,         PoReqDistributionEO.ATTRIBUTE7,          PoReqDistributionEO.ATTRIBUTE8,         PoReqDistributionEO.ATTRIBUTE9,          PoReqDistributionEO.ATTRIBUTE10,         PoReqDistributionEO.ATTRIBUTE11,          PoReqDistributionEO.ATTRIBUTE12,         PoReqDistributionEO.ATTRIBUTE13,          PoReqDistributionEO.ATTRIBUTE14,         PoReqDistributionEO.ATTRIBUTE15,          PoReqDistributionEO.USSGL_TRANSACTION_CODE,         PoReqDistributionEO.GOVERNMENT_CONTEXT,          PoReqDistributionEO.REQUEST_ID,         PoReqDistributionEO.PROGRAM_APPLICATION_ID,          PoReqDistributionEO.PROGRAM_ID,         PoReqDistributionEO.PROGRAM_UPDATE_DATE,          PoReqDistributionEO.PROJECT_ID,         PoReqDistributionEO.TASK_ID,          PoReqDistributionEO.EXPENDITURE_TYPE,         PoReqDistributionEO.PROJECT_ACCOUNTING_CONTEXT,          PoReqDistributionEO.EXPENDITURE_ORGANIZATION_ID,          PoReqDistributionEO.GL_CLOSED_DATE,         PoReqDistributionEO.SOURCE_REQ_DISTRIBUTION_ID,          PoReqDistributionEO.PROJECT_RELATED_FLAG,         PoReqDistributionEO.EXPENDITURE_ITEM_DATE,          PoReqDistributionEO.ORG_ID,         PoReqDistributionEO.ALLOCATION_TYPE,          PoReqDistributionEO.ALLOCATION_VALUE,         PoReqDistributionEO.AWARD_ID,          PoReqDistributionEO.END_ITEM_UNIT_NUMBER,         PoReqDistributionEO.RECOVERABLE_TAX,          PoReqDistributionEO.NONRECOVERABLE_TAX,         PoReqDistributionEO.RECOVERY_RATE,          PoReqDistributionEO.TAX_RECOVERY_OVERRIDE_FLAG,          PoReqDistributionEO.OKE_CONTRACT_LINE_ID,         PoReqDistributionEO.OKE_CONTRACT_DELIVERABLE_ID,          PoReqDistributionEO.REQ_LINE_AMOUNT,         PoReqDistributionEO.REQ_LINE_CURRENCY_AMOUNT,          PoReqDistributionEO.REQ_AWARD_ID FROM PO_REQ_DISTRIBUTIONS_ALL PoReqDistributionEO WHERE PoReqDistributionEO.REQUISITION_LINE_ID = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1084] Bind params for ViewObject: PoReqDistributionsVO

                13/09/20 09:22:14 [1085] Binding param 1: 6230

                13/09/20 09:22:14 [1086] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1087]       pStmt.setObject(1, "6230");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1088]       cStmt = conn.prepareCall("begin :1 := fnd_flex_ext.get_segs('SQLGL', 'GL#', :2, :3); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1089]       cStmt = conn.prepareCall("begin :1 := por_util_pkg.get_cost_center(:2); end;");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1090] Column count: 67

                13/09/20 09:22:14 [1091] ViewObject: PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO Reusing defined prepared Statement

                13/09/20 09:22:14 [1092] Bind params for ViewObject: PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO

                13/09/20 09:22:14 [1093] For RowSet : PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO_1

                13/09/20 09:22:14 [1094] Binding param 1: 6122

                13/09/20 09:22:14 [1095] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1096]       pStmt.setObject(1, "6122");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1097] Loading from XML file /oracle/apps/icx/por/schema/server/OrderTypeVVO.xml

                13/09/20 09:22:14 [1098] Column count: 1

                13/09/20 09:22:14 [1099] ViewObject: OrderTypeVVO Created new QUERY statement

                13/09/20 09:22:14 [1100] OrderTypeVVO>#q computed SQLStmtBufLen: 114, actual=74, storing=104

                13/09/20 09:22:14 [1101] SELECT order_type_lookup_code

                FROM po_line_types_b

                WHERE line_type_id = :1

                13/09/20 09:22:14 [1102]       pStmt = conn.prepareStatement("SELECT order_type_lookup_code

                FROM po_line_types_b

                WHERE line_type_id = :1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1103] Bind params for ViewObject: OrderTypeVVO

                13/09/20 09:22:14 [1104] Binding param 1: 1

                13/09/20 09:22:14 [1105] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1106]       pStmt.setObject(1, "1");  // JBO-JDBC-INTERACT

                13/09/20 09:22:14 [1107] Clearing VO cache for OrderTypeVVO

                13/09/20 09:22:14 [1108] Clear QueryCollection in cache for VO OrderTypeVVO

                13/09/20 09:22:14 [1109] ##### QueryCollection.finl no RowFilter

                13/09/20 09:22:15 [1110] OAPB: Page Securing Expression = ${oa.FunctionSecurity.ICX_POR_SHOPPING_CART}

                13/09/20 09:22:15 [1111] Loading from XML file /oracle/apps/icx/lov/server/server.xml

                13/09/20 09:22:15 [1112] Loading from individual XML files

                13/09/20 09:22:15 [1113] Loading the Containees for the Package 'oracle.apps.icx.lov.server.server'.

                13/09/20 09:22:15 [1114] Loading from XML file /oracle/apps/icx/lov/server/UnitOfMeasureVO.xml

                13/09/20 09:22:16 [1115] Column count: 9

                13/09/20 09:22:16 [1116] ViewObject: PoRequisitionLineEO_PorTemplateInfoEO_ReqLineToInfoTemplatesVL_PorInfoTemplatesVO Created new QUERY statement

                13/09/20 09:22:16 [1117] PoRequisitionLineEO_PorTemplateInfoEO_ReqLineToInfoTemplatesVL_PorInfoTemplatesVO>#q computed SQLStmtBufLen: 873, actual=827, storing=857

                13/09/20 09:22:16 [1118] SELECT * FROM (SELECT   

                INFO.REQUISITION_LINE_ID,

                TMPT.TEMPLATE_NAME,

                INFO.ATTRIBUTE_CODE,

                ATB.SEQUENCE,

                decode(ATB.REQUIRED_FLAG,'Y','yes','no') REQUIRED_FLAG,

                ATT.DESCRIPTION ATTRIBUTE_NAME,

                INFO.ATTRIBUTE_VALUE,

                decode(SETS.LONGLIST_FLAG,'Y','Poplist','N','Poplist','X','Poplist','TextInput') as AttributeStyle,

                SETS.FLEX_VALUE_SET_ID

                FROM    

                POR_TEMPLATE_INFO         INFO,

                POR_TEMPLATES_ALL_TL         TMPT,

                POR_TEMPLATE_ATTRIBUTES_B     ATB,

                POR_TEMPLATE_ATTRIBUTES_TL     ATT,

                FND_FLEX_VALUE_SETS         SETS

                WHERE    

                INFO.ATTRIBUTE_CODE = ATB.ATTRIBUTE_CODE

                AND    TMPT.TEMPLATE_CODE = ATB.TEMPLATE_CODE

                AND    ATB.ATTRIBUTE_CODE = ATT.ATTRIBUTE_CODE

                AND    TMPT.LANGUAGE = USERENV('LANG')

                AND     ATT.LANGUAGE = USERENV('LANG')

                AND     ATB.FLEX_VALUE_SET_ID=SETS.FLEX_VALUE_SET_ID(+)) QRSLT  WHERE REQUISITION_LINE_ID = :1 ORDER BY TEMPLATE_NAME, SEQUENCE

                13/09/20 09:22:16 [1119]       pStmt = conn.prepareStatement("SELECT * FROM (SELECT   

                INFO.REQUISITION_LINE_ID,

                TMPT.TEMPLATE_NAME,

                INFO.ATTRIBUTE_CODE,

                ATB.SEQUENCE,

                decode(ATB.REQUIRED_FLAG,'Y','yes','no') REQUIRED_FLAG,

                ATT.DESCRIPTION ATTRIBUTE_NAME,

                INFO.ATTRIBUTE_VALUE,

                decode(SETS.LONGLIST_FLAG,'Y','Poplist','N','Poplist','X','Poplist','TextInput') as AttributeStyle,

                SETS.FLEX_VALUE_SET_ID

                FROM    

                POR_TEMPLATE_INFO         INFO,

                POR_TEMPLATES_ALL_TL         TMPT,

                POR_TEMPLATE_ATTRIBUTES_B     ATB,

                POR_TEMPLATE_ATTRIBUTES_TL     ATT,

                FND_FLEX_VALUE_SETS         SETS

                WHERE    

                INFO.ATTRIBUTE_CODE = ATB.ATTRIBUTE_CODE

                AND    TMPT.TEMPLATE_CODE = ATB.TEMPLATE_CODE

                AND    ATB.ATTRIBUTE_CODE = ATT.ATTRIBUTE_CODE

                AND    TMPT.LANGUAGE = USERENV('LANG')

                AND     ATT.LANGUAGE = USERENV('LANG')

                AND     ATB.FLEX_VALUE_SET_ID=SETS.FLEX_VALUE_SET_ID(+)) QRSLT  WHERE REQUISITION_LINE_ID = :1 ORDER BY TEMPLATE_NAME, SEQUENCE");  // JBO-JDBC-INTERACT

                13/09/20 09:22:16 [1120] Bind params for ViewObject: PoRequisitionLineEO_PorTemplateInfoEO_ReqLineToInfoTemplatesVL_PorInfoTemplatesVO

                13/09/20 09:22:16 [1121] For RowSet : PoRequisitionLineEO_PorTemplateInfoEO_ReqLineToInfoTemplatesVL_PorInfoTemplatesVO_0

                13/09/20 09:22:16 [1122] Binding param 1: 6230

                13/09/20 09:22:16 [1123] // ERROR:  Unknown data type oracle.jbo.domain.Number    // JBO-JDBC-INTERACT

                13/09/20 09:22:16 [1124]       pStmt.setObject(1, "6230");  // JBO-JDBC-INTERACT

                13/09/20 09:22:16 [1125] Error while finalizing bean: OATableBean, localName='table'  oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_INVALID_ROOT_BEAN. Tokens: REGION_CODE = UomTable; REGION_APPL_ID = 178; STYLE = LIST_OF_VALUES;

                13/09/20 09:22:16 [1126] OAApplicationPoolImpl.setConnectionReleaseLevel was called with isReleased = true, isReserved = true

                13/09/20 09:22:16 [1127] setConnectionReleaseLevel - Set connection release level to 1

                13/09/20 09:22:16 [1128] AkAmParameterRegistryVO>#q old SQLStmtBufLen: 130, actual=100, storing=130

                13/09/20 09:22:16 [1129] select PARAM_NAME, PARAM_SOURCE

                from AK_AM_PARAMETER_REGISTRY

                where APPLICATIONMODULE_DEFN_NAME = :1

                13/09/20 09:22:16 [1130] PoRequisitionLinesVO>#q old SQLStmtBufLen: 8996, actual=8966, storing=8996

                13/09/20 09:22:16 [1131] SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,         PoRequisitionLineEO.REQUISITION_HEADER_ID,         PoRequisitionLineEO.LINE_NUM,         PoRequisitionLineEO.LAST_UPDATE_DATE,         PoRequisitionLineEO.LAST_UPDATED_BY,         PoRequisitionLineEO.LAST_UPDATE_LOGIN,         PoRequisitionLineEO.CREATION_DATE,         PoRequisitionLineEO.CREATED_BY,         PoRequisitionLineEO.DELIVER_TO_LOCATION_ID,         PoRequisitionLineEO.TO_PERSON_ID,         PoRequisitionLineEO.ITEM_DESCRIPTION,         PoRequisitionLineEO.CATEGORY_ID,         PoRequisitionLineEO.UNIT_MEAS_LOOKUP_CODE,         PoRequisitionLineEO.UNIT_PRICE,         PoRequisitionLineEO.QUANTITY,         PoRequisitionLineEO.LINE_TYPE_ID,         PoRequisitionLineEO.SOURCE_TYPE_CODE,         PoRequisitionLineEO.ITEM_ID,         PoRequisitionLineEO.ITEM_REVISION,         PoRequisitionLineEO.QUANTITY_DELIVERED,         PoRequisitionLineEO.SUGGESTED_BUYER_ID,         PoRequisitionLineEO.ENCUMBERED_FLAG,         PoRequisitionLineEO.RFQ_REQUIRED_FLAG,         PoRequisitionLineEO.NEED_BY_DATE,         PoRequisitionLineEO.LINE_LOCATION_ID,         PoRequisitionLineEO.MODIFIED_BY_AGENT_FLAG,         PoRequisitionLineEO.PARENT_REQ_LINE_ID,         PoRequisitionLineEO.JUSTIFICATION,         PoRequisitionLineEO.NOTE_TO_AGENT,         PoRequisitionLineEO.NOTE_TO_RECEIVER,         PoRequisitionLineEO.PURCHASING_AGENT_ID,         PoRequisitionLineEO.DOCUMENT_TYPE_CODE,         PoRequisitionLineEO.BLANKET_PO_HEADER_ID,         PoRequisitionLineEO.BLANKET_PO_LINE_NUM,         PoRequisitionLineEO.CURRENCY_CODE,         PoRequisitionLineEO.RATE_TYPE,         PoRequisitionLineEO.RATE_DATE,         PoRequisitionLineEO.RATE,         PoRequisitionLineEO.CURRENCY_UNIT_PRICE,         PoRequisitionLineEO.SUGGESTED_VENDOR_NAME,         PoRequisitionLineEO.SUGGESTED_VENDOR_LOCATION,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT,         PoRequisitionLineEO.SUGGESTED_VENDOR_PHONE,         PoRequisitionLineEO.SUGGESTED_VENDOR_PRODUCT_CODE,         PoRequisitionLineEO.UN_NUMBER_ID,         PoRequisitionLineEO.HAZARD_CLASS_ID,         PoRequisitionLineEO.MUST_USE_SUGG_VENDOR_FLAG,         PoRequisitionLineEO.REFERENCE_NUM,         PoRequisitionLineEO.ON_RFQ_FLAG,         PoRequisitionLineEO.URGENT_FLAG,         PoRequisitionLineEO.CANCEL_FLAG,         PoRequisitionLineEO.SOURCE_ORGANIZATION_ID,         PoRequisitionLineEO.SOURCE_SUBINVENTORY,         PoRequisitionLineEO.DESTINATION_TYPE_CODE,         PoRequisitionLineEO.DESTINATION_ORGANIZATION_ID,         PoRequisitionLineEO.DESTINATION_SUBINVENTORY,         PoRequisitionLineEO.QUANTITY_CANCELLED,         PoRequisitionLineEO.CANCEL_DATE,         PoRequisitionLineEO.CANCEL_REASON,         PoRequisitionLineEO.CLOSED_CODE,         PoRequisitionLineEO.AGENT_RETURN_NOTE,         PoRequisitionLineEO.CHANGED_AFTER_RESEARCH_FLAG,         PoRequisitionLineEO.VENDOR_ID,         PoRequisitionLineEO.VENDOR_SITE_ID,         PoRequisitionLineEO.VENDOR_CONTACT_ID,         PoRequisitionLineEO.RESEARCH_AGENT_ID,         PoRequisitionLineEO.ON_LINE_FLAG,         PoRequisitionLineEO.WIP_ENTITY_ID,         PoRequisitionLineEO.WIP_LINE_ID,         PoRequisitionLineEO.WIP_REPETITIVE_SCHEDULE_ID,         PoRequisitionLineEO.WIP_OPERATION_SEQ_NUM,         PoRequisitionLineEO.WIP_RESOURCE_SEQ_NUM,         PoRequisitionLineEO.ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.DESTINATION_CONTEXT,         PoRequisitionLineEO.INVENTORY_SOURCE_CONTEXT,         PoRequisitionLineEO.VENDOR_SOURCE_CONTEXT,         PoRequisitionLineEO.BOM_RESOURCE_ID,         PoRequisitionLineEO.REQUEST_ID,         PoRequisitionLineEO.PROGRAM_APPLICATION_ID,         PoRequisitionLineEO.PROGRAM_ID,         PoRequisitionLineEO.PROGRAM_UPDATE_DATE,         PoRequisitionLineEO.USSGL_TRANSACTION_CODE,         PoRequisitionLineEO.GOVERNMENT_CONTEXT,         PoRequisitionLineEO.CLOSED_REASON,         PoRequisitionLineEO.CLOSED_DATE,         PoRequisitionLineEO.TRANSACTION_REASON_CODE,         PoRequisitionLineEO.QUANTITY_RECEIVED,         PoRequisitionLineEO.SOURCE_REQ_LINE_ID,         PoRequisitionLineEO.ORG_ID,         PoRequisitionLineEO.KANBAN_CARD_ID,         PoRequisitionLineEO.CATALOG_TYPE,         PoRequisitionLineEO.CATALOG_SOURCE,         PoRequisitionLineEO.MANUFACTURER_ID,         PoRequisitionLineEO.MANUFACTURER_NAME,         PoRequisitionLineEO.MANUFACTURER_PART_NUMBER,         PoRequisitionLineEO.REQUESTER_EMAIL,         PoRequisitionLineEO.REQUESTER_FAX,         PoRequisitionLineEO.REQUESTER_PHONE,         PoRequisitionLineEO.UNSPSC_CODE,         PoRequisitionLineEO.OTHER_CATEGORY_CODE,         PoRequisitionLineEO.SUPPLIER_DUNS,         PoRequisitionLineEO.TAX_STATUS_INDICATOR,         PoRequisitionLineEO.PCARD_FLAG,         PoRequisitionLineEO.NEW_SUPPLIER_FLAG,         PoRequisitionLineEO.AUTO_RECEIVE_FLAG,         PoRequisitionLineEO.TAX_USER_OVERRIDE_FLAG,         PoRequisitionLineEO.TAX_CODE_ID,         PoRequisitionLineEO.NOTE_TO_VENDOR,         PoRequisitionLineEO.OKE_CONTRACT_VERSION_ID,         PoRequisitionLineEO.OKE_CONTRACT_HEADER_ID,         PoRequisitionLineEO.ITEM_SOURCE_ID,         PoRequisitionLineEO.SUPPLIER_REF_NUMBER,         PoRequisitionLineEO.SECONDARY_UNIT_OF_MEASURE,         PoRequisitionLineEO.SECONDARY_QUANTITY,         PoRequisitionLineEO.PREFERRED_GRADE,         PoRequisitionLineEO.SECONDARY_QUANTITY_RECEIVED,         PoRequisitionLineEO.SECONDARY_QUANTITY_CANCELLED,         PoRequisitionLineEO.AUCTION_HEADER_ID,         PoRequisitionLineEO.AUCTION_DISPLAY_NUMBER,         PoRequisitionLineEO.AUCTION_LINE_NUMBER,         PoRequisitionLineEO.REQS_IN_POOL_FLAG,         PoRequisitionLineEO.VMI_FLAG,         PoRequisitionLineEO.ATTRIBUTE1,         PoRequisitionLineEO.ATTRIBUTE2,         PoRequisitionLineEO.ATTRIBUTE3,         PoRequisitionLineEO.ATTRIBUTE4,         PoRequisitionLineEO.ATTRIBUTE5,         PoRequisitionLineEO.ATTRIBUTE6,         PoRequisitionLineEO.ATTRIBUTE7,         PoRequisitionLineEO.ATTRIBUTE8,         PoRequisitionLineEO.ATTRIBUTE9,         PoRequisitionLineEO.ATTRIBUTE10,         PoRequisitionLineEO.ATTRIBUTE11,         PoRequisitionLineEO.ATTRIBUTE12,         PoRequisitionLineEO.ATTRIBUTE13,         PoRequisitionLineEO.ATTRIBUTE14,         PoRequisitionLineEO.ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE1,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE2,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE3,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE4,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE5,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE6,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE7,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE8,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE9,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE10,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE11,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE12,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE13,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE14,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE16,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE17,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE18,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE19,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE20,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.BID_NUMBER,         PoRequisitionLineEO.BID_LINE_NUMBER,         PoRequisitionLineEO.AMOUNT,         PoRequisitionLineEO.CURRENCY_AMOUNT,         PoRequisitionLineEO.NONCAT_TEMPLATE_ID,         PoRequisitionLineEO.JOB_ID,         PoRequisitionLineEO.CONTACT_INFORMATION,         PoRequisitionLineEO.CANDIDATE_SCREENING_REQD_FLAG,         PoRequisitionLineEO.SUGGESTED_SUPPLIER_FLAG,         PoRequisitionLineEO.ASSIGNMENT_END_DATE,         PoRequisitionLineEO.OVERTIME_ALLOWED_FLAG,         PoRequisitionLineEO.CONTRACTOR_REQUISITION_FLAG,         PoRequisitionLineEO.LABOR_REQ_LINE_ID,         PoRequisitionLineEO.JOB_LONG_DESCRIPTION,         PoRequisitionLineEO.CONTRACTOR_STATUS,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_FAX,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_EMAIL,         PoRequisitionLineEO.CANDIDATE_FIRST_NAME,         PoRequisitionLineEO.CANDIDATE_LAST_NAME,         PoRequisitionLineEO.ASSIGNMENT_START_DATE,         PoRequisitionLineEO.ORDER_TYPE_LOOKUP_CODE,         PoRequisitionLineEO.PURCHASE_BASIS,         PoRequisitionLineEO.MATCHING_BASIS,         PoRequisitionLineEO.NEGOTIATED_BY_PREPARER_FLAG,         PoRequisitionLineEO.BASE_UNIT_PRICE,         PoRequisitionLineEO.AT_SOURCING_FLAG,         PoRequisitionLineEO.TAX_ATTRIBUTE_UPDATE_CODE,         PoRequisitionLineEO.DROP_SHIP_FLAG,         PoRequisitionLineEO.SHIP_METHOD,         PoRequisitionLineEO.ESTIMATED_PICKUP_DATE,         PoRequisitionLineEO.SUPPLIER_NOTIFIED_FOR_CANCEL,         PoRequisitionLineEO.TAX_NAME FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO WHERE PoRequisitionLineEO.REQUISITION_HEADER_ID = :1 ORDER BY Line_NUM ASC

                13/09/20 09:22:16 [1132] PoRequisitionHeadersVO>#q old SQLStmtBufLen: 3276, actual=3246, storing=3276

                13/09/20 09:22:16 [1133] SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE,         PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE,          PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID,          PoRequisitionHeaderEO.CLOSED_CODE,         PoRequisitionHeaderEO.ORG_ID,          PoRequisitionHeaderEO.DESCRIPTION,         PoRequisitionHeaderEO.AUTHORIZATION_STATUS,          PoRequisitionHeaderEO.NOTE_TO_AUTHORIZER,         PoRequisitionHeaderEO.TYPE_LOOKUP_CODE,          PoRequisitionHeaderEO.TRANSFERRED_TO_OE_FLAG,          PoRequisitionHeaderEO.ATTRIBUTE_CATEGORY,         PoRequisitionHeaderEO.ON_LINE_FLAG,          PoRequisitionHeaderEO.PRELIMINARY_RESEARCH_FLAG,          PoRequisitionHeaderEO.RESEARCH_COMPLETE_FLAG,         PoRequisitionHeaderEO.PREPARER_FINISHED_FLAG,          PoRequisitionHeaderEO.PREPARER_FINISHED_DATE,          PoRequisitionHeaderEO.AGENT_RETURN_FLAG,         PoRequisitionHeaderEO.AGENT_RETURN_NOTE,          PoRequisitionHeaderEO.CANCEL_FLAG,         PoRequisitionHeaderEO.USSGL_TRANSACTION_CODE,          PoRequisitionHeaderEO.GOVERNMENT_CONTEXT,         PoRequisitionHeaderEO.REQUEST_ID,          PoRequisitionHeaderEO.PROGRAM_APPLICATION_ID,          PoRequisitionHeaderEO.PROGRAM_ID,         PoRequisitionHeaderEO.REQUISITION_HEADER_ID,          PoRequisitionHeaderEO.PREPARER_ID,         PoRequisitionHeaderEO.LAST_UPDATE_DATE,          PoRequisitionHeaderEO.LAST_UPDATED_BY,         PoRequisitionHeaderEO.SEGMENT1,          PoRequisitionHeaderEO.SUMMARY_FLAG,         PoRequisitionHeaderEO.ENABLED_FLAG,          PoRequisitionHeaderEO.START_DATE_ACTIVE,         PoRequisitionHeaderEO.END_DATE_ACTIVE,          PoRequisitionHeaderEO.LAST_UPDATE_LOGIN,         PoRequisitionHeaderEO.CREATION_DATE,          PoRequisitionHeaderEO.CREATED_BY,         PoRequisitionHeaderEO.WF_ITEM_TYPE,          PoRequisitionHeaderEO.WF_ITEM_KEY,         PoRequisitionHeaderEO.EMERGENCY_PO_NUM,          PoRequisitionHeaderEO.PCARD_ID,         PoRequisitionHeaderEO.APPS_SOURCE_CODE,          PoRequisitionHeaderEO.SEGMENT2,         PoRequisitionHeaderEO.SEGMENT3,          PoRequisitionHeaderEO.SEGMENT4,         PoRequisitionHeaderEO.SEGMENT5,          PoRequisitionHeaderEO.ATTRIBUTE1,         PoRequisitionHeaderEO.ATTRIBUTE2,          PoRequisitionHeaderEO.ATTRIBUTE3,         PoRequisitionHeaderEO.ATTRIBUTE4,          PoRequisitionHeaderEO.ATTRIBUTE5,         PoRequisitionHeaderEO.ATTRIBUTE6,          PoRequisitionHeaderEO.ATTRIBUTE7,         PoRequisitionHeaderEO.ATTRIBUTE8,          PoRequisitionHeaderEO.ATTRIBUTE9,         PoRequisitionHeaderEO.ATTRIBUTE10,          PoRequisitionHeaderEO.ATTRIBUTE11,         PoRequisitionHeaderEO.ATTRIBUTE12,          PoRequisitionHeaderEO.ATTRIBUTE13,         PoRequisitionHeaderEO.ATTRIBUTE14,          PoRequisitionHeaderEO.ATTRIBUTE15,         PoRequisitionHeaderEO.CBC_ACCOUNTING_DATE,          PoRequisitionHeaderEO.CHANGE_PENDING_FLAG,         PoRequisitionHeaderEO.CONTRACTOR_REQUISITION_FLAG,          PoRequisitionHeaderEO.ACTIVE_SHOPPING_CART_FLAG,          PoRequisitionHeaderEO.CONTRACTOR_STATUS,         PoRequisitionHeaderEO.SUPPLIER_NOTIFIED_FLAG,          PoRequisitionHeaderEO.EMERGENCY_PO_ORG_ID FROM PO_REQUISITION_HEADERS_ALL PoRequisitionHeaderEO WHERE requisition_header_id = :1

                13/09/20 09:22:16 [1134] PoReqDistributionsVO>#q old SQLStmtBufLen: 3185, actual=3155, storing=3185

                13/09/20 09:22:16 [1135] SELECT PoReqDistributionEO.DISTRIBUTION_ID,         PoReqDistributionEO.LAST_UPDATE_DATE,          PoReqDistributionEO.LAST_UPDATED_BY,         PoReqDistributionEO.REQUISITION_LINE_ID,          PoReqDistributionEO.LAST_UPDATE_LOGIN,         PoReqDistributionEO.CREATION_DATE,          PoReqDistributionEO.CREATED_BY,         PoReqDistributionEO.DISTRIBUTION_NUM,          PoReqDistributionEO.SET_OF_BOOKS_ID,         PoReqDistributionEO.CODE_COMBINATION_ID,          PoReqDistributionEO.REQ_LINE_QUANTITY,         PoReqDistributionEO.ENCUMBERED_FLAG,          PoReqDistributionEO.GL_ENCUMBERED_DATE,         PoReqDistributionEO.GL_ENCUMBERED_PERIOD_NAME,          PoReqDistributionEO.GL_CANCELLED_DATE,         PoReqDistributionEO.FAILED_FUNDS_LOOKUP_CODE,          PoReqDistributionEO.ENCUMBERED_AMOUNT,         PoReqDistributionEO.BUDGET_ACCOUNT_ID,          PoReqDistributionEO.ACCRUAL_ACCOUNT_ID,         PoReqDistributionEO.VARIANCE_ACCOUNT_ID,          PoReqDistributionEO.PREVENT_ENCUMBRANCE_FLAG,          PoReqDistributionEO.ATTRIBUTE_CATEGORY,         PoReqDistributionEO.ATTRIBUTE1,          PoReqDistributionEO.ATTRIBUTE2,         PoReqDistributionEO.ATTRIBUTE3,          PoReqDistributionEO.ATTRIBUTE4,         PoReqDistributionEO.ATTRIBUTE5,          PoReqDistributionEO.ATTRIBUTE6,         PoReqDistributionEO.ATTRIBUTE7,          PoReqDistributionEO.ATTRIBUTE8,         PoReqDistributionEO.ATTRIBUTE9,          PoReqDistributionEO.ATTRIBUTE10,         PoReqDistributionEO.ATTRIBUTE11,          PoReqDistributionEO.ATTRIBUTE12,         PoReqDistributionEO.ATTRIBUTE13,          PoReqDistributionEO.ATTRIBUTE14,         PoReqDistributionEO.ATTRIBUTE15,          PoReqDistributionEO.USSGL_TRANSACTION_CODE,         PoReqDistributionEO.GOVERNMENT_CONTEXT,          PoReqDistributionEO.REQUEST_ID,         PoReqDistributionEO.PROGRAM_APPLICATION_ID,          PoReqDistributionEO.PROGRAM_ID,         PoReqDistributionEO.PROGRAM_UPDATE_DATE,          PoReqDistributionEO.PROJECT_ID,         PoReqDistributionEO.TASK_ID,          PoReqDistributionEO.EXPENDITURE_TYPE,         PoReqDistributionEO.PROJECT_ACCOUNTING_CONTEXT,          PoReqDistributionEO.EXPENDITURE_ORGANIZATION_ID,          PoReqDistributionEO.GL_CLOSED_DATE,         PoReqDistributionEO.SOURCE_REQ_DISTRIBUTION_ID,          PoReqDistributionEO.PROJECT_RELATED_FLAG,         PoReqDistributionEO.EXPENDITURE_ITEM_DATE,          PoReqDistributionEO.ORG_ID,         PoReqDistributionEO.ALLOCATION_TYPE,          PoReqDistributionEO.ALLOCATION_VALUE,         PoReqDistributionEO.AWARD_ID,          PoReqDistributionEO.END_ITEM_UNIT_NUMBER,         PoReqDistributionEO.RECOVERABLE_TAX,          PoReqDistributionEO.NONRECOVERABLE_TAX,         PoReqDistributionEO.RECOVERY_RATE,          PoReqDistributionEO.TAX_RECOVERY_OVERRIDE_FLAG,          PoReqDistributionEO.OKE_CONTRACT_LINE_ID,         PoReqDistributionEO.OKE_CONTRACT_DELIVERABLE_ID,          PoReqDistributionEO.REQ_LINE_AMOUNT,         PoReqDistributionEO.REQ_LINE_CURRENCY_AMOUNT,          PoReqDistributionEO.REQ_AWARD_ID FROM PO_REQ_DISTRIBUTIONS_ALL PoReqDistributionEO WHERE PoReqDistributionEO.REQUISITION_LINE_ID = :1

                13/09/20 09:22:16 [1136] ActiveReqHeaderVO>#q old SQLStmtBufLen: 170, actual=140, storing=170

                13/09/20 09:22:16 [1137] SELECT requisition_header_id

                FROM po_requisition_headers_all

                WHERE active_shopping_cart_flag = 'Y'

                AND last_updated_by = :1

                AND org_id = :2

                13/09/20 09:22:16 [1138] PoRequisitionLineEO_PoRequisitionHeaderEO_ReqHeaderToReqLinesAO>#q old SQLStmtBufLen: 4037, actual=4007, storing=4037

                13/09/20 09:22:16 [1139] SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE AS "ProgramUpdateDate", PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE AS "InterfaceSourceCode", PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID AS "InterfaceSourceLineId", PoRequisitionHeaderEO.CLOSED_CODE AS "ClosedCode", PoRequisitionHeaderEO.ORG_ID AS "OrgId", PoRequisitionHeaderEO.DESCRIPTION AS "Description", PoRequisitionHeaderEO.AUTHORIZATION_STATUS AS "AuthorizationStatus", PoRequisitionHeaderEO.NOTE_TO_AUTHORIZER AS "NoteToAuthorizer", PoRequisitionHeaderEO.TYPE_LOOKUP_CODE AS "TypeLookupCode", PoRequisitionHeaderEO.TRANSFERRED_TO_OE_FLAG AS "TransferredToOeFlag", PoRequisitionHeaderEO.ATTRIBUTE_CATEGORY AS "AttributeCategory", PoRequisitionHeaderEO.ON_LINE_FLAG AS "OnLineFlag", PoRequisitionHeaderEO.PRELIMINARY_RESEARCH_FLAG AS "PreliminaryResearchFlag", PoRequisitionHeaderEO.RESEARCH_COMPLETE_FLAG AS "ResearchCompleteFlag", PoRequisitionHeaderEO.PREPARER_FINISHED_FLAG AS "PreparerFinishedFlag", PoRequisitionHeaderEO.PREPARER_FINISHED_DATE AS "PreparerFinishedDate", PoRequisitionHeaderEO.AGENT_RETURN_FLAG AS "AgentReturnFlag", PoRequisitionHeaderEO.AGENT_RETURN_NOTE AS "AgentReturnNote", PoRequisitionHeaderEO.CANCEL_FLAG AS "CancelFlag", PoRequisitionHeaderEO.USSGL_TRANSACTION_CODE AS "UssglTransactionCode", PoRequisitionHeaderEO.GOVERNMENT_CONTEXT AS "GovernmentContext", PoRequisitionHeaderEO.REQUEST_ID AS "RequestId", PoRequisitionHeaderEO.PROGRAM_APPLICATION_ID AS "ProgramApplicationId", PoRequisitionHeaderEO.PROGRAM_ID AS "ProgramId", PoRequisitionHeaderEO.REQUISITION_HEADER_ID AS "RequisitionHeaderId", PoRequisitionHeaderEO.PREPARER_ID AS "PreparerId", PoRequisitionHeaderEO.LAST_UPDATE_DATE AS "LastUpdateDate", PoRequisitionHeaderEO.LAST_UPDATED_BY AS "LastUpdatedBy", PoRequisitionHeaderEO.SEGMENT1 AS "Segment1", PoRequisitionHeaderEO.SUMMARY_FLAG AS "SummaryFlag", PoRequisitionHeaderEO.ENABLED_FLAG AS "EnabledFlag", PoRequisitionHeaderEO.START_DATE_ACTIVE AS "StartDateActive", PoRequisitionHeaderEO.END_DATE_ACTIVE AS "EndDateActive", PoRequisitionHeaderEO.LAST_UPDATE_LOGIN AS "LastUpdateLogin", PoRequisitionHeaderEO.CREATION_DATE AS "CreationDate", PoRequisitionHeaderEO.CREATED_BY AS "CreatedBy", PoRequisitionHeaderEO.WF_ITEM_TYPE AS "WfItemType", PoRequisitionHeaderEO.WF_ITEM_KEY AS "WfItemKey", PoRequisitionHeaderEO.EMERGENCY_PO_NUM AS "EmergencyPoNum", PoRequisitionHeaderEO.PCARD_ID AS "PcardId", PoRequisitionHeaderEO.APPS_SOURCE_CODE AS "AppsSourceCode", PoRequisitionHeaderEO.SEGMENT2 AS "Segment2", PoRequisitionHeaderEO.SEGMENT3 AS "Segment3", PoRequisitionHeaderEO.SEGMENT4 AS "Segment4", PoRequisitionHeaderEO.SEGMENT5 AS "Segment5", PoRequisitionHeaderEO.ATTRIBUTE1 AS "Attribute1", PoRequisitionHeaderEO.ATTRIBUTE2 AS "Attribute2", PoRequisitionHeaderEO.ATTRIBUTE3 AS "Attribute3", PoRequisitionHeaderEO.ATTRIBUTE4 AS "Attribute4", PoRequisitionHeaderEO.ATTRIBUTE5 AS "Attribute5", PoRequisitionHeaderEO.ATTRIBUTE6 AS "Attribute6", PoRequisitionHeaderEO.ATTRIBUTE7 AS "Attribute7", PoRequisitionHeaderEO.ATTRIBUTE8 AS "Attribute8", PoRequisitionHeaderEO.ATTRIBUTE9 AS "Attribute9", PoRequisitionHeaderEO.ATTRIBUTE10 AS "Attribute10", PoRequisitionHeaderEO.ATTRIBUTE11 AS "Attribute11", PoRequisitionHeaderEO.ATTRIBUTE12 AS "Attribute12", PoRequisitionHeaderEO.ATTRIBUTE13 AS "Attribute13", PoRequisitionHeaderEO.ATTRIBUTE14 AS "Attribute14", PoRequisitionHeaderEO.ATTRIBUTE15 AS "Attribute15", PoRequisitionHeaderEO.CBC_ACCOUNTING_DATE AS "CbcAccountingDate", PoRequisitionHeaderEO.CHANGE_PENDING_FLAG AS "ChangePendingFlag", PoRequisitionHeaderEO.CONTRACTOR_REQUISITION_FLAG AS "ContractorRequisitionFlag", PoRequisitionHeaderEO.ACTIVE_SHOPPING_CART_FLAG AS "ActiveShoppingCartFlag", PoRequisitionHeaderEO.CONTRACTOR_STATUS AS "ContractorStatus", PoRequisitionHeaderEO.SUPPLIER_NOTIFIED_FLAG AS "SupplierNotifiedFlag", PoRequisitionHeaderEO.EMERGENCY_PO_ORG_ID AS "EmergencyPoOrgId" FROM PO_REQUISITION_HEADERS_ALL PoRequisitionHeaderEO WHERE PoRequisitionHeaderEO.REQUISITION_HEADER_ID = :1

                13/09/20 09:22:16 [1140] UnitOfMeasureVO>#q computed SQLStmtBufLen: 1397, actual=1357, storing=1387

                13/09/20 09:22:16 [1141] SELECT DISTINCT muc.unit_of_measure_tl,

                                mum.uom_code,

                                muc.unit_of_measure unit_of_measure,

                                muc.description     description,

                                -9999               item_id

                FROM   mtl_uom_conversions_val_v muc,

                       mtl_units_of_measure mum

                WHERE  muc.unit_of_measure = mum.unit_of_measure

                       AND ( muc.uom_class IN (SELECT mcc.to_uom_class

                                               FROM   mtl_uom_class_conv_val_v mcc

                                               WHERE  mcc.inventory_item_id = :1)

                              OR muc.uom_class = (SELECT muom.uom_class

                                                  FROM   mtl_system_items msi,

                                                         financials_system_parameters fsp,

                                                         mtl_units_of_measure muom

                                                  WHERE  msi.inventory_item_id = :2

                                                         AND msi.organization_id =

                                                             fsp.inventory_organization_id

                                                         AND msi.allowed_units_lookup_code IN (

                                                             2, 3 )

                                                         AND msi.primary_uom_code =

                                                             muom.uom_code) )

                       AND ( muc.item_id = 0

                              OR muc.item_id = :3 )

                ORDER  BY Upper(muc.unit_of_measure)

                13/09/20 09:22:16 [1142] PoRequisitionLineEO_PorTemplateInfoEO_ReqLineToInfoTemplatesVL_PorInfoTemplatesVO>#q old SQLStmtBufLen: 857, actual=827, storing=857

                13/09/20 09:22:16 [1143] SELECT * FROM (SELECT   

                INFO.REQUISITION_LINE_ID,

                TMPT.TEMPLATE_NAME,

                INFO.ATTRIBUTE_CODE,

                ATB.SEQUENCE,

                decode(ATB.REQUIRED_FLAG,'Y','yes','no') REQUIRED_FLAG,

                ATT.DESCRIPTION ATTRIBUTE_NAME,

                INFO.ATTRIBUTE_VALUE,

                decode(SETS.LONGLIST_FLAG,'Y','Poplist','N','Poplist','X','Poplist','TextInput') as AttributeStyle,

                SETS.FLEX_VALUE_SET_ID

                FROM    

                POR_TEMPLATE_INFO         INFO,

                POR_TEMPLATES_ALL_TL         TMPT,

                POR_TEMPLATE_ATTRIBUTES_B     ATB,

                POR_TEMPLATE_ATTRIBUTES_TL     ATT,

                FND_FLEX_VALUE_SETS         SETS

                WHERE    

                INFO.ATTRIBUTE_CODE = ATB.ATTRIBUTE_CODE

                AND    TMPT.TEMPLATE_CODE = ATB.TEMPLATE_CODE

                AND    ATB.ATTRIBUTE_CODE = ATT.ATTRIBUTE_CODE

                AND    TMPT.LANGUAGE = USERENV('LANG')

                AND     ATT.LANGUAGE = USERENV('LANG')

                AND     ATB.FLEX_VALUE_SET_ID=SETS.FLEX_VALUE_SET_ID(+)) QRSLT  WHERE REQUISITION_LINE_ID = :1 ORDER BY TEMPLATE_NAME, SEQUENCE

                13/09/20 09:22:16 [1144] ##### QueryCollection.finl oracle.jbo.Key[6230 ]

                13/09/20 09:22:16 [1145] OAApplicationPoolImpl.setConnectionReleaseLevel was called with isReleased = false, isReserved = true

                13/09/20 09:22:16 [1146] setConnectionReleaseLevel - Set connection release level to 0

                1 2 Previous Next