Book27.xlsx

Karthikeyan

VeronicaN-Oracle

Hi,

In order to have the Reconciliation reference populated you need to create a custom SLA , the steps are in note What are the Setup Steps to Enable GL Reconciliation from Subledgers in R12? (Doc ID 431504.1)

From your screenshot it is not seen that the specific line found in Reconcile journal lines has the same Line type as APL_Accrual, also you need to make sure the reconciliation reference is filled in AP as well.

So further check the following:

1. the line type is the same as the journal line type set with Attribute "Reconciliation reference"

2. check if the lie has Reconciliation reference filled in AP.

Regards,Veronica

Karthikeyan

Hi,

In order to have the Reconciliation reference populated you need to create a custom SLA , the steps are in note What are the Setup Steps to Enable GL Reconciliation from Subledgers in R12? (Doc ID 431504.1)

From your screenshot it is not seen that the specific line found in Reconcile journal lines has the same Line type as APL_Accrual, also you need to make sure the reconciliation reference is filled in AP as well.

So further check the following:

1. the line type is the same as the journal line type set with Attribute "Reconciliation reference"

2. check if the lie has Reconciliation reference filled in AP.

Regards,Veronica

Hi VeronicaN

Thanks for your immediate response  i have done SLA Customization setup with reference of the Doc ID 431504.1

even though i am getting trouble

Regards

VeronicaN-Oracle

Hi VeronicaN

Thanks for your immediate response  i have done SLA Customization setup with reference of the Doc ID 431504.1

even though i am getting trouble

Regards

Have you checked the points from my previous reply?

1. the line type of the specific transaction is the same as the journal line type set with Attribute "Reconciliation reference"

2. check if the line has Reconciliation reference filled in AP.

Regards,

Veronica

Karthikeyan

HI VeronicaN

I think the reference details populated in GL_JE_LINES_RECON

Where i can see the reconcilation reference details in AP pls proivde table name with reference column to verify

Thanks

VeronicaN-Oracle

Hi,

I see that the source is Invoice Number for the reconciliation reference, the field is not populated in xla tables from my research done.

It is populated at the time of transfer in gl_interface table.

I recommend that you raise an SR , for Oracle Support to look into your custom SLA setup and check what is missing.

Regards,

Veronica