ERPstuff - Oracle EBS Community

Keep up the good job include me also in any doc for R12

Thanks so much ramkic its sgeeta21@gmail.com
[quote]Hi,
I will be working on the script. Can you please send me your email id, so that I can send it. Once you have tested that, we can request "Admin" to upload the same for future use.
Thanks
ramkic

<i><div align="right">Originally posted by ramkic

Hi eshta

I was also looking for this solution report if you find some info can you please pass it to me. like items recieved qty date who prepared ordered.
Thanks

Hi Ramkic

do you have any sample code to do that we are on 8.0.1 does that have smtp mail please advice

we are on 11.5.7 and database 8.1.0 thx
[quote]Hi,
One way you can achieve this by having an update trigger on Payment Terms on po_vendor_sites_all table and call utl_smtp protocol to send email notifications to responsible persons.
Regards
ramkic

<i><div align="right">Originally posted by ramkic

Hi,
I want the alert email when some one only updates the terms like eg net 30 to net 20. Now if I update any thing it sends an email I dont want that any advice.

EVENT ALERT TABLE NAME: PO_VENDOR_SITES_ALL
SELECT
PV.SEGMENT1,
PV.VENDOR_NAME,
PV.LAST_UPDATE_DATE,
AA.NAME,
U.DESCRIPTION
INTO
&VNUM ...

Hi Naumaan,

I think its easy with Oracle Alert I know one is the rcv_transactions table
any idea about other tables and the query in Alert.

Thanks

I was told this can be done by Oracle Alert has any one done any idea.

Hi Siva,

Can you guide how to do this. yes you are right both requester & preparer are emp. As of now we have workflow that emails them that there req has been approved and po had been approved.
Thanks

Can this be done by trigger or worflow or both any advice.

We are on 11.5.7 we have PO Requisition Approval & PO Approval workflow. Can we have a workflow that sends notification when an item is received to the requester and preparer? Any advice please

Thanks

So how and when does it gets to gl_interface with MTL Inventory
Thanks

Hi guys,

Can some one please explain how MTL Inventory gets to Gl_INTERFACE from Inventory? Do they come when you run the gl transfer or when you close the period.
And what kind of items are they. And what is this group id how is this generated.

Thanks

Thanks so much I sitll want to figure out how to create the EMP_NAME DFF.
I tried that and attached the value set I am getting error.
I selected the table PER_ALL_PPEOPLE_F
value I selected employee_name
and under ID I selected employee_number
under where/order by (employee_number in ('1150','1158 ...

Ok, the issue is some one from HR EMP A ordered business card.
Some one from IT EMP B ordered Cisco router.
Some one from Field Engineering EMP C ordered Phones.
So AP while creating and Invoice need 3 DFF one when they entered the invoice
Second the name of the EMP who ordered and third the date ...