ORACLE ERP & APPS TECH

Step By Step Instructions on How to create Read Only Forms/ Functions Step 1: Create Read Only Function / Forms Function:                     GLXRTDLYN                                      Form:                           Daily Rates              User Function Name:  Daily Rates New  Parameter:                   QUERY_ONLY="YES"                Type:                           Form Step 2: Create a Menu Create a new menu or add to the existing menu the above created Read only function Sequence:  60             Prompt:      Daily Rates: View Only     Function:    Daily Rates New(GLXRTDLYN) Step 3: Create Inquiry Responsibility Using the Menu Created above Create a new responsibility Add the responsibility created to the user and Navigate to the Inquiry Responsibility

How to make a column/field on FORM READ ONLY with Form Personalization. Lets take Shipping Transactions Form for demonstration purpose Navigate: Shipping Responsibility->Transactions-> Help->Diagnostics->custom code-> personalize Create new FP/ Sequence Seq: 60                 Description: Open Delivery Name: Un-Editable In this case the present sequence is 60 on this form. Ideally it advised to create sequences with interval of 5 or 10 to accommodate in between sequences for future. Apply Now  -> Save.

Tables & Queries select * from hz_customer_profiles where cust_account_id =1054; select * from apps.hz_organizations_profiles; select hca.account_name,hca.account_number,hcsu.freight_term,hcsu.site_use_code from hz_cust_accounts hca, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu where  hca.cust_account_id = hcas.cust_account_id and hcas.cust_acct_site_id =hcsu.cust_acct_site_id --and hca.cust_account_id =1054 and hcsu.site_use_code = 'BILL_TO' and hcsu.status ='A' order by 1; --TRX_num select * from apps.ra_customer_trx_all where customer_trx_id =3706; select * from apps.RA_CUSTOMER_TRX_LINES_all where customer_trx_id =3706; select * from apps.ar_adjustments_all where adjustment_number = 11002; select * from apps.AR_PAYMENT_SCHEDULES_all where payment_schedule_id =1693; select * from apps.RA_CUST_TRX_TYPES_all;

Some of the 11i table names that have changed in R12 11i R12 AP_ACCOUNTING_EVENTS_ALL  XLA_EVENTS  AP_AE_HEADERS_ALL  XLA_AE_HEADERS  AP_AE_LINES_ALL XLA_AE_LINES  AP_BANK_ACCOUNT_USES  CE_BANK_ACCT_USES_ALL AP_BANK_ACCOUNTS  CE_BANK_ACCOUNTS  && IBY_EXT_BANK_ACCOUNTS  AP_BANK_BRANCHES CEBV_BANK_BRANCHES  &&  CE_BANK_BRANCHES_V ap_inv_selection_criteria_all IBY_PAY_INSTRUCTIONS_ALL AP_CHECK_STOCKS_ALL  CE_PAYMENT_DOCUMENTS  AP_INVOICE_DISTS_MRC_V XLA_AE_LINES with APPLICATION_ID of AP Module AP_TAX_CODES_ALL  ZX_RATES_B AR_VAT_TAX_ALL_B ZX_RATES_B AX_AP_AE_HEADERS_ALL_V XLA_AE_HEADERS  AX_AP_AE_LINES_ALL_V XLA_AE_LINES AX_SLE_HEADERS XLA_AE_HEADERS  AX_SLE_LINES XLA_AE_LINES  CS_COUNTER_VALUES CSI_COUNTER_READINGS_BC_V CS_COUNTERS CSI_COUNTERS_BC_V GL_SET_OF_BOOKS GL_LEDGERS HR_O

Data flow for Order-to-Cash cycle    1. Order Entry This is first stage, When the order is entered in the system, it creates a record in order headers and Order Lines table. Enter header details: Once you enter details on the order header and save it or move it to lines, record goes to one table oe_order_headers_all flow_status_code = ENTERED, booked _ flag = N), Primary key=HEADER_ID No record exist in any other table for this order till now. Enter Line details for this order: Enter different item numbers, quantity and other details in line tab. When the record gets saved, it goes to one table. Order header details will be linked with line details by order HEADER_ID. oe _ order _ lines _ all ( flow_status_code = ENTERED, booked _ flag = N, open _ flag = Y) Primary key= LINE_ID 2.Order Booking This is next stage, when Order is booked then the Flow status changed from Entered to Booked. At this stage, these below table get

DECLARE   v_item             VARCHAR2(240) := 'AS54888';    -- item to explode   v_org               VARCHAR2(4)      := 'A11';             -- org in which item is exploded   v_cnt                NUMBER        := 0;   v_err_msg       VARCHAR2(240);   v_err_code     NUMBER        := 0;   v_item_id        NUMBER        := 1050206;           -- set to inventory_item_id of item to explode   v_org_id          NUMBER        := 0;    -- set to organization_id of item to explode   v_order_by     NUMBER        := 1;    -- DEFAULT 1   v_grp_id          NUMBER        := 0;       v_session_id   NUMBER        := 0;    -- DEFAULT 0   v_levels_to_explode NUMBER        := 1;    -- DEFAULT 1   v_bom_or_eng          NUMBER        := 1;    -- DEFAULT 1   v_explode_option     NUMBER        := 1;    -- DEFAULT 2   v_rev_date          date :=null;--VARCHAR2(240);           BEGIN   v_rev_date := TO_CHAR(SYSDATE);   -- Find org_id    SELECT mp.organiz