Skip to main content

Posts

SQLCODE & SQLERRM Function

The SQLCODE function returns the error number associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code. The SQLERRM function returns the error message associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code. You could use the SQLCODE & SQLERRM  function to raise an error as follows: EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'Error - '||SQLCODE||' -ERROR- '||SQLERRM); END; Or you could log the error to a table using the SQLCODE & SQLERRM function as follows: EXCEPTION WHEN OTHERS THEN ERR_CODE := SQLCODE; ERR_MSG := SUBSTR(SQLERRM, 1, 200); INSERT INTO XXERROR_TABLE (ERROR_CODE, ERROR_MSG) VALUES (ERR_CODE, ERR_MSG); END;
Post a Comment
Read more

Delete a Concurrent Program in Oracle apps

Through the Application front end, we cannot delete a concurrent program, You can either enable or disable a concurrent program. But from the backend, we can delete it using fnd_program. begin fnd_program.delete_program('PROGRAM_SHORT_NAME','Application Name'); fnd_program.delete_executable('EXECUTABLE_SHORT_NAME','Application Name'); end;
Post a Comment
Read more

Matching Approval Level In Supplier Table

That one field is actually controlled by the interaction of two columns, AP_SUPPLIERS . Receipt_Required_Flag and AP_SUPPLIERS . Inspection_Required_Flag . If both columns are NULL or "N", that is 2-Way matching. If AP_SUPPLIERS.Receipt_Required_Flag is "Y" and AP_SUPPLIERS.Inspection_Required_Flag is NULL or "N", that is 3-Way matching. If both columns are "Y", that is 4-Way matching. AP_SUPPLIERS.Receipt_Required_Flag = NULL or "N" and AP_SUPPLIERS.Inspection_Required_Flag = "Y" is undefined. This SQL can be used ... SELECT DECODE (NVL(APS.receipt_required_flag, 'N'),                'Y', DECODE(NVL(APS.inspection_required_flag, 'N'),                            'Y', '4-Way',                            '3-Way'),                 '2-Way') matching_Level ...
Post a Comment
Read more

Barcode Report in XML Publisher

XML Publisher 5.6 has a new tab: Administration. This replaces the xdo.cfg configuration file. Now fonts can be uploaded and stored in the database instead of stored on the file system. Under the Administration tab are sub tabs: Configuration, Font Mappings and Font Files and Currencies. Download 3of9-barcode font. To install a font requires only a few steps. Font Family is the exact same name you see in Word under Fonts. If you don't use the same name the font will not be picked up at run time. Log in as XML Publisher Administrator. Navigate to Administration->Font Files->Create Font File Fields are Font Name and File. Fields are Font Name and File. For Font Name choose any descriptive name like below. Navigate to Font Mappings->Create Font Mapping Set Mapping name is the name you will give to a set of fonts. Mapping code is the internal name you will give...
Post a Comment
Read more

Data With Arabic Characters In XML Format

Issue: "The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------------------------- An invalid character was found in text content. Error processing resource 'http://4i.test.com:8000/OA_CGI/FNDWRR..." In the source code of the XML (View > Source) for the Arabic characters you found the following junk characters : "<FILE_DATA>¿¿¿ ¿¿ ¿¿ ¿¿ ¿¿ ¿¿¿¿¿·¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿¿¿ ¿¿¿¿ ¿¿¿¿ ¿¿¿¿¿ ¿¿¿¿ </FILE_DATA>" which can not be interpreted by XML parser. Solution: The issue will be resolved with the following settings: 1. Uncheck the "Allow Native Client Encoding" from the System Administrator > Install > Viewer Options  for the XML text/xml mime type 2. Set the profile option  "FND:Native Client Encoding" to WE8MSWIN1252. 3. Change the prolog value to <?xml ...
1 comment
Read more