Search found 170 matches

by lukman
Mon Aug 06, 2007 11:07 pm
Forum: Reports (Only Oracle Apps Reports)
Topic: Error running reports
Replies: 8
Views: 6882

Hello, After learn how to create report using TOAD and Oracle Reports Developer 6i I built my own sales order testing report and read the documentation of how to register report and printer. Oracle E-Biz : 11.5.10.2 OS : Red Hat Linux Advanced Server 4 update 3 Printer : Epson LQ2170 Output format :...
by lukman
Wed Aug 01, 2007 4:33 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Registering reports
Replies: 7
Views: 3018

I already downloaded and read v.2.5 but still couldn't find the answer I was looking for. thx.
by lukman
Wed Aug 01, 2007 4:04 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Registering reports
Replies: 7
Views: 3018

I already looked in Administration 11i v.2.2 file, in what page is the information cause I'm still confuse? If I login using System Administrator's responbility, navigate to Application - Register, search general ledger then I'll get GL_TOP. After that, I go to /visappl and execute APPSORA.env to fi...
by lukman
Wed Aug 01, 2007 3:23 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Registering reports
Replies: 7
Views: 3018

hello,

can someone give me link or information in which folder must I put my custom reports for each module, e.g.:

for Oracle E-Business Suite 11.5.10.2
gl reports is in /visappl/gl/11.5.10/reports/US

etc.

I want to test my custom reports but I don't know the folder location of the module :P. thx.
by lukman
Wed Jul 25, 2007 12:47 am
Forum: Operating System
Topic: Help - TNS: packet reader failure
Replies: 1
Views: 3016

Help - TNS: packet reader failure

Hope I didn't put this in the wrong forum. I'm having trouble with my TOAD. I'm trying to access my oracle E-business suite database which located in Server A and Server B. I could connect to Server A but couldn't to Server B. Every time I tried to connect to Server B I always get this error message...
by lukman
Thu Jul 19, 2007 11:38 pm
Forum: Reports (Only Oracle Apps Reports)
Topic: Help to build query for Order Management
Replies: 4
Views: 3604

Hi all I have another questions about order management report. I tried to create a report for warehouse people to pick items. Using inventory responsibility, navigate to move orders - transact move orders and select pick number. I can create the report successfully if the item doesn't have lot/seria...
by lukman
Mon Jul 09, 2007 1:58 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Help to build query for Order Management
Replies: 4
Views: 3604

Hi all, I managed to solve my problem. Here's the query in case someone need it. Thanks SELECT party.party_name "Send to" (SELECT party.party_name FROM hz_cust_site_uses_all bill_su, hz_cust_acct_sites_all bill_cas, hz_party_sites bill_ps, hz_locations bill_loc, hz_parties party, oe_order_...
by lukman
Fri Jul 06, 2007 5:42 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Help to build query for Order Management
Replies: 4
Views: 3604

sorry, I don't understand. can you give me an example?
by lukman
Wed Jul 04, 2007 3:25 am
Forum: Application DBA & System Administration
Topic: Help me to install & uninstall Oracle ADI
Replies: 17
Views: 9707

Hi, it's almost 2 months since I raised this topic and now I got another problem with ADI :P but first let me reply to amirtai. Unfortunately, I already tried to copy TNSNAMES.ora from other client machine connected to the same DB server but still not worked and what do I search in TNS_ADMIN and $OR...
by lukman
Wed Jul 04, 2007 2:52 am
Forum: Application DBA & System Administration
Topic: Help me to install & uninstall Oracle ADI
Replies: 17
Views: 9707

Hi, it's almost 2 months since I raised this topic and now I got another problem with ADI :P but first let me reply to amirtai. Unfortunately, I already tried to copy TNSNAMES.ora from other client machine connected to the same DB server but still not worked and what do I search in TNS_ADMIN and $OR...
by lukman
Tue Jul 03, 2007 3:24 am
Forum: Application DBA & System Administration
Topic: cannot bind to OAD
Replies: 0
Views: 1056

cannot bind to OAD

Hello all, I got problem when I tried to start my oracle E-Biz 11i and got error "Cannot bind to OAD'. The problem occured after I restarted my machine and tried to start Oracle E-Biz. Already read some articles in metalink and it said that got something to do with LD_ASSUME_KERNEL. I didn't do...
by lukman
Mon Jul 02, 2007 8:27 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Help to build query for Order Management
Replies: 4
Views: 3604

Help to build query for Order Management

I'm trying to build a report for order management module. I could get the customer's name for ship to and bill to field if those 2 fields, whether the numbers are same or not, if the customer are the same. For example : Customer A (which had 2 sites, site 1 and site 2) bought an item and he/she want...
by lukman
Thu Jun 21, 2007 11:30 pm
Forum: Application DBA & System Administration
Topic: R12:- UNABLE TO LOG ON TO APPLICATIONS AFTER CHANG
Replies: 1
Views: 2158

I use FNDCPASS to change apps password and it worked fine. Don't know whether it can be done in R12 but you might want to try what I did in topic.asp?TOPIC_ID=1327
by lukman
Wed Jun 20, 2007 5:38 am
Forum: Application DBA & System Administration
Topic: How to check tables of each screen?
Replies: 19
Views: 5046

hi, using the script I got here I tried to find the owner of mtl_parameters. I found that the owner is apps but when I looked in schema browser with TOAD there's no mtl_parameters (though there are some views started with mtl_parameters). When I saw the script in mtl_parameters_view it referred to m...
by lukman
Mon Jun 18, 2007 6:58 am
Forum: Application DBA & System Administration
Topic: How to check tables of each screen?
Replies: 19
Views: 5046

Thanks for the script, it really helps.