Sairam Nimmagadda

Details of Order to Cash Life Cycle with Table details means joining of all tables in O2C ORDER MANAGEMENT Order Import Menu: Orders, Returns-> Import Orders->Order Import Request Program: Order Import Parameters: Order Source Order Reference Validate Only Instances Interface tables: OE_HEADERS_IFACE_ALL OE_LINES_IFACE_ALL OE_PRICE_ADJS_IFACE_ALL Error Tables: OE_PROCESSING_MSGS OE_PROCESSING_MSGS_TL Base Tables: OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL OE_PRICE_ADJUSTMENTS Oracle Order Management Interface Tables and Column Descriptions OE_HEADERS_IFACE_ALL: This is a multi-org table for sales order headers open interface. This table stores order header information that is imported from a feeder system into Oracle Order Management using Order Import. Column Description Required/Conditionally Required :--> ORDER_SOURCE_ID Order source id C ORIG_SYS_DOCUMENT_REF Original system document reference REQUIRED ORDER_SOURCE Order s...

GL Journal interface This interface lets you import journals from other applications like Receivables, Payables etc to integrate the information with General Ledger. Pre-requisites: Set of Books Flex field Value sets Code Combinations Currencies Categories Journal Sources Interface tables: GL_INTERFACE Base tables: GL_JE_HEADERS GL_JE_LINES GL_JE_BACTHES Concurrent Program: Journal Import Journal Posting --- populates GL_BALANCES Validations: Validate SOB, journal source name, journal category name, actual flag A – Actual amounts B – Budget amounts E – Encumbrance amount If you enter E in the interface table, then enter appropriate encumbrance ID, if B enter budget id. Check if accounting date or GL date based period name is valid (i.e., not closed). Check if accounting date falls in open or future open period status. Check chart of accounts id based on Sob id. Check if code combination is valid and enabled. Check if record already exists in GL interface table. Check if already journa...

Create Organization DECLARE p_organization_rec hz_party_v2pub.organization_rec_type; x_return_status VARCHAR2 (2000); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); x_party_id NUMBER; x_party_number VARCHAR2 (2000); x_profile_id NUMBER; BEGIN p_organization_rec.organization_name := 'erpschools'; p_organization_rec.created_by_module := 'ERPSCHOOLS_DEMO'; hz_party_v2pub.create_organization ('T', p_organization_rec, x_return_status, x_msg_count, x_msg_data, x_party_id, x_party_number, x_profile_id ); DBMS_OUTPUT.put_line ('party id...