Skip to Main Content
Forums

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!

IGNORE IN LIKE MAPPING NOT WORKING

User_N9Z3IJul 31 2017 — edited Jul 31 2017

Hi All,

We have a requirement to ignore all the balance sheet accounts when we load actual from Financial cloud to PBCS, I created a like mapping to IGNORE all the accounts starting with 4. But the mapping is not working. Below is the mapping screen shot and the workbench screen shot which is not mapping the accounts starting with 4 to IGNORE.

pastedImage_1.png

pastedImage_0.png

When I do an explicit mapping with full account number its is working fine. But, if I use in like mapping 4* or 4???? its not working.

Can any one please help me in fixing it.

Thanks

Sri
This post has been answered by JohnGoodwin on Jul 31 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2017
Added on Jul 31 2017
#business-intelligence-applications, #financial-data-management, #performance-management-applications
6 comments
584 views