Skip to Main Content

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!

Debit-Credit in Import Script

User_3JG8TFeb 10 2017 — edited Feb 10 2017

Hi everyone,

I am using FDMEE and would like to create an import script for column debit-credit(2 seperate columns in the CSV files) and put this script in AMOUNT dimension in the Import Fomat

Anyone has sample of this script? I was looking into Administrator guide but did not see any sample for it.

And I have checked in this forum: FDMEE Amount Mapping to (Ending - Beginning)?  --- I would not use this solution because there are hundreds account mapping so writing SQL script to each account mapping is not a nice solution....

Thx.

Comments

fac586

Richard Legge wrote:

Hi all, this mornings question.. please let it be a nice simple answer...

Im using APEX 4.2, and have switch to theme 15. simple blue.

Ive got a menu list on the left hand side. so it needs to sit in region 2. its designated as a sidebar region.   I'm trying to use the sidebar template so that I get a menu header and a border... However region 2 on this theme has a blue background... and also has a header and footer area / image.

So my sidebar region looks odd inside it.

From my research, I should be able to override the region template to remove this header / footer / background colour and associated attributes, leaving me with a nice sidebar menu... Ive don lots of research, and think I should be referencing the region class in the definition of my menu??? but dont seem to be able to get it right..

Please could somebody help

Somebody would be able to help more quickly and effectively if they had an example on apex.oracle.com to refer to...

However, if you're using 4.2 and not supporting legacy (IE6/7) browsers I would recommend not using theme 15, nor any of the other legacy quirks mode themes (marked with a "*"). You'll find it much easier to work with—and get support for—the more modern standards-based themes.

Richard Legge

Have I missed something then, as Ive only got two standard themes.. 23 (uniframe) and 26 (productivity Apps).. It doesn't give me much to work with... are there others available?

Thanks

Richard

fac586

Richard Legge wrote:

Have I missed something then, as Ive only got two standard themes.. 23 (uniframe) and 26 (productivity Apps).. It doesn't give me much to work with... are there others available?

You must have some of the "Standard" themes already installed in the app.

When you go through the Create Theme wizard, on the Identify Theme page, select All Themes from the Theme Type select list, and use any of them except those marked with a "*": 8, 10, 11, 13 (which is not marked but should be), 14, 15, 16, 18, 19, and 20.

All of the other themes (regardless of their 4.2 labelling as "Standard" or "Legacy") contain a DOCTYPE declaration that will trigger standards mode in browsers.

Richard Legge

ahh.  Thanks. Yes, forgot that if Id already imported them, they dont show up on the list.. many thanks

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 10 2017
Added on Feb 10 2017
3 comments
582 views