1 person found this helpful
Frist of all, check is there any data you want in gl_interface, if any, is the LEDGER_ID column null or not?
This is the Standard Functionality. If data is there for Purchsing definately will come Ledger_id in LOV.
If data is not availble in GL_INTERFACE for Purchasing, it's won't show Ledger_id in Lov.
in GL_INTERFACE for every line ledger_id will come, wihtout ledger id there won't any line in gl_inetrface.
if your issues is resolved, kindly check the correct answers/helpful answers. so that others will not follow up this issue.
Thanks for the helpful pointers.
In addition what I found out is that value Set being used for the 'Ledger' parameter is GL_SRS_JOURNAL_IMPORT_LEDGERS is based on the view gl_srs_ji_ledgers_v, which looks for records available in the GL_INTERFACE table for the given source. When there is no record available, then it is expected that this fail with message 'No entries found for List of Values'
In my case, the query " select * from gl_srs_ji_ledgers_v where je_source_name = 'Purchasing';" gives outputs which has no ledgers for the responsibility i am working with.
I have understood the reason for the problem but could someone help me remedy for this situation? What can I do to get a value in the dropdown for ledgers? Since I am in a functional role, can this be done from a functional perspective or is this an issue for the technical team?
Sorry for the bother but I am a newbie to Oracle apps.
Thanks in advance
could you pls provide output for this query.
distinct USER_JE_SOURCE_NAME,USER_JE_CATEGORY_NAME from gl_interface
USER_JE_SOURCE_NAME > USER_JE_CATEGORY_NAME
Inventory > WIP
Statistical > Accrual
Statistical > Addition
Inventory > MTL
Inventário > MTL
Manual Upload > Standard
Einkauf > Wareneingang
Spreadsheet > Accrual
Compra > Recebimento
Recebimento Integrado > REC
采购 > 接收
Purchasing > Receiving
CLL F189 INTEGRATED RCV > REC
could you pls try to import other than Purchasing transactions?
For otherv sources also, there is no value in LoV. The only time there is value in LoV is for another GL responsibility.
These respnsibilities which have value in LoV can be seen by running the query " select * from gl_srs_ji_ledgers_v where je_source_name = 'Purchasing'; ".
till now you are not using gl super user responsibility?
as per my assumption you have create one custom gl responsibility from there you are trying to import? is it right?
Yes we had to create seperate GL responsibilities for different locations. This one is for Ashtech.
The LoVs are coming for Europe and China which are returned as the output of query " select * from gl_srs_ji_ledgers_v where je_source_name = 'Purchasing';"
Have you attached Profile Options to that New GL Responsibility?
GL Ledger Name
1 person found this helpful
Usually if you have any lines related to you Ledger id in GL_Interface, you can able to import.
Now i have one question
1) have you done create accounting for purchasing ? if done from where you have ran create accounting?