Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS.ADDR_ELEMENT_ATTRIBUTE2)
Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
Sunday, July 14, 2024
Saturday, January 20, 2024
Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)
Thursday, January 18, 2024
Query to get Item Category Details in Oracle Fusion
Query for AR Sales Representative Name in Oracle Fusion
Join between Sales Order(SO) and Receivables(AR) in Oracle Fusion
Friday, November 24, 2023
Query to get AP Invoice Distribution to Inventory Material Distribution Data
Monday, June 5, 2023
Query to get Requisition to PO Details in Oracle Fusion
Saturday, March 4, 2023
What is the difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in Oracle Fusion
PER_ALL_ASSIGNMENTS_F is a view which stores effective latest change only.
The definition of the PER_ALL_ASSIGNMENTS_F view:
If you want all the data then use the base table : PER_ALL_ASSIGNMENTS_M
If you want the effective latest change only, please use : PER_ALL_ASSIGNMENTS_F
Wednesday, February 8, 2023
Query to get Employee Leave Balance for Specific Plan in Oracle Fusion
Friday, January 27, 2023
Query to get Customer Details in Oracle Fusion
Friday, January 6, 2023
Script to update Supplier pay_group_lookup_code in Oracle APPS R12
Script to update Supplier Type(ap_suppliers.vendor_type_lookup_code) in Oracle APPS R12
Script to update Supplier Tax Payer ID(AP_SUPPLIERS.NUM_1099) in Oracle APPS R12
Sunday, December 18, 2022
API to Create Online Accounting for AP Payment in Oracle APPS R12 (ap_drilldown_pub_pkg.payment_online_accounting)
ap_checks_pkg.get_posting_status(check_id) to pick AP Invoice Payments which are not acconted.
Pass check_id from ap_checks_all (aca) to ap_checks_pkg.get_posting_status to pick invoice payments which are not accounted.
ap_checks_pkg.get_posting_status(aca.check_id)
Saturday, December 17, 2022
INVALID_PATH: File location or filename was invalid(UTL_FILE) in Oracle APPS
1. Create Directory using below command
CREATE OR REPLACE directory XXDIR AS '/home/erp';
--Here change directory path(/home/erp) according to your path.
Give the required permissions to above path.
2. Connect to WinSCP/Putty and Create directory.
3. Now use the directory name in utl_file
UTL_FILE.FOPEN('XXDIR ','file_name','R');
Wednesday, November 9, 2022
Package jdr_utils in OAF
Jdr_utils.listcustomizations:
- Searches Personalization’s for the OAF Page. We can find the Page URL (path) from about this page.
jdr_utils.DeleteDocument:- It deletes Personalization.
exec jdr_utils.DeleteDocument('/oracle/apps/eam/workorder/webui/customizations/site/0/EAM_EW_START_PAGE')
Thursday, November 3, 2022
Invalid customer transaction identifier.APPLY : ORA-01403: no data foundORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply
One of the possible reason is Invoice already paid.
You can validate with below query.
select * from ra_customer_trx_all where trx_number = '1'
note customer_trx_id from the above query.
select * from ar_receivable_applications_all
where applied_customer_trx_id = <pass customer trx id>
note cash_receipt_id from above query
select * from ar_cash_receipts_all
where cash_receipt_id = <pass cash receipt id>
Tuesday, October 25, 2022
Is there any API to End Date GL Code Combinations from Backend in Oracle APPS
As per the Oracle as of now there is no API to End Date GL Code Combinations from Backend. Please refer below notes from Oracle Support.
- Is Effective Date From / 'Start Date Active' Mandatory for GL Code
Combinations? Can it Be Changed to "null" Value? (Doc ID
2763034.1)
- Check
if these details could have been ported from the segment values, in that
case verify if you want to have Start/End Date for the segment values
left in the system while the same details would be removed for the code
combinations
- Any sql
update on gl_code_combinations table will not be supported in any way.
You must perform the changes in the code combinations form, manually.
- To
port changes from segment values to code combinations, you may use
Program - Inherit Segment Value Attributes (see referenced documents)
- GLNSVI: What is the Purpose of the Segment Value Inheritance
Program/ Program - Inherit Segment Value Attributes ? (Doc ID 170569.1)
AR Receipt Reversal Categories(REVERSAL_CATEGORY_TYPE) in Oracle APPS
Friday, October 21, 2022
Script to Update Liability Account, Prepay Account, Invoice Withholding Tax Group and Tax Classification Code at Supplier Site Level in Oracle APPS
Table Script:
Script to Update Supplier Vendor Type and Invoice Withholding Tax Group at Supplier Level in Oracle APPS
Table Script:
AP_SUPPLIER_SITES_ALL.AUTO_TAX_CALC_FLAG in Oracle APPS(AP_TAX_CALCULATION_METHOD)
Wednesday, October 19, 2022
API call failed with error ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site
We had a requirement to update Tax Classification Code, Invoice Withholding Tax Group at supplier level. While using ap_vendor_pub_pkg.update_vendor_site API we got below error message:
The API call failed with error ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site
But when used ap_vendor_pub_pkg.update_vendor_site_public the update was successful.
CE_PAYMENT_TRANSACTIONS.SETTLE_BY_SYSTEM_FLAG in Oracle Cash Management
CE_PAYMENT_TRANSACTIONS.SETTLE_BY_SYSTEM_FLAG Determines whether the settlement is required through oracle Payments.
Tuesday, October 18, 2022
AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE and AP_CHECKS_ALL.PAYMENT_METHOD_CODE in Oracle APPS
Below is from Oracle Metalink ID 1919051.1
PAYMENT_METHOD_LOOKUP_CODE is obsolete in R12 hence it should not be referred in R12. If you want to refer payment method code from Invoice header then PAYMENT_METHOD_CODE should be used. During upgrade to R12 we populate PAYMENT_METNHOD_CODE with PAYMENT_METHOD_LOOKUP_CODE for migrated invoices.
Monday, October 17, 2022
Query to get Asset Categories with GL Codes in Oracle APPS
SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT
Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
LOT_CONTROL_CODE column contains values as 1 & 2 in mtl_system_items_b table. Inorder to find meaning for this values run below que...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...