I am trying to run Import Journals in a GL responsibility:
GL Superuser > > Journal > Import > Run.
The Source is Purchasing.
However when I try to select the Ledger name from the LoV, there are no values.
Whats the solution to this?
One of my collegues said it might be a data access set issue and that I might have to set profile options.
Thanks in advance
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
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
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'; ".
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';"