Pages

▼
Showing posts with label AP. Show all posts
Showing posts with label AP. Show all posts

Oracle AP Supplier Extract Query

›
 SELECT hp.party_name supplier, ps.party_id supplier_ID, Initcap(ps.vendor_type_lookup_Code) supplier_type, DECODE(hp.status,'A...

Oracle R12 Vendor Invoice TDS with GST and PAN Query

›
 SELECT     aia.invoice_num,     aia.creation_date          invoice_creation_date,     jai.amount                 base_amount,     (        ...

Oracle R12 Supplier Update API

›
  R12: AP: New Supplier Update API's in Oracle Payables (Doc ID 1618099.1) SET SERVEROUTPUT ON DECLARE   lc_return_status             VA...

Oracle R12 Suppler Extract Query with Bank PAN GST details

›
--Oracle R12 Vendor Extract with Bank PAN GST   SELECT     (         SELECT             hou.name         FROM             apps.hr_operating_...

Oracle R12 AP Invoice Cancel List with PO GRN

›
--AP Invoice Cancel List with PO number and GRN SELECT     aps.vendor_name,     assa.vendor_site_code,     aia.invoice_num,     aia.invoice_...

Oracle R12 AP Payment status Transmitte script

›
-- Find the payment_instruction_id form below script  SELECT     payment_instruction_id PaymentInstructionID,     payment_instruction_status...

Error: One or More Transformations Used by the Matching Rule Have Not Been Staged

›
Issue is not create a Supplier   Error: One or More Transformations Used by the Matching Rule Have Not Been Staged Reslove: Run Concurrent P...

Oracle R12 Supplier Site update API

›
---Supplier Site update API  DECLARE    p_api_version                 NUMBER;    p_init_msg_list               VARCHAR2 (200);    p_commit  ...

Supplier Bank Interface at Supplier Level

›
#Table Structure CREATE TABLE XXCUSTOM.XX_AP_EMP_SUPL_BANK_STG (   SUPPLIER_NAME                VARCHAR2(300 BYTE),   SUPPLIER_NU...