Customer creation in oracle apps r12

Customer creation in oracle apps r12. Oracle Receivables prints this number on customer invoices. AME – What is it? i. Oracle Customer Data Management. STEP 3: Corrections to Imported Data from Order Import Corrections Window. If any errors occur it can be found in ra_interface_errors_all table. param x_return_status : Represent the API status. Parameter Name. Create a modifier line. In the Longlist dialog box, enter a% and click OK. decrypt; Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v; Query fetching the customer information based on order number ( R12 - Order to Cash Cycle ) This diagram shows the process flow for managing, searching, creating, and updating customer information. Dec 27, 2018 · 12. EMAIL_ADDRESS,’|’) WITHIN GROUP (ORDER BY cont_point. what do i need to setup so that I can select customer items defined in inventory. PROCEDURE create_banks_accounts (p_change_type VARCHAR2) AS. oracle. Navigate to the Transactions window. End User Step 2. R12. Please find below the detail query to get customer email address in oracle apps r12. Notes Receivable Receipt Class ( Select the Checkbox if Receipt to handle future payments through Check or Promissory Note Document are considered in this option. Then create contact point (Phone, email, fax) for the person. 1] Put the data into your staging tables. This parameter works only with CREATE_SINGLE_INVOICE procedure. See the Oracle Workflow User's Guide for more information. API Usage. 22. Note: You can also define a minimum receipt amount at the customer profile level. Feb 27, 2013 · Feb 27, 2013 11:34AM edited Feb 28, 2013 5:53AM 3 comments Answered. This is available through the View Diagram button. Jan 12, 2014 · AR Customer Tables and their joining in R12. Enter the Customer Item number and description. Oracle Apps R12 SCM Consist of Below Modules. Mar 6, 2023 · Click to get started! In this Document. This column is required. Oracle Trading Community - Version 11. create_person (p_init_msg_list => fnd_api. The customer master record contains information and processing instructions that the system uses to process sales orders, accounts receivable transactions, and credit and collections information. How to find Order types in R12 (Script for Order types) Query To Fetch Customer Account/Site Contact Details in R12; How to get Oracle Application User Password from database - oracle. Check the Status check box to make this profile class active. Each transaction line is stored as a unique record, based on the primary key customer_trx_line_id column. WebSessionManagerProc This routine is used to create a Customer Account. Oracle iStore allows businesses from all industries to establish business-to-business (B2B) and business-to-consumer (B2C) electronic commerce (e-commerce). Oracle Inventory Management. The API creates a record in the HZ_CUSTOMER_PROFILES table. The profile can be created at party level, at customer level, or at customer site level. Use the Banks window to define banks and bank accounts for your customers. 1. 10 to 12. Step 3 - Create the Internal Location. The Customer form in Release 11. May 13, 2016 2:16AM edited May 18, 2016 2:42PM 2 comments Answered . Step 4 - Conduct a Miscellanous Transaction (Receipt) Step 5 - Create the Internal Customer - Assign the Location. AR Customer Tables and their joining in R12. Apr 3, 2023 · Click to get started! My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. This script helps us to comprehend how to update customer Profile into oracle through API. WebSessionManagerProc. The IBY_EXT_BANKACCT_PUB. Apr 25, 2023 · Oracle Payments - Version 12. 13. A Note could have the status ( Open, Return Dec 30, 2019 · 3. Validation: Destination: Settlement methods for deductions include invoice credit memo, on-account credit memo, previous on-account credit memo, write-off, charge back, RMA, and contra charge. •Appendix A, “Oracle Applications Menus,” describes the Oracle Applications main menu bar. •Appendix B, “Oracle Applications from Character 3. FROM hz_contact_points cont_point, Feb 14, 2024 · My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Click on Lines Tab. In the Line Qualifiers window, create a qualifier. 11. This document discusses setup, simulation, running, reports and other information relevant for Oracle Receivables Automatic Receipts and Remittance feature in Oracle E-Business Suite Release 12. The search results should show the party created. Still, Oracle has no plans to come up with version R13. May 20, 2011 · Enable Create Event/Subscription button in R12. Oracle R12 Supply Chain Management (SCM) is a systematic approach to manage the seamless flow of information, materials, and services from raw material suppliers through factories warehouses to the end customer. Specifically, this chapter tells you how to set user profile options and which user profiles are common to all Oracle Applications products. Script to import Bank account details for suppliers. decrypt; Query To Fetch Customer Account/Site Contact Details in R12; Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v; How to get Oracle Application User Password from database - oracle. Script to get EMAIL information of the customer. 10. Can anyone comment if you encounter same issue below? 3. This document provides the basics about the How to find Order types in R12 (Script for Order types) Query To Fetch Customer Account/Site Contact Details in R12; Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v; How to get Oracle Application User Password from database - oracle. Note that A. 1. ar. decrypt; Query To Fetch Customer Account/Site Contact Details in R12 Jul 27, 2018 · 3. Oracle iStore provides merchants with an easy-to-use interface for setting up specialty sites that capture and process customer orders. Oracle user is the base of Oracle EBS ERP; Like creating a user from the front-end (Application), sometimes we need to create users from the backend (database) using API (Application programming interface). AME is a simple to use Rules Engine for Defining Approval Policy ii. HZ_CUST_ACCOUNTS. The user enters optional and required information (such as Organization Name and Zip Code) and clicks Search. Create new Branch if it does not exist 3. 3 [Release 11. Navigate to the Customer Profile Classes window. Active profile classes appear in the Profile Class field list of values in the Customers windows. WebSessionManagerProc Apr 18, 2023 · 8. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support Sep 26, 2023 · This note provides an overview of the Receipt APIs, sample scripts for each of the available procedures and tips on troubleshooting the API. Sep 4, 2022 · Introduction. Tax Registration Number. These APIs utilize the new TCA model, inserting directly to the HZ tables. Post validation valid records are being passed into APIs. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. A customer who spends $45 to $100 on an order line receives a free cosmetic bag. For example, it might specify a credit limit for the customer or designate whether delinquency notices Introduction. Create Credit Memo. Sep 18, 2016 · Learn how to create new customers in oracle ebs r12 also on https://technofunctionals. May 16, 2016 · Add Printer from backend in oracle apps R12; Dynamically pass the date or Year or month in pl/s Link Between PO and WIP Tables in oracle apps; xml bursting using pl/sql stored procedure; query to get the code of package, procedure,function; link between AP, PO,INV to get the invoice price,p sales amount for customer (RA Headers/Lines Jan 24, 2021 · Perform the below steps on how to setup AR Receipt Classes in Oracle Apps AR R12. The Customer Interface program validates the data you load in the Customer Interface tables by ensuring that the columns in the interface tables reference the appropriate values and columns in the rest of the system. Oracle Purchasing. I am trying to create a new site to existing customers which are manually created in EBS. Un-apply the receipt for the total of the credit memo. Step 2 - Creating the Shipping Network. STEP 1: Load data into Interface tables either with SQL Loader or any other utility once all the pre-requisite setups are done. hz. 5 to 12. Select one of the existing Customer Names (in the Details window, you can use either Customer Name or Customer Number,). May 18, 2023 · My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. 9K views 5 years ago. Modifier Type: Promotional Goods. l_cust_account_rec hz_cust_account_v2pub. API helps to update any customer details in oracle apps. regards, Ramakrishna. It also creates profile amounts based on the value passed for p_create_profile_amt. The following script helps to create a Customer with basic information (mandatory information) in Oracle Applications TCA Architecture. It should do the following: 1. Click OK. Regards, CL. i-oracle. ln_count NUMBER; ln_success_count NUMBER; See: Oracle Applications Supportability Guide. CREATE_SINGLE_INVOICE: Create a single invoice and return customer_trx_id. Dec 4, 2019 · End User Step 1. http://www. AME is Oracle Apps R12 SCM Course Details. The Oracle Receivables R12 AR lookups are maintained in the FND_LOOKUP_VALUES Table where the LOOKUP_TYPE and MEANING Column values should be unique. e Procurement dept will enter Attributes in Purchase Tab. HZ_PARTIES. Log In. Value To: 100 Dec 27, 2011 · API'S WHICH ARE USING :- hz_party_v2pub. When we have loaded data in staging tables then the second thing is to validate the data means to check whether this data is ok to load in Customer Interfaces Tables. The API creates a record in the HZ_CUST_ACCOUNTS table for party type Person or Organization. x Oracle E-Business Suite, covering basic navigation skills and essential topic areas. Oracle Trading Community Architecture is the foundation not only for the Oracle E-Business Suite, but also specifically for the product family that it belongs to: Oracle Customer Data Management (CDM). A record for the new quote is created when you enter the quote name and other mandatory information. When we search for an employee name we see multiple records and are not sure which one to create an account under. Statements. Qualifier Context: Volume. decrypt Jan 24, 2021 · New lookups can be created or predefined lookups can be updated in the Oracle Receivables R12. Print statements to provide your customers with a complete record of their invoice, debit memo, chargeback, deposit, receipt, on-account credit, credit memo, and adjustment activity for a specific period. This will give you an approach for your customer requirements. Sep 27, 2013 · Each department will enter its details i. See: Interactions, Oracle Customer Interaction History Implementation Guide. Line is scheduled automatically when the Line Item is saved. CREATED_BY_MODULE is ' HZ_CPUI '. apps. line_type : Receivables lookup code for STD_LINE_TYPE. If the creation method of the receipt class is Automatic, enter a Minimum Receipt Amount. Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI). Then establish a relation between the Person Party and the Organization Party (main party, means Customer) Then create contact at Account level or Site level of the customer. cust_account_rec_type; Sep 5, 2023 · One of the major changes in Oracle Receivables Release 12 is the introduction of the new user interface for Searching, Creating and Maintaining Customer records. 2] Call your package to validate the data and load into AR Interface tables (RA_INTERFACE_LINES_ALL & RA_INTERFACE_DISTRIBUTIONS_ALL). Lets name it Go4Gold [which also happens to be the name of my old company]. 01. Grouping Number: -1. fnd. The interface supports the same data relationship for customer information as the customer window. DESCRIPTION: This routine is used to create a Customer Profile. This will create a Supplier. Step 1 - Creating the Item. Enter the bank account name to assign to this customer or Bill-To address. Mar 11, 2015 · 3. Oracle Receivables (AR): Receipts Workbench Information Center > Note 745996. Enter the Date and Currency for this credit. Architecture. 2]: How To Set Or Change the Primary Bill To and Ship To Address in R12. 1]: TCA API: How to create a Customer Account for an existing PARTY? May 27, 2020 · Person Type Customer link to HR Employee. This Post illustrate steps required to import bank account details of the suppliers in Oracle EBS R12. Aug 4, 2020 · Required for Invoices. See: Implementing Document Sequences. param x_customer_trx_id : Returns customer_trx_id in case it is called for creating a single invoice. wordpress. Fusion application is the next version of Oracle apps which are purchased by various companies like Siebel Systems, PeopleSoft, JD Edwards, and so on in the last few years. com. Trading Community Architecture is the implementation of technology and applications to allow users to create and maintain relationships among entities. This document provides information about how to create a customer using TCA API. AR_INVOICE_API_PUB Apr 7, 2016 · Steps for Sales Order Conversion. 0 and later: How to use TCA API to Update Payment Term at Customer Site Level? Apr 6, 2020 · Oracle has provided the standard API to update the customer details in oracle apps r12. If the bank account has not already been defined, Customer Interface will try to create it in AP_BANK_ACCOUNTS. Receivables provides country-specific validation of the tax See: Using Attachments, Oracle Applications User's Guide. To define customer items. I tried using Workflow Administrator, Workflow Administrator Event Manager and Workflow Administrator Web Applications responsibilities. hello experts, I am trying to create a business event/subscription in R12 and I cannot find the "Create" button. Simply enter name of the Supplier in organization name field and click on Apply. 10. Hello Experts, I am trying to create sales order in R12 and I see only internal order type in Item Ordered field. X How to find Order types in R12 (Script for Order types) Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v; Query To Fetch Customer Account/Site Contact Details in R12; How to get Oracle Application User Password from database - oracle. Operator: Between. To begin with, we need to create a Supplier. Goal. Workflow Status Page. This guide describes how to create and modify quote templates, add and configure simple and related products, manage pricing and pricing adjustments, determine customer Feb 7, 2014 · Approval Management Engine FAQ 1. STEP 3 – Select the party in question and click on the button ‘Create Account’ and continue to create the customer account under the same party. EMAIL_ADDRESS) into lv_email_address. How to get Oracle Application User Password from database - oracle. 5. Nov 20, 2017 · CUSTOMER CONVERSION IN ORACLE APPS R12 via API's - OVERVIEW (2) Changing existing report (2) Conversion Using API (2) Create Accounting Program: (2) Data Flow from AR to XLA to GL (2) Date Functions (2) Debugging an Internal Requisition which not turned to an Internal Sales Order (2) Developer tips; Easy test editing ;Notepad++ (2) the behavior of certain Oracle Applications features. Feb 5, 2024 · Click to get started! In this Document. If you are not using Automatic Sequence Numbering, enter a unique Number for this credit. Modifier Level: Line. 5. To define a new customer profile class: 1. Here below you will get all the complete information's of Customer base tables Apr 4, 2011 · Use the Profile subtab of the Customer Overview page to add and update the profiles of existing customers. The line_type column identifies the type of data contained in the Jan 2, 2013 · R12 – Receivables Setups (AR) in Oracle Apps. Apply debit memo to receipt. 2 Oracle E-Business Suite Fundamentals, This Oracle E-Business Suite training introduces you to the R12. This Post illustrates the steps required to get EMAIL information of the customer in Oracle EBS R12. On completion of all the attributes, system should alert an Approval Work flow for User Approval. Load data from Excel file in to the Staging tables with the help of sql loader. Using API , we can mass update the customer details. Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect. Here below is the detail steps about API to update customer in oracle apps r12. SELECT LISTAGG ( cont_point. Back-To-Back The RA_CUSTOMER_TRX_LINES table stores invoice, debit memo, and credit memo line level information. 20. This course provides a functional foundation for all E-Business Suite applications. For example, a party can be an Organization like Oracle, a Person like Jane Doe, a Group like World Wide Web Consortium, or a Relationship like Jane Doe at Oracle. Below is an example for creating a check refund when Allow Over-application is selected. 6K subscribers. Person. The same procedure cannot be used to associate an existing bank account to another site since the procedure will fail when the bank account exists already. We have set the AR: Show Parties Without Accounts in DQM = Yes. The quote number is unique across all quotes for all customer IDs and account numbers. Workflow Monitor Page. In this post , We will discuss about Technical tables uses to store customer information's in oracle apps r12. Apr 10, 2019 · 3. May 13, 2016 · Oracle Apps Customer Interface Add New site to existing Customers. Dec 14, 2023 · Click to get started! My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Create the org contact role using x_cust_account_role_id from step 9. com/ more. Oracle Quoting then generates the quote and version numbers, creation date, and status. GET_APPROVAL_STATUS) How to get Oracle Application User Password from database - oracle. Enter a Name and a brief description of this profile class. To view full details, sign in to My Oracle Defining Customer Sites. See: Customer Overview. Receivables overview: Accounts receivable is an asset account in the general ledger that documents money owed to a business by customers who have purchases goods or services on credit. decrypt; Query To Fetch Customer Account/Site Contact Details in R12 Dec 25, 2019 · This Query will help to extract the email address for customer from customers header, customer site and from customer contacts level. Mar 28, 2018 · Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers. In the body, insert detailed information, including Oracle product and version. Enter the Customer details (Ship to and Bill to address), Order type. The EBS Oracle Receivables Lockbox Analyzer is a self-service health-check script that reviews Lockbox related data, analyzes current configurations and settings for the environment and provides feedback Feb 1, 2023 · Prior to Release 12, there are a number of steps involved to do check refunds. Oracle Quoting enables you to create and manage customer quotes across all sales and interaction channels and if approved by the customer, convert these quotes into orders. Create a Debit Memo (for the amount of the credit memo). Account can be created for an existing party by passing party_id of the party. the value for the HZ_PARTIES. Create a contact using party_id you get 8 and cust_account_id from step 2. Oracle Service shares its customer master with Oracle Order Entry/Shipping, Oracle Receivables, and Oracle Sales and Marketing, providing you with consistent customer profile information across applications that need to share this information. You can produce statements that differentiate between bill-to sites for a customer's outstanding items. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. Qualifier Attribute: Line Volume. It is a way to understand who your customer interacts To create an on-account credit: 1. Apr 14, 2011 · Trading Community Architecture (TCA) API. Create a relation cont-org using party_id from step 7 and party_id from step 2. Mar 27, 2020 · There are four activities in loading of customer Master. The table includes the parameter names, the type of each parameter, the data type of each parameter, the necessity of the parameter, and other information about the parameter such as validation, defaults, and other comments. Subscribed. Networks is entered in both the Customer Name From and Customer Name To fields. C. The customer_trx_id column is a foreign key to the RA_CUSTOMER_TRX table. security. 4. param l_trx_lines_tbl . 2. Hi. Jun 21, 2023 · Purpose. The methodology described here is one of the proven strategies which we used in our conversion project. STEP 2: Run ‘Order Import’ program to validate/load sales orders. CDM Query to get basic AP Invoice and Payment information from Oracle Apps R12; WSH_DELIVERY_DETAILS. The customer’s unique taxpayer registration number, also known as the VAT number. com/ - Oracle Training and Tutorials - Learn how to Create a Customer in Oracle E-Business Suite R12. 0 and later: How To Create/Update Tax Profile at Customer Site level Using Rest API. This triggers the match flow, where the composite UI application synchronously Mar 16, 2020 · Oracle E-Business Suite (EBS) R12 is different from the Oracle Fusion application. This will provide the complete email address information for customer in oracle r12. For more information about Oracle (NYSE:ORCL), visit oracle. 6 [Release 11. See: Searching for Organizations or Persons. 2. Overpayment. See: AR_INVOICE_API_PUB. Mar 22, 2016 · In this post, we have tried to describe the process flow of customer conversion in graphical manner and Oracle Standard API’s to load the data into R12 Target System. Oracle Receivables - Version 11. To view full details, sign in to My Oracle Support Community. See: Creating a Customer, Oracle Receivables User's Guide. The below given are the commonly used Oracle Receivables lookups in R12. 9. After you select the person, you can switch from the person to a contact Oct 29, 2015 · Below are the steps to create customer contacts. Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v; How to get Oracle Application User Password from database - oracle. Enter Receipt Name. 11. References. Enter the Item to be ordered and the quantity required. Customer base tables in oracle apps r12 are related to the TCA tables in oracle apps. AR_INVOICE_API_PUB. 0 and later: How Can We Add New Values Under Customer Class List Of Values? Mar 13, 2024 · My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Create Account and associated with Customer . 1 Understanding Customer Master Information. We want to start using person type customer in AR and creating an account associated with their HR employee record. Customer Lookups: The below Feb 28, 2016 · CUSTOMER CONVERSION IN ORACLE APPS R12 via API's - OVERVIEW (2) Changing existing report (2) Conversion Using API (2) Create Accounting Program: (2) Data Flow from AR to XLA to GL (2) Date Functions (2) Debugging an Internal Requisition which not turned to an Internal Sales Order (2) Developer tips; Easy test editing ;Notepad++ (2) Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS) Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v; Query To Fetch Customer Account/Site Contact Details in R12 Create Customer using create_cust_account API. Select the Find button to open the Customer Items Summary window. Navigate to Receipt Classes. 2 to 12. Query To Fetch Customer Account/Site Contact Details in R12; How to find Order types in R12 (Script for Order types) API to find AP INVOICE Status (AP_INVOICES_PKG. Otherwise, Receivables assigns a number when you save. CREATE_INVOICE: Creates multiple invoices in a batch. Overview: Trading Community Architecture (TCA) is an architecture concept designed to support complex trading communities. Value From: 45. Networks from the list and click OK. 3] Then submits a concurrent request for AutoInvoice. Party is a generic concept about an entity that can establish relationships with another entity. Once the Item Approved then Item will be created in Automatically in Orcale Apps. Here query the party by name you used when creating the supplier in step 1. Accounts receivable can be contrasted with accounts payable, a liability account in the GL that documents money Enter the Sales Order: Order Management Super User Operations (USA)>Orders Returns >Sales Orders. decrypt; Query to fetch Purchase Requisition Approval Action History Details in Oracle Apps R12 (PO_ACTION_HISTORY) When a user accesses the Oracle E-Business Suite Customer Module to search for a party in the Customer Module, the composite UI application form appears. Alternatively, this routine creates a new party and an account for the party. Sep 18, 2014 · 3. This article will give an API code example to create user in oracle apps r12 from backend. Mar 2, 2023 · Click to get started! In this Document. Solution Nov 3, 2022 · STEP 2 – Log in to Receivables application and go to Customer UI. It also demonstrates the required validation taking place, and additional validation can be incorporated anytime in your package based on business requirements. Select A. user578908 May 20 2011 — edited Jun 10 2011. Apr 5, 2023 · In this Document. The following table lists information about the parameters in the Create Customer Account Site API. Dec 22, 2023 · Goal. 1 and later Information in this document applies to any platform. RELEASED_STATUS ( Pick Release Status) Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS) Query To Fetch Customer Account/Site Contact Details in R12 Aug 23, 2018 · Complete SQL query uses Customer base tables in oracle apps r12. Posted by Phani Adivi on October 17, 2018 in Oracle Home. CREATE_EXT_BANK_ACCT procedure is used to create a bank account and associate the account to a specific level (supplier or site). You can define customers, addresses, location codes, business purposes Home / EBS Technical / API To Create Bank Account Details in Oracle EBS-R12. To create an invoice, you can call the following PL/SQL APIs: AR_INVOICE_API_PUB. For more information on transaction types and adjustments for deductions, see the Oracle Receivables User Guide and the Oracle Order Management User's Guide. ,hl. We do use this API to update customer details using PLSQL script. May 28, 2015 · How to find Order types in R12 (Script for Order types) How to get Oracle Application User Password from database - oracle. 5 which was developed using Oracle Forms, has now been replaced by an HTML/Java interface in Release 12. Create new bank if it does not exist 2. Introduction. The note shows instructions to load customer bank account through API. Oracle Quoting - Version 11. To start, you search for the person that you want to manage information for as a contact. Key Features and Benefits. From the status page, you can access the Workflow monitor to see the order or line status in a more graphical format. Solution. Creating a Quote. 3. create. Receivables uses the larger of the two . This is the minimum amount in this currency that must be specified when you create automatic receipts with this payment method. g_fa To enter the customer name, scroll to the right and click the ellipses () next to the Customer Name From field. update. HZ_PARTY_SITES. Oracle Fusion Receivables Cloud Service - Version 11. Create a customer contact as a Party of type ‘ PERSON ‘. fx qz ap jd tv zz ze ol ex zy