Create and Maintain EBS Customers



Use API Wizard to quickly and easily create and update your Customers in Oracle EBS using API Wizard's simple Excel user-interface.

Work that takes hours in the Oracle forms can be done in minutes!  Stop toiling in the Oracle forms and do your Oracle EBS work the smart and easy way!

High Level Overview of Customers Process: 

  • Create and update Customers within Excel

    • Parties, Accounts, Sites, Site Uses, Contacts, Relationships, Bank Accounts, and more​

    • Replaces having to do these tasks in Oracle Forms

  • Work with individual Customer records or hundreds/thousands at a time​​​​

  • Safe, secure, accurate, super-fast, super easy

  • Works 'out of the box'

  • Extraction and stand-alone reports such as customer listings with drilldowns

  • Works with Flexfields, regional fields, etc

  • Works with Attachments

Customer Loader.jpg

Learn more

More Details:

  • Users login with EBS or SSO credentials

  • All access controlled with EBS responsibilities

  • Follows all Oracle security rules, such as MOAC

  • Enforces full Oracle validation - same as if working in Oracle forms

  • Supports additional business specific validations

  • All data processing through Oracle Public (supported) APIs

    • For those interested, this process uses these primary APIs:

      • iby_ext_bankacct_pub.create_ext_bank_acct

      • iby_ext_bankacct_pub.update_ext_bank_acct

      • iby_ext_bankacct_pub.add_joint_account_owner

      • iby_fndcpt_setup_pub.set_payer_instr_assignment

      • hz_party_v2pub.create_organization

      • hz_party_v2pub.update_organization

      • hz_cust_account_v2pub.create_cust_account

      • hz_cust_account_v2pub.update_cust_account

      • hz_customer_profile_v2pub.create_cust_profile_amt

      • hz_customer_profile_v2pub.update_cust_profile_amt

      • hz_cust_account_v2pub.create_cust_acct_relate

      • hz_cust_account_v2pub.update_cust_acct_relate

      • hz_relationship_v2pub.create_relationship

      • hz_relationship_v2pub.update_relationship

      • hz_location_v2pub.create_location

      • hz_location_v2pub.update_location

      • hz_party_site_v2pub.create_party_site

      • hz_party_site_v2pub.update_party_site

      • hz_cust_account_site_v2pub.create_cust_acct_site

      • hz_cust_account_site_v2pub.update_cust_acct_site

      • hz_cust_account_site_v2pub.create_cust_site_use

      • hz_cust_account_site_v2pub.update_cust_site_use

      • hz_customer_profile_v2pub.update_customer_profile

      • hz_cust_account_site_v2pub.create_cust_site_use

      • hz_cust_account_site_v2pub.update_cust_site_use

      • hz_payment_method_pub.create_payment_method

      • hz_payment_method_pub.update_payment_method

      • hz_party_v2pub.create_person

      • hz_party_v2pub.update_person

      • hz_party_contact_v2pub.create_org_contact

      • hz_party_contact_v2pub.update_org_contact

      • hz_cust_account_role_v2pub.create_cust_account_role

      • hz_cust_account_role_v2pub.update_cust_account_role

      • hz_cust_account_role_v2pub.create_role_responsibility

      • hz_cust_account_role_v2pub.update_role_responsibility

      • hz_contact_point_v2pub.create_contact_point

      • hz_contact_point_v2pub.update_contact_point

      • and more!

    • 100% supported by Oracle​

  • All records indicate who created (Created By) and last updated (Last Updated By)

  • Detailed Auditing allows capture of all data changes

Next Steps