Author: Arun Raj
-
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 then click on “Trust Center…
-
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 the image below: Once you…
-
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), -1), NULL, NVL(‘Y’, ‘Y’), NVL(TO_CHAR(TO_DATE(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 the following profile options are…
-
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 did not find any help…