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!

PBCS - Data Management - NetSuite Error

elwayisgodNov 9 2018 — edited Dec 7 2018

Hi Experts,

Oracle support is of zero help thus taking a shot here.

We are trying to make a connection to NetSuite using the built in adapter.

We have created a successful source connection and it validates.

We created our Import Format

We created our Target app

We created our Location

We created Explicit Period mapping to handle the 'Oct 2018' format for NetSuite

We create our Data Load Rule

However when we run our Location in Data Load Workbench, we get no rows returned.

The attached Vision_518.log file is the from Process Details. Line 38 fails. We can't figure out what this error is. The NetSuite user we use is able to run the saved search when we log into NetSuite.

I also attached the ODI log.

We are perplexed as not sure why we can't bring in rows of data from our saved search.

Thanks for any help!!!

Added on Nov 9 2018

#business-intelligence-applications, #fdmee, #pbcs, #performance-management-applications, #planning-and-budgeting

7 comments

1,280 views