Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to load data using Load rule from Oracle database

3979789Aug 19 2019 — edited Aug 19 2019

Hi Team,

We are trying to load data through load rule directly from Oracle database (EBS) but facing some issues. Created load rule and inserted the SQL statement and trying to Retrieve but facing the below issue

Sql error.PNG

The log says as below

OR (ledger_id = 647 AND currency_Mon~Aug~19~01:35:18~2019~~4788~Info~(1021043)~Connection has been established

Mon~Aug~19~01:35:18~2019~Local~~4788~Info~(1021044)~Starting to execute query

Mon~Aug~19~01:35:18~2019~Local~~4788~Info~(1021013)~ODBC Layer Error: ~[S1000]~ ==> ~[[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00936: missing expression]

Mon~Aug~19~01:35:18~2019~Local~~4788~Info~(1021014)~ODBC Layer Error: Native Error code ~[936]

Mon~Aug~19~01:35:18~2019~Local~~4788~Error~(1021106)~Failed to Execute SQL Statement. See log for more information

Mon~Aug~19~01:35:18~2019~Local~~4788~Warning~(1080014)~Transaction ~[ 0x790008( 0x5d5a3516.0xbcf70 ) ]~ aborted due to status ~[1021106]~.

COuld you please help me on this? Thanks!

This post has been answered by JohnGoodwin on Aug 19 2019

Jump to Answer

Added on Aug 19 2019

#business-intelligence-applications, #epm-system-infrastructure, #performance-management-applications

3 comments

468 views