Category: Oracle Apps Technical
-
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 of the below Profile Options…
-
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 you wont be able to…
-
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),…