rajavu
Forum Guru

Hi Raj,
Good morning.........well again i am back here to discuss some thing about GTT..

Hi... i need end user functional issues & solutions during the supporting project of oracle apps financials modules, plzzzzz help me, my mail-id: nanda.bollineni@gmail.com

Thanks.

Hi Raj......

Hi Raja sir, I need sql query for payment-invoice details ( Supplier Name, No., Invoice no., Invoice Date, Amount, Payment Amount, Payment Document No., Bank Account, Org ID, Segment1, payment voucher no., Payment date) Please help me out in this regard..

sir ,
plz tell me how to get oracle9i forms and reports software .i searched that in so many places but didnt got yet could u help me in that

Dear Raju ! I new in oracle ERP inventory module. i dont know how to update physical count data upload in to the oracle 11.5.10.2 database. can u please help me. and forward any document my mail id rtlakshmanan@gmail.com. am waiting for your favourable replay advance thanks.

regards,
lakshmanan T

Dear sir,
Kindly help me to resolve this problem
Consider the following table

NOTE:Table ITEM is Master table and Table order_item is child table

Table ITEM
item_id unitprice
0 0
200 400
201 1000
202 100
203 600
10 500


Table order_item
Order_id item_id qty
101 201 5
101 202 4
101 203 6
102 204 7
102 201 1
102 10 3

Now how we can delete item_id 10 from the ITEM table and make the corresponding field null in the ORDER_ITEM table.is it possible?

Please suggest me

Sir,

I have facing problem in Oracle FOrms. If, I enter the password and the main menu is not working properly. The following errors are display.

Code:
Error : -942 ORA-00942 table or view does not exist.

: FRM-40735 Pre-Insert trigger raised unhandled exception ORA-00942.Please tell us how to solve the problem. Because I don't know Pl/SQL.

Please help us


thanking u

anand

testing.........................

HI All


Raj.