ERPstuff - Oracle EBS Community

Hi,

1.In which table, we will capture the PO_NUMBER in Payables moudle
(AP).

2. How to identify the payment is done or not(front end) for po_NUMBER in Purchasing module

Regards,

Yknev

Hi Karthik,

Thanks for prompt response. Can you clarify below point:-

I have created the asset in JAN-2010 from payables. But DEPRN_SOURCE_CODE column showing 'B' (present month JUL). what is the reason for that.

If possible, can you explain with small example.

Regards,

yknev,

Hi,

What is the meaning, if DEPRN_SOURCE_CODE column is 'B' (book) in FA_DEPRN_DETAIL. In which scenario this B will populate.

Regards,

Yknev

Hi All,

How to calculate the NBV_RETIRED column in FA_RETIREMENTS table.

Is possible to see this value in Front End without using reports.

Regards,

Yknev.

Hello Karthikeyan,

Thanks for your Information. Could you expalain, how to setup the Skelton Distribution set. Is it same as Full distribution set or any special rules for Sketlon Distribution set.

If possible, please provide the document or link.

Regards,

Yknev.

Hi All,


1. What si the difference between Full Distribution Set and Skelton Distribution Set in Payables module.

2. What is the difference between TRANSFER IN & TRASFER OUT in FA_TRANSACTION_HEADER table.

Regards,

Yknev

Hello Karithkeyan,

How to identify the Feeder system assets in Asset work bench. After transfering from FA_MASS_ADDITION table.

Without comparing to FA_MASS_ADDITION table. because this table is interface table.

Regards,

yknev.

Hi Amit,

I have 3 slabs. could you explain.

In this scenario, how to define this Slabs. Please clarify.

Regards,

Yknev

Hello oteixeira,

How to identify the control Accounts and Natural Accounts. Can you elaborate more.

Regards,
yknev

Dear All,

I am new for Oracle Apps. Could you clarify below points:-

1. What is the control Accounts & Natural Accounts

2. What is the difference between Natural Accounts & Control Accounts.

Regards,

yknev.

Hi Ninok,

Can u suggest, how to load supplier in payables - 11.5.10.2

Thanks in advance

Dear Amirtai,

I print the sum of salary at the last row. But my query takes a long time. Can u give me any suggestion regarding, how to reduce the execution time.(In my scenario more than 3000 rows selected)

Dear Amirtai, Thanks for prompt response. But, In my scenario <b>query takes a long time for execution</b>. Please let me know, how can reduce the execution time. And also i want to present a number data type instead of varchar type at the bottom of result row. I mentioned one example below select e...

Dear Amirtai,

I will agree with u. but in my scenario more than 15 columns are present including date columns. So that i want to display sum of amount at the last row without using GROUP BY clause.

Dear Amirtai, Thanks for given idea. But, in my query date column is present at this scenario how to write a query. Kindly suggest to me. For more clarification i mentioned one simple query in below. select ename,sal,job,hiredate from emp union select 'Total',sum(sal),'', <font color="red"...