ERPstuff - Oracle EBS Community

I have created a PO with 6 lines. I have ammended the PO also. But the problem is I can see the PO lines in PO Summary but when I am opening the original PO I can see only one line. None of the lines of the PO has been cancelled. What might be the problem ! Pls. help me to solve this problem. Thanks...

No diagnostic script is available for AR. Pls. advise. I have been facing problem in AR while closing the period.

Thanks.

amitava

In our case we do not have diagnostic tool is installed so we cannot run the diagnostic tool .

Can anyone pls. provide me the Period closing diagnostic script !

Thanks in advance.

Amitava

While closing the Period for AR for the month of August,2009 we are getting the following messages. APP-AR-11332 You must post all transactions in this period before you close it. We had run Unposted Item Report before closing the period and found that nothing is there unposted. Cannot understand th...

I would like to know how to create Flecfields(Key Flexfields & Descriptive Flexfields).

Can any one help me in this regard with screen shot and navigation path ?


Thanks in advance.

Amitava

Hi Krishna, Actually my objective is to make some changes in the NBV and Accumulated Depreciation on an Asset in WDV method. Our Financial year is Apr-Mar.Suppose on 1st April, 2009 , the NBV of an asset is Rs.5000.00.For this asset depreciation will be calculated on WDV method.I want to change the ...

NBV can be changed thru Unplanned Depreciation. e.g. the current NBV is Rs. 10000.00 and you want to make it 9500.00. So thru unplanned depreciation if you charge 500 as depreciation amount then the NBV will be changed to 9500 and at the same time Accumulated Depreciation will also be changed by 500...

Our objective is to change the net book value and accumulated depreciation of the asset thru unplanned depreciation and the system should consider the changed NBV while calculating the depreciation in WDV method. We changed the NBV of the asset in the month of April,2009 thru unplanned depreciation....

I want to generate a report where I will show the original price and quantity of an item in a PO. In our case when a PO item is ammended it always shows the current price and qty with a revision number like 1,2,3 etc. How to get the the original price and quantity after PO is ammendmend. Pls. provid...

Hi,

I am new to Oracle ERP.

How can I get the different table structures for each module and and the links between the tables.

Thanks in advance.

Amitava

I am new to Oracle Purchase.

I want to generate a Supplier List with the following details.

Supplier Code
Supplier Name
Supplier Address
PAN
Status
TDS Section

I need the SQL for the same.

Thanks in advance.

Amitava

I want to generate Location wise Asset List. I need to know the SQL for that.

My requirement is

1. Asset No.
2.Description.
3.DPIS.
4.Location Details.

Thanks is advance.

Thanks.

Amitava

I am new to oracle assets.

I would like to know if this is possible to change the original cost and the accumulated deoreciation of an asset after running depreciation for few months.

Thanks in advance.

Amitava

I am new to ERP. I want to create a Value Set in FA where Asset Numbers will be shown in the List Of Values and also the Asset Numbers will be shown sequentially.I want to use the table FA_ADDITIONS where Asst Number field type is Character. Want to make this Character field to numaric. Can anybody ...

I Would like to know about UTL_FILE.

How to use UTL_FILE to export data from oracle to OS File.

Would like to know the syntax.

Thanks.

Amitava