วีดีโอ

Hi, Thanks for watching my channel. i will add in my note to record the video on requested topic.

Hi, Thanks for watching my channel. session is recorded for Value set setup and the use, for the DFF it will be separate video will be recorded that how to link value set to DFF.

Hi, Thanks for watching my channel, supplier workflow is provided in Oracle version 12.2.5 and its later version, through AME you can approve supplier registration. before that version no you can't do. if you want to apply supplier approval before 12.2.5 version. in that case you have to design custom solution to complete the requirement.

Thank you Venkatesh, i hope you learned new things on my channel.

Hi Kathy, Thanks for watching my channel. you have to click on line 1 and then enter down key so you can add new line i.e. line 2. i hope, my answered is clear your query, Please let me know if you have doubt. Thanks Sohatech World

Hi Rajesh, thanks for watching my channel. I would suggest you yo check your mic setting or audio setting as video is already have sound.., off course there is no sense to upload technical video without sound.

Thanks for watching my channel, i dont see the use of special and pair value set in my Oracle experience. below is the link which explain the special and Pair value set, but not practically like me. docs.oracle.com/cd/A60725_05/html/comnls/us/fnd/values23.htm

Hi Nitin, Thanks for watching my channel, you can check the profile option "MO: Operating Unit", if OU is not assigned to your responsibility in this profile option then you can not create PO for this OU. secondly you have purchasing option setup for the OU, in Purchasing. Please check.

Hi, Thanks for watching @Sohatechworld, you can see my revaluation video that explains how to save account and revaluation template. below is the video link. th-cam.com/video/IXFop4ksyFg/w-d-xo.html

Hi Satish, Thanks for watching my channel, i have started working to record video with all the possible scenario, i believe it will help a lot as i faced challenges in AR to GL reco and sometime its very hard to find out the difference and using backend query i almost can do AR to GL reco quickly. you will get notification when video will uploaded.

Thank you bindhu, i am very happy to see that my video help you and saved your time. thats my goal to help and share the knowledge.

Hi, Thanks for watching my channel, see data loader having predefined key which work based on your mapping so if you have specific requirement then you have to check and explore the key, just keep in mind sometime its not possible to fulfill our requirement too. its all depend on predefined key on data loader and what we are uploading through which document type.

Hi Uyi, Thanks for watching my channel, could you please share the screen shot of the error and fiscal year calendar. it may be some reason that you have define fiscal year from 01-Apr-2023 to 31-mar-2024 for 2023 -2024 fiscal year. you should define all in sequence and do not left any of the month from Apr-23 to Mar-24. if you have define future period in GL (accounting setup) , say example 5 and you are in period Aug-23 period and want to open Aug-23 then of course sysem will check the coming 5 period should be exist in define calendar else system will give the error. thats why period should be define at least one year in advance to avoid this error. exact reason i can tell you after sharing the screen shot and error message that what is the reason and how to fix.

Glad it helped, Thank you for watching my channel.

Thank you! Cheers!

Hi Leo, thanks for watching, you can see the video description and can find part 1 and 2

I will try my best and will update you on this. Thanks

@@Sohatechworld Perfect. I would be so thankful to you.

Hi, thanks for watching channel, you can reach me at erptrainer01@gmail.com

Hi, Could you please explain in more detail, what exactly you would like to do

Thanks for watching my channel, it will depend on you what topic you want to learn… as you know we have so many activity in financial and each activity having each role to play and support by you… It’s up to you what would like to see. Thanks

Hi, Thanks for watching my channel. Just to make sure, BU access should be granted on responsibility level, normally this is the most probably issue encountered if we missed assignment of BU to responsibility.

Thank for the comment, yes you are right for account I have not created a new value set and used existing value set which ADB company because this value set having all the values so I don’t need to create a new one for account. If I go for creating value set for account then it’s takes time and I have already recorded the value set video that’s why I have not gone in details to create value set for the account. This video recorded for COA setup so I don’t think I need to go in more details for creating a value set and it’s separate topic and if you really wants to know about value set how to create and what are types of value set, I will suggest you to watch my value set video, it will clear a concept. I hope this is answer of your query.

