ERPstuff - Oracle EBS Community

Hi all,

I am facing one situation regarding PL/SQL

I an fetching two dates in a cursor like

cursor c1 is select iess.eventdate,
ss.insert_date,
s.shipment_gid
from ie_shipmentstatus,
status_history
shipment s
where iess.i_transaction_no = ss.trancastion.no
s.shipment_gid = ss.shipment_gid ...

Hi,

select distinct RTRIM(SUBSTR(to_char(start_time,'dd-month-yyyy'),4),'-2007') a FROM SHIPMENT order by a

The output is coming like
april
august
december
febrauary
january

How to get that in Sequence like
january
febrauary
march
april

Regards
Sateesh

Hi,

In my view When u Uninstall Client and Developer the above mentioned error should not Repeat. how it is coming ? may be it's a miracle

My suggestion is:

Once again u try to uninstall both oracle client as well as Developer
and also delete the instance of ORACLE in REGEDIT

And then Install ...

I think INITCAP function(which is supplied by ORACLE) is the best way that U can proceed with

Ex:Select Initcap('sateesh') from dual; will giv the Result as follows

Result :Sateesh

Satti

I am importing Invoice from legaccy system thru ap_invoices_interface and ap_invoice_lines_interface

the data is importing properly into the ap_invoices_all and ap_invoice_distribtions_all,but my current requirement is the impoted invoice should be validated and accounted automatically,which ...

Hi all,

I got a requirement such that

i need to dispaly the customer part no based on the invoice number in Report

can u please tell me the table to link customer_part_no with invoice num in AR

Please do the needful

Satti

Hi all,

When i am creating Invoice the functional currency is defaulting to USD
i need it to change to INR?how can i proceed

the navigation Path is as follows

Payables Responsibility->Invoices->entry->invoices

Please help me.

Satti

Hi All,

GL_ACCOUNT is not populating Automatically on the Expense Report Window (lines Section)based on the item and template selected.

The navigation path is as follows

invoices->Entry->Expense Reports


Satti

Hi,

I got One Requirement to attach 20 attributes in a descriptive flexfield, is it possible to attach 20 fields to a descriptive flexfields?

If it is possible, Please specify how?

Satti

hi,

At max how many attributes we can attach in a descriptive flexfields?

Can we attach 20 attributes for Descriptive Flexfield?



Satti