Tried Export Of GL Batch Using IHUB But Throwing Error.

(Doc ID 1612167.1)

Last updated on MARCH 03, 2014

Applies to:

Oracle Media Intellectual Property Management - Version 3.3.16.0 and later
Information in this document applies to any platform.

Symptoms

Issue has been clarified:



Customer created a GL batch # 494 in FIN and tried to export using IHUB.

Got the following error in log file.

11/21/2013 17:35:26 - ERROR - com.sophoi.ipls2.common.db.DataManager - user=executeGLBatchWhenBatchMessageIsBatchExecuteForIntegrationHub|query=SELECT gl_transaction_sys_id, terr_sys_id, (SELECT TERRITORY_NAME FROM TERRITORY WHERE terr_sys_id = gl.terr_sys_id) TERRITORY_NAME, master_media_sys_id, (SELECT MEDIA_NAME FROM MASTER_MEDIA WHERE master_media_sys_id = gl.master_media_sys_id) MEDIA_NAME, credit_amount, debit_amount, gl_source_sys_id, (SELECT description FROM MASTER_GL_SOURCE WHERE gl_source_sys_id = gl.gl_source_sys_id) gl_source, gl_account_type_sys_id, (SELECT description FROM MASTER_GL_ACCOUNT_TYPE WHERE gl_account_type_sys_id = gl.gl_account_type_sys_id) gl_account, license_display_sys_id, guarantee_sys_id, invoice_item_sys_id, erp_gl_transaction_id, TO_CHAR (gl_posting_date_submitted,'YY-MM-DD') gl_posting_date_submitted, TO_CHAR (gl_posting_date_actual,'YY-MM-DD') gl_posting_date_actual, gl_txn_je_segment_1, gl_txn_je_segment_2, gl_txn_je_segment_3, gl_txn_je_segment_4, gl_txn_je_segment_5, gl_txn_je_segment_6, gl_txn_je_segment_7, gl_txn_je_segment_8, gl_txn_je_segment_9, gl_txn_je_segment_10, gl_status_sys_id, TO_CHAR (gl.created_date,'YYYY-MM-DD') created_date, gl_transaction_batch_sys_id, license_perf_fee_sys_id, deal_sys_id, gl_transaction_set, master_entity_sys_id, exchange_rate_sys_id, rd_exchange_rate, credit_amount_corporate, debit_amount_corporate, accounting_media_sys_id, (SELECT MEDIA_NAME FROM MASTER_MEDIA WHERE master_media_sys_id = gl.accounting_media_sys_id) acct_media_name, gl.master_currency_sys_id, mc.CURRENCY_ABBREVIATION MASTER_CURRENCY_VALUE , mfs.description SL_VJC_Corp_ID, mfs.description SL_VLJ_Corp_ID, (SELECT LEDGER_TYPE FROM MASTER_LEDGER_TYPE WHERE LEDGER_TYPE_SYS_ID = (SELECT LEDGER_TYPE_SYS_ID FROM MASTER_GL_ACCOUNT_TYPE WHERE GL_ACCOUNT_TYPE_SYS_ID = (SELECT GL_ACCOUNT_TYPE_SYS_ID FROM GL_TRANSACTION WHERE GL_TRANSACTION_SYS_ID = gl.GL_TRANSACTION_SYS_ID))) LEDGER_TYPE , je_matrix_sys_id, auto_reverse_ind, licensee, gl.fis_gl_journal_sys_id, customer_vendor_number, (SELECT description FROM MASTER_FIS_BATCH_STATUS WHERE fis_batch_status_sys_id = gl.fis_batch_status_sys_id) gl_batch_status FROM GL_TRANSACTION gl , MASTER_CURRENCY mc, master_fis_corporate mfs, fis_gl_journal fgj WHERE gl.master_currency_sys_id = mc.master_currency_sys_id(+) AND gl.FIS_GL_JOURNAL_SYS_ID = fgj.fis_gl_journal_sys_id (+) AND fgj.rd_fis_corporate_sys_id = mfs.fis_corporate_sys_id (+) AND gl.fis_gl_journal_sys_id = 5141 : java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

11/21/2013 17:35:26 - ERROR - com.sophoi.ipls2.common.exception.IPLSExceptionUtil - rootException java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

11/21/2013 17:35:26 - DEBUG - com.sophoi.ipls2.cash.ejb.session.GLBatchProcessServiceBean - updateSQLQuery Status to P: stauts UPDATE IHUBOBQ_GL SET IHUB_PROCESSED_FLAG = 'P' WHERE IHUBOBQ_GL_SYS_ID IN (565 )
11/21/2013 17:35:31 - DEBUG - com.sophoi.ipls2.hub.ejb.session.HubServiceBean - GLBatchMessageValue = BatchExecute

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms