Search results for query: *

Dose anyone have experience with account generator (Fixed Assets module )? It is modified through workflow builder and this is the tool that I am having problem with ... no much of a tool but description of the existing processes - - what are they responsible for ... Is there any links to...

Craig, if you use date format the way you do you rely on the format provided by a session at a particular login. But, if you use to_date()date will not have any chances to error out!

you can also try somesing like Insert into ESP_MET_DATA VALUES ( 1165, to_date(' 1/1/2001', 'mm/dd/YYYY'), to_date(' 2/1/2001', 'mm/dd/YYYY'), 1, LTRIM(RTRIM(' Greenville-S'||chr(39)||'burg, South...

just a small note instead of "TO_DATE('09-jul-2003','DD/MM/YYYY')" do "TO_DATE('09/07/2003','DD/MM/YYYY')" - slashes and month format will error out ....

Bingo thank you very much! It has been killing me for the past two days! I will though need to rewrite the quiery, because I need to eliminate the "Y" inactive flag. I hope writing a query in the "FROM" section and puting a where clause on top of it will do ....

I have this query and for some reason it does not return the same number of rows as before it was joined with table "migr.legacy". It is a mapping to the lagacy dept. And ceratain combinations are not mapped - specifically "AND L_MAP.oracle_business_segment(+) =...

Hi, all! We use Oracle ERP 11i and recently started using Discoverer within Portal. There are number of reports that werre written for the db user login,but we want to roll it out to the apps users. For thuis we set up an apps login EUL, which works fine up to the login part! Users can log...

Hi all, we have Oracle ERP 11i and recently strared using Discoverer to create some ad-hoc reports. We created Apps login EUL and I migrated report which was run with db user access to this EUL. To test it i ran it with user who does not have access to a certain region for this region. Report...

I had a problem with 9 developer suit. There is anew installer/patch you can downoload from metalink. If you install it and youse it install other prducts it wrks fine..

It is CBO and tables where analyzed 3 days ago...

Ladies and Gents, Can yopu explain me why a quirey would invoke one index instead of another ... I am joining a big table mill of records and small table 4K they both have indexes both of them are being invoked , but I want to invoke the big table index first ... and then "map&quot...

- business group ... gotta look up this .. - legal entity : segment that you define as balacing, e.g. all entries have to net to "0" for it. If you have a BS it will be it! - as many as you want ... - Waht is the purpose? You can convert mutiple curencies to the functional...

Hi, All! I have a weired problem! I registered a report in Discoverer under a common user/schema that we use, but it gives an error when other people try to run it using the same Id. I checked it is the same instance, business are is visible from other computers but "join" is not...

I have heared from several sources that Oraxcle marketing sucks! Every presentation that I have heared of is the worst among other competitors. I have not had a chance to work with supply functionality, but a friend of mine in Deloitte is quite impressed... (So much for an oppinion)

Bingo!!! Thank you!!! Also, I see that this table contains multiple lines based on the same id but for different languages ... Do you know why? It does not make sence for me since I see only one (US) entry from front end.

Thanks, for the reply... This table(FND_FLEX_VALUES) was my first on "assumptions list", but heare is a describe on the above table in my enviroment: SQL> desc FND_FLEX_VALUES Name Null? Type ------------------------------- -------- ----...

Let me re-frase... I can join gl_code_combinations with gl_balances to get an appropriate result, but I also need to list the description of an account e.g. for inctance I will select segment1, segment2, segment3 (segment2 in my case is an account ) I also need description of segment2 like...

Hi, I just recently started to work with Oracle Fin. (a common start of a sentence). So far a I can write some selects mainly on Gl_balances, gl_je_lines , gl_CCid and etc. Which I found in tech reference , but I can not figure out how can I pull FlexField value description, e.g. I selected...