Latest YouTube Videos
Learn how to install Oracle Database 23ai Free on Windows. This is a great way to explore the features of Oracle 23ai Database.
——————
SQL Harmony allows you to connect to your fusion instance and execute SQL Queries. Check out the igh level features of the tool.
——————
Data Pipeline enables you to orchestrate end to end processes in EPM. Learn how to invoke a Pipeline from Groovy.
——————
Dependent List of Values helps you to control the BI Publisher Report parameters based on value of another parameter while exeucuting the reports.
——————
Learn how to attach a list of values to a BI Publisher report parameter. This helps the user to select from a pre-defined list rather than type the value in.
——————
Data Pipeline enables you to perform cross pod file operations easily. There are in-built job types available to move, copy, unzip, rename and delete files.
——————
Latest Blogs
Check out the latest blogs on Oracle ERP, EPM and other related topics.
-
UTL_MAIL to Send Email form PL/SQL
Let us see how we can utilize UTL_MAIL to send Email form PL/SQL. Using the UTL_MAIL package is pretty straight forward. Check the below example. As you can see there are 4 different entities that you need to consider. Sender’s Email Id Recipient’s Email Id – You may include one…
-
Submit GL Journal Import From PLSQL
GL Journal Import GL Journal Import is used to import journals from sub ledgers and external systems into Oracle GL. We can do it manually or programatically. This post describes how to call the GL Journal Import from plsql procedure. We will be looking at importing AR (Receivable) Journal Entries.…
-
Make City, State, Postal Code mandatory for Supplier / Supplier Site Address
Requirement is to make the City, State and Post Code fields on the address (Supplier / Supplier Site) as mandatory. As you know, out of the box, these fields are non-mandatory. How do we achieve this? Well, personalization is not the way to get this done. 1. Get the values…
-
XML Output for AP Check Payments in R12
XML Output for AP Check Payments is part of the log file of Format Payment concurrent Program. Usually we look at the log file and use the XML tags from the log file. When the volume of payments made are high, the XML tags are truncated in the log file. So…
-
Excel and IE Setups for Oracle Web ADI
There are few setups that you have to do on Microsoft Excel and Internet Explorer to work with Oracle Web ADI. Excel Setups 1. Open Excel and go to File > Options You will see a new window as shown below. Select “Trust Center” on the left navigation pane and…
-
Issues with IE 10 and Oracle EBS Login
If you are using IE 10, then you might have issues when you login to EBS. The list of responsibilities will be shown as “undefined”. This is because of the incompatibilities with IE 10 version. You can get this resolved by clicking the “Compatibility View” option on IE. Please see…
-
APP-FND-1564: ORACLE error 24347 in FDFGVD
After upgrading to 12.1.3, I have been getting the below error while submitting the Auto Invoice Master Program from AR Responsibility. APP-FND-1564: ORACLE error 24347 in FDFGVD Cause: FDFGVD failed due to ORA-24347: Warning of a NULL column in an aggregate function. SELECT BATCH_SOURCE_ID,NAME VALUE, DESCRIPTION DESCRIPTION, NVL(‘N’, ‘N’), NVL(TO_NUMBER(NULL),…
-
Sorting the Time Card List in OTL
Recently I got a requirement to change the order in which the time cards are displayed in the Time Card list for the employees. The requirement was to show the latest time card on the top. We can achieve this using Self Service Personalization. Before we start make sure that…
-
OTL API Error
I was trying to update a previously submitted time card using the OTL API (hxc_timestore_deposit.execute_deposit_process). I was getting a very strange error as described below: ORA-20020: Pa_Otc_Api ::: ->Validate_Otc_Data->Validate_Process->DetermineProcessingFlags :: Only Ovn has changed. Update the orig_transaction_reference of the ei. : ORA-01403: no data found I searched a lot and…
-
Useful Oracle Apps Queries
Below are a list of SQL Queries that will be useful during your day to day activities. 1. Concurrent Programs Assigned to a Request Group SELECT fcpv.concurrent_program_name SHORT_NAME ,fcpv.user_concurrent_program_name CONC_PROG_NAME ,frg.request_group_name REQ_GROUP_NAME FROM fnd_concurrent_programs_vl fcpv ,fnd_request_groups frg ,fnd_request_group_units frgu WHERE fcpv.concurrent_program_id = frgu.request_unit_id AND fcpv.enabled_flag = ‘Y’ AND frgu.request_group_id =…