ap_invoice_post_register_details_of_specific_org This script is useful to provide details of AP invoice post register details along with PO number check number and check date accounting details invoice details
Read Moreapi_events api_events This is useful script while doing period close on every month basis. Some time there will be no relation will generate between AR invoice and Subledger . In…
Read Morevmdvendormetadata_extract_query This reusable component very useful in pulling payables vendor metadata that will have all the the information vendor payments bank details and along with VAT details
Read Moreinvoice-numberchange-script-for-brazil This is useful script that will help for Brazil Country. This script will find the invoice number of Brazil localization tables and modify the invoice number as per standard…
Read MoreSometimes we will observe HR Operating units table will not show any data in database. For this we need to do the set up in SQL Developer. Preferences –> NLS…
Read MoreRequirement Single Excel column output with multiple data separated by comma need to make row-wise data, eg Name Marks Peter 50,70,30 Need to change with this Name Marks Peter 50…
Read MorePlease find below query to get customer Bill_To Address SELECT DECODE (hcsua.site_use_code, ‘BILL_TO’, hl.address1 || ‘, ‘ || hl.address2 || ‘, ‘ || hl.city || ‘, ‘ || hl.state…
Read MoreFor any field if you want throw any exception when entered any special characters. We need to use following pattern to find. Pattern p = Pattern.compile(“[^a-zA-Z0-9\\s]”);
Read MoreAPI “AP_AI_TABLE_HANDLER_PKG.DELETE_ROW” can be used to delete AP Invoice Data. This Script can be used when invoice accounting is not done. DECLARE CURSOR CUR1 IS SELECT AIA.ROWID,AIA.* FROM AP_INVOICES_ALL…
Read MoreBelow Pseudocode, DECLARE L_RESULT BOOLEAN; L_PO_HEADER_ID NUMBER; — := <PO_HEADER_ID> ; L_TYPE_LOOKUP_CODE VARCHAR2(20); — := <LOOKUP_CODE> ; L_VALIDATION VARCHAR2(10) := ‘N’; — := <VALIDATION_FLAG> ; CURSOR CUR_PO_DEL IS SELECT…
Read More