Creating a New Modifier using Oracle API
When there is a business requirement to create a New modifier, we can make use of this code to Register as a Concurrent Program and create a new Modifier after…
Read MoreCustomizing the Hook Package IBY_FD_EXTRACT_EXT_PUB
Oracle Payments provides the IBY_FD_EXTRACT_EXT_PUB extensibility package to construct custom XML element structure that can be added to the payment XML extract generated by Oracle Payments. If there is…
Read MoreApplying Claim in AR Receipts
declare ln_trx_number VARCHAR2 (50); v_api_version NUMBER := 1.0; — V_init_msg_list VARCHAR2(1) := FND_API.G_FALSE; v_init_msg_list VARCHAR2 (1) := fnd_api.g_true; v_commit VARCHAR2 (1) := fnd_api.g_false; v_validation_level …
Read MoreGL Data Extract in EBS for both Receivables and Payables
exec mo_global.set_policy_context(‘S’,:&p_org_id); SELECT DISTINCT gjb.NAME journal_batch_name, gjh.NAME, gjh.default_effective_date gldate, msi.segment1 item, NULL brand, rct.bill_to_site_use_id bill_to_site_use_id, hca.account_number customer, gcc.segment3 “GL ACCT 3”, gcc.segment1 company, rct.interface_header_attribute2 ordertype, rctt.NAME ar_transaction_type, rctl.sales_order order_number, rct.trx_number…
Read More