ERPstuff - Oracle EBS Community

Hi, You check the same by below queries select to_char(inst_id) rac_inst_id, to_char(sid) sid, to_char(serial#) serial#, sql_text from apps.fnd_concurrent_requests fcr, gv$session vs, v$sqltext vq where vs.process = fcr.os_process_id and vs.sql_address = vq.address and fcr.status_code = 'R' and fcr....

Hi, We are facing below issue in Payables and CM Module. 1 Payments are made Void but they are shown reconciled against bank statement lines. 2 Payments are reconciled but are Shown negotiable. 3 Payments are not reconciled as well as they are made Void but are shown reconciled against some bank sta...

Hi,

Yes the payable accounting process program has gone in err. How do i resolve the same related to particualar invoice or payment.

Also the status of the payment is shown as Cleared but Unaccounted.

Regards

sagi

Hi,

We are facing issue of some invoice which are applied with prepayment invoice & the payment entry of prepayment invoice is showing selected status instead of accounted.

we would like know the process which is effective the same and resolution of the same.

Regards

Sagi

Hi,

I have created Receipt Inteface via Receipt API. I have created Create , Apply , Unapply and Reversal procedure for same.

We have now new requirement for creating receipt for an account.

May i request, Kindly forward a process flow/Code or document of the same.

Regards

Hemant

Hi,

Can anyone provide link to download Oracle DB 8.1.7.4 for HP-UX 32 bit.

Regards

sagi

Hi, Payment is made against the prepayment whereas the status of prepayment is accounted but Payment entry is not accounted & shows the accounted status as ?SELECTED?. The payment status of the same is showing ?Reconciled Unaccounted?. Which means the payment entry was reconciled when the status...

Hi,

Can we create multiple catalogs for instance located on different operating system.

Regards

Sagi

Hi,

I want to have Customer and Invoice API script. Would like if anyone share Document/Scripts of same.

Thanks in advance.

Regards

Sagi

Hi, I am trying to trap duplicate records before inserting in the stagging table. But not able to do so. The data is transfered from MS-SQL Server in DTS format in oracle stagging table. But duplicate data is also imported. Can any one help with the before insert table. i am usg DB 8.1.7 Regards sagi

Hi,

Need to design flow for receipt interface. kindly let me know which are the interface tables for same, data & table structure reqd from legacy system and validate the same before importing to oracle.

Regards

Sagi

Hi,

We are in process of implementing isupport and Knowledge base for internal support. Can anyone provide functional document's and implementation manual for same.

thanks in advance.

Regards

Hemant

Hi, we are having 11.5.8 version. we want to upgrade to 11.5.10.2 , so we started first cloning on standby server. Steps i followed 1] copied all tops to standby server. 2] rename the folder name from prod to uat 3] changed permission to testdb user. 4] ran perl adcfgclone.pl dbTier recd the error ....

While cloning db tier recd err below .. RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:658) at oracle.apps.ad.clone.ApplyDa...

Hi,

Need help for creation of customer interface . want to know the base table for data transfer form Mssql.

regds

hemant