Lets take an example. Suppose you are running a small grocery shop, so the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and […]
The migration of transactions & journals from legacy to oracle is the most difficult part of data migration. You should migrate all the GL balance for the current year periods, all the last year periods and the ending balance of ‘Y-2’ to oracle. You need to do a proper reconciliation of GL balances after migration […]
The sets of data required by Oracle Applications can be broadly classified in to 4 categories Master Data : Item, Customer, Vendor, Bank Accounts, etc. Opening Balances: On-Hand Quantity of Items, GL Balances, etc. Open Transactions : Open Purchase Orders, Open Sales Order, Open Invoice etc. Set-up Data : Item Categories, Stock Locators Similary source […]
Customer APIshz_party_v2pub.create_organization Org Contact Role Hz_party_contact_v2pub.Create_Org_Contact_RoleRelationships HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATECustomer Profile HZ_CUSTOMER_PROFILE_V2PUB. create_customer_profileCustomer Profile Amount HZ_CUSTOMER_PROFILE_V2PUB. create_cust_profile_amtCustomer Credit Rating HZ_PARTY_INFO_V2PUB.create_credit_ratingSales Person JTF_RS_SALESREPS_PUB.CREATE_SALESREPSales reps Territories JTF_RS_SRP_TERRITORIES_PUB.CREATE_RS_SRP_TERRITORIESCustomer contacts HZ_CUST_ACCOUNT_ROLE_V2PUB.CREATE_CUST_ACCOUNT_ROLECustomer Contact Role HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibilityVendor APIsProcedure : AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDORProcedure=> AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_SITEProcedure=> AP_PO_VENDORS_APIS_PKG.INSERT_NEW_VENDOR_CONTACTItem Import You must import items into the Item Master organization before you import items into additional organizations. You can accomplish this by specifying only your Item Master organization on a first pass […]
Data Migration is the process of transferring data between one system to another system. Data migration is required when organizations or individuals change computer systems or upgrade to new systems, or when systems merge (such as when the organizations that use them undergo a merger/takeover).To achieve an effective data migration in oracle, data on the […]
Recent Comments