Thanks for the watching my channel! You can develop your customize revaluation report, firstly revaluation concept should be clear and then you have to cover all the possible cases before starting develop the report. I can help but if you would like to know idea or solution. You can drop an email to erptrainer01@gmail.com

Thank you

Hi Ramesh, thanks for watching my Channel, I can give some input here why Oracle not provided any configured related lockbox configuration because lockbox configuration always depend on Bank file and data so there are lots of bank and it’s very hard to config lockbox on vision for each bank. To config Oracle required mapping file from each. Bank based on the real account

Hi Ramesh, you are asking for complete Lockbox end to end solution, i can help you on this, as its paid solution. i worked as freelancer and trainer so complete solution it will be charge. you can reach at theoracleking2021@gmail.com or erptrainer01@gmail.com whatsapp: +91-8979482794

Thank You

Thanks for watching my channel, Reversal journal always find with reverse% and then you can enter your journal name which you have reversed. so you can easily find your reversal journal.

It will be uploaded soon. Thanks

Thanks for watching my channel, could you please share the screen shot or send it on my email theoracleking2021@gmail.com or erptrainer01@gmail.com whatsapp: +91-8979482794

Hi Nagraj, Thanks for watching my channel, you can see realized gain and realized loss account on payable options in tab currency, secondly you can also see on bank account setup. basically exchange gain and loss account comes in picture when we make a payment in different currency .

Hi Suman, Thanks for watching my channel, i have already covered database backend part to look the lockbox data in the tables, in the second part i will also cover the more details how to look in database table if lockbox file data is not correct for some of the records. basically in the standard lockbox, main role played by functional, 100% setup is done by functional. more technical work is required when you are implementing lockbox interface for the legacy system file not bank file.

Hi Suman, Thanks for your feedback, i will share the lockbox file with session part-2, you will receive the notification for this.

Thank You for the comment and watching my channel, i will take care of Voice quality.

Hi Manoj, you can book the invoice in USD because received in USD currency and payment currency choose the USD because you want to pay in USD. when you make a payment with same currency USD you can make a payment. Normally some company they have foreign account also so they have USD bank account and they will pay in Oracle using usd bank account. or if you would like to pay through INR bank account just make sure multi payment currency check box is checked on bank account setup on Operating unit level. so you can pay in USD and through the exchange rate you will get the amount in Functional amount. Please let me know if any doubt

Thanks sir..i want to ask more questions ....how can i connected with you.

Hi @@Sohatechworld if we pay an invoice entered in foreign currency and we pay in foreign currency, how can we stop revaluating these transactions, we reconciled it through CE but the revaluation process keeps revaluating them. Thanks!

Hi Shivam, Thanks for watching my channel, i will upload very soon in Financials video in SAP/Oracle Fusion Module and other technology.

Sorry Shivam, i wish to record the session in Hindi but my channel is viewed by Global viewer with different countries so English is common for all to understand.

Hi Vatan, unapplied receipt register, if you run for specific period that will show all the unapplied receipt and those receipt in that period ex: Jan-23 in jan-23 period accounting will be transfer those you can see in unapplied receipt register journal entry report. normally you can check 1. if unapplied receipt is not done in future period, some time its happened if user applied receipt in Jan-23 and during closing they found that receipt application user did wrong so user unapplied the transaction and when user does by default system take current sysdate on unapplied screen so by default it will be feb-23 date so it may create differences in the closing. 2. make sure in GL all entries are transfererd and posted to GL. 3. sometime entries status shows posted to GL or transfer to GL but in backed only flag updated so you have to prepare a query to execute on db level using sql query. on XLA table (Xla events/xla_ae_headers/xla_ae_lines) i have some query which can easily tell you the differences, i will check and posted here which will help you to find out the incorrect accounting transaction/receipt. Thank you for watching my channel.