Home

Oracle Release Management Technical Reference Manual

1. TP_ATTRIBUTE11 ULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE12 ULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE13 ULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE14 ULL VARCHAR2 150 Trading Partner flexfield column TP ATTRIBUTE15 ULL VARCHAR2 150 Trading Partner flexfield column TP ATTRIBUTE CATEGORY ULL VARCHAR2 30 Trading Partner flexfield context column PROCESS STATUS ULL NUMBER ndicates the current processing status of a record 1 do not process 2 waiting to be processed 3 in process 4 error 5 processed 6 processed with error s for headers with lines in error Indexes Index Name Index Type Sequence Column Name RLM_SCHEDULE_HEADERS_N1 NOT UNIQUE 5 SCHEDULE_REFERENCE_NUM RLM_SCHEDULE_HEADERS_N2 NOT UNIQUE 1 CUSTOMER_ID 2 SCHEDULE_TYPE 3 SCHED_HORIZON_START_DATE RLM_SCHEDULE_HEADERS_U1 UNIQUE 5 HEADER_ID 3 50 Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual RLM_SCHEDULE_LINES_ALL Column Descriptions Name This table stores the item and item detail level information associated with customer planning shipping or production sequenced schedules For production sequence schedules the item represents the feature not the configuration This table stores all details for scheduled items dated demand authorizations and cus
2. SUB P TO CITY EXT P TO COUNTRY EXT P TO COUNTY EXT P TO NAME EXT P TO POSTAL CD EXT P TO PROVINCE EXT P TO SITE USE ID P TO STATE EXT LINE ASSIGNED ID EXT SUBLINE CONFIG CODE EXT SUB SUB SUB SUB SUB E CUST ITEM EXT E CUST ITEM ID E MODEL NUM EXT E QUANTITY E UOM CODE SUPPLIER ITEM EXT TRANSIT TIME EXT TRANSIT TIME QUAL EXT NULL NULL NULL NULL NUMBER NUMBER VARCHAR2 30 VARC AR2 3 VARCHAR2 25 VARCHAR2 60 VARCHAR2 15 VARCHAR2 10 NUMBER VARCHAR2 10 VARCHAR2 20 VARCHAR2 3 VARCHAR2 50 NUMBER VARCHAR2 35 NUMBER VARCHAR2 3 VARCHAR2 35 VARCHAR2 22 VARCHAR2 3 hip to Customer Final estination unique identifier to RA ADDRESSES nique identifier for eliver to organization which elates to SHIP TO ADDRESS ID to HR ORGANIZATIONS hip to address city as sent y the customer on the N4 egment hip to country as sent by the ustomer on the N4 segment hip to county as sent by the ustomer on the N4 segment hip to name as sent by the ustomer on the N1 or N2 egment hip to address postal code as ent by the customer on the N4 egment hip to province as sent by he customer on the N4 segment hip to Customer Site Use nique identifier FK to A SITE USES hip to state as sent by the customer on the N4 segment Subline customer ass
3. the percent of customer requirement quantity which is to be allocated to Sunday USER_MAINTAINABLE_FLAG NULL VARCHAR2 1 Y or N flag that indicates whether this seeded row can be updated by the users LAST_UPDATE_DATE NOT NULL DATE Standard Who column LAST_UPDATED_BY NOT NULL NUMBER Standard Who column CREATION_DATE NOT NULL DATE Standard Who column CREATED_BY NOT NULL NUMBER Standard Who column ATTRIBUTE_CATEGORY NULL VARCHAR2 30 Descriptive Flexfield context column ATTRIBUTE1 NULL VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE2 NULL VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE3 NULL VARCHAR2 150 Descriptive Flexfield segment column Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 63 ATTRIBUTE4 ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTES ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE6 ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE7 ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE8 ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTES ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE10 ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE11 NULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE12 ULL VARCHAR2 150 Descriptive Flex
4. VARC AR2 80 VARC AR2 80 VARC AR2 80 VARC AR2 80 VARC AR2 80 VARCHAR2 80 VARCHAR2 80 VARCHAR2 80 VARCHAR2 80 VARCHAR2 35 VARCHAR2 35 VARC AR2 35 VARC AR2 35 NUMBER NUMBER VARCHAR2 30 VARCHAR2 3 VARCHAR2 25 VARCHAR2 60 VARC AR2 15 VARC AR2 10 NUMBER VARC AR2 10 DATE Pull signal bar code label routing information line 10 Pull signal bar code label routing information line 2 Pull signal bar code label routing information line 3 Pull signal bar code label routing information line 4 Pull signal bar code label routing information line 5 Pull signal bar code label routing information line 6 Pull signal bar code label routing information line 7 Pull signal bar code label routing information line 8 Pull signal bar code label routing information line 9 hip to address line 1 as sent the customer on the N3 gment hip to address line 2 as sent the customer on the N3 gment p to address line 3 as sent the customer on the N3 gment p to address line 4 as sent the customer on the N3 gment hip to address identifier FK RA_ADDRESSES nique identifier for ship to rganization which relates to HIP TO ADDRESS ID if there is o intermediate ship to ddress or to TERMEDIATE_SHIP_TO_ID if ntermediate ship to address is pecified FK to R ORGANIZATIONS hip to address city
5. NUMBER VARCHAR2 3 VARCHAR2 3 VARCHAR2 30 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 30 VARC AR2 3 VARCHAR2 25 VARCHAR2 60 NUMBER VARCHAR2 15 VARCHAR2 10 VARCHAR2 10 VARCHAR2 80 Schedule Item Number the means to identify how item demand and information is grouped by the customer within the schedule For sequenced schedules it is equal to CUSTOMER PROD SEQ NUM For EDI planning and shipping schedules it is incremented in the EDI Gateway when each 2000 record is encountered on an inbound SPSI or SSSI transaction This number is assigned for manually entered schedules All interface lines with the same Schedule Item number are validated together and pass or fail validation as a group Customer ship delivery pattern code for this item not integrated with delivery rules for date qty calculation Customer ship delivery time code for this item not integrated with delivery rules for date qty calculation hipment delivery rule name for his schedule item Initially opulated only if a successful ode conversion in the EDI Wn ateway has occurred FK to LM_SHIP_DELIVERY_CODES HIP_FROM address line 1 as ent by the customer on the N3 egment HIP_FROM address line 2 as ent by the customer on the N3 egment HIP_FROM address line 3 as ent by the customer on the N3 egment HIP_FROM address line 4 as ent by
6. Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 7 RLM CUST IT EM CUM KEYS ALL RLM CUST ITE M TERMS ALL RLM CUST SHIPTO TERMS ALL RLM D EMAND E XC EPTIONS 2 8 This table stores the CUM key values associated with a particular ship to ship from item combination according to the CUM Management rules defined for the trading partners which are supported in Oracle Release Management If CUMManagement is enabled this table defines the entity for which a CUM would be calculated i e there is one row in this table for every bill to ship to ship from item CUM key combination The CUM key will vary by customer in additionto ship to ship from and item it could include any combination of CUM starting date Purchase Order Number or Record keeping year If CUM Management is enabled related child rows in RLM_CUST_ITEM_CUM_AD J will indicate all adjustmenttransactions between the two trading partners related to this specific customer defined accumulation grouping only e g for this PO only for this record keeping year only If CUM Management is disabled this table is not populated Inan FBO environment there would be a row for each component used for the customer since the top model number i e end item does not need cum management Rows in this table are automatically inserted as needed by the Shipping functions
7. NUMBER VARCHAR2 30 VARCHAR2 3 VARCHAR2 25 VARCHAR2 60 VARCHAR2 15 VARCHAR2 10 NUMBER Sequence Generated Unique Identifier Sequence Generated Unique Identifier foreign key to the RLM_INTERFACE_HEADERS_ALL Unique identifier for agreement on which customer purchase order is associated FK to RA AGREEMENTS Code to describe what type of data is included for the ATO item 1 Model and Options 2 Model 3 Options Validated against FND LOOKUPS LOOKUP TYPE RLM ITEM METHOD TYPE Bill To address line 1 as sent by the customer on the N3 segment Bill To address line 2 as sent by the customer on the N3 segment Bill To address line 3 as sent by the customer on the N3 segment Bill To address line 4 as sent by the customer on the N3 segment Bill To address identifier FK to RA ADDRESSES Unique identifier for invoice to organization which relates to BILL TO ADDRESS ID FK to HR ORGANIZATIONS Bill To address city as sent by the customer on the N4 segment Bill To country as sent by the customer on the N4 segment Bill To county as sent by the customer on the N4 segment Bill To Name as sent by the customer in the N1 and or N2 segment Bill To address postal code as sent by the customer on the N4 segment Bill To province as sent by the customer on the N4 segment Bill To site use identifier FK to RA SITE USES Oracle Proprietary Confidential I
8. customer on the ntermediate Ship To state as sent by the customer on the N4 ntermediate Ship To site use to RA SITE USES identifier FK TEMS Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Accounting Flexfield Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 37 NVENTORY_ITEM_SEGMENT3 NVENTORY_ITEM_SEGMENT4 NVENTORY_ITEM_SEGMENT5 NVENTORY ITEM SEGMENT6 NVENTORY ITEM SEGMENT NVENTORY ITEM SEGMENT8 NVENTORY ITEM SEGMENT9 TEM CONTACT CODE 1 TEM CONTACT CODE 2 TEM CONTACT VALUE 1 TEM CONTACT VALUE 2 TEM DESCRIPTION EXT TEM DETAIL QUANTITY TEM DETAIL REF CODE 1 TEM DETAIL REF CODE 2 TEM DETAIL REF CODE 3 TEM DETAIL REF VALUE 1 TEM DETAIL REF VALUE 2 TEM DETAIL REF VALUE 3 TEM DETAIL SUBTYPE ITEM DETAIL SUBTYPE EXT ITEM DETAIL TYPE ITEM DETAIL TYPE EXT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL VARC VARC VARC VARC VARC VARCHAR2 VARCHAR2 VARCHAR2 AR2 AR2 AR2 AR2 AR2 40 40 40 40 40 40 40 3 VARCHAR2 3 VAR
9. DE 2 LUE 1 LUE 2 HEADER REF VALUE 1 HEADER REF VALUE 2 HEADER REF VALUE 3 SCHEDULE HEADER ID SCHEDULE TYPE SCHEDULE TYPE EXT SCHED GENERATION DATE NULL NULL NULL NULL NULL NULL NULL VARCHAR2 15 VARCHAR2 15 VARCHAR2 1 VARC AR2 3 VARC AR2 3 VARCHAR2 80 VARCHAR2 80 VARC AR2 240 VARCHAR2 3 VARCHAR2 3 VARCHAR2 3 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 NUMBER NUMBER NUMBER VARCHAR2 30 VARCHAR2 30 DATE EDI control number 2 GS assigned by the customer EDI translator for audit EDI control number 3 ST assigned by the customer EDI translator for audit EDI Test Production transaction indicator T or P assigned by the customer EDI translator EDI Gateway rules determine the handling of test transactions within the Demand Processor Contact code 1 included in customer EDI transaction not validated Contact code 2 included in customer EDI transaction not validated Values associated with Contact code 1 concatenation of name communication code and communication number Values associated with Contact code 2 concatenation of name communication code and communication number Free form note text included in the schedule at the header level Reference code 1 included in customer EDI transaction Reference code 2 included in customer EDI transaction Reference code
10. MESSAGE CATEGORY ID NOT NULL NUMBER Message Category Unique Identifier MESSAGE CATEGORY NOT NULL NUMBER Message Category MESSAGE CATEGORY DESC ULL VARCHAR2 240 Message Category Description MESSAGE NAME NOT NULL VARCHAR2 30 The exception code FK to FND NEW MESSAGES CREATION DATE NOT NULL DATE Standard Who column CREATED BY NOT NULL NUMBER 15 Standard Who column LAST UPDATE DATE NOT NULL DATE Standard Who column LAST UPDATED BY NOT NULL NUMBER 15 Standard Who column LAST UPDATE LOGIN ULL NUMBER 15 Standard Who column Oracle Proprietary Confidential Information Use Restricted by Contract 3 46 Oracle Release Management Technical Reference Manual RLM_SCHEDULE_HEADERS_ALL Column Descriptions Name This table stores the header level details of the Release Management schedules It has details pertainig to the specific schedule and customer level information Release Management demand Processor uses this table to maintain a current picture of demand schedule headers Null Type Description HEADER_ID CUSTOMER_ID SCHEDULE_TYPE SCHED_HORIZON_END_DATE SCHED_HORIZON_START_DATE SCHEDULE_SOURCE zal D SCHEDULE_PURPOSE SCHEDULE_REFERENCE_NUM CUST_ADDRESS_1_EXT CUST_ADDRESS_2_EXT CUST_ADDRESS_3_EXT CUST_ADDRESS_4_EXT CUST_CITY_EXT CUST_COUNTRY_EXT CUST_COUNTY_EXT CUSTOMER_EXT CUST NAME EXT CUST POSTAL CD EXT CUST PROVINCE EXT CUST STATE EXT OT
11. NUMBER VARCHAR2 3 VARCHAR2 3 Subline customer assigned identification from the SLNOL Related to but not necessarily equivalent to the baseline number assigned identification from LINO1 For example 1 1 or 1A might be used as a subline number to relate to baseline number 1 The Subline Configuration Code as sent by the customer on the SLN segment indicating the relationship of the subline item to the baseline item Subline customer item number as sent by the customer on the SLN segment Customer Item unique identifier Subline customer model number as sent by the customer on the SLN segment he subline quantity as sent y the customer on the SLN egment he subline unit of measure internal cross referenced rom the UOM sent by the ustomer on the SLN segment to MTL UNITS OF MEASURE upplier item number specified y customer he transit time as sent by he customer on the TD5 egment he transit time qualifier as ent by the customer on the D 5 segment he shipping location ualifier as sent by the ustomer on the TD5 segment his identifies the type of ocation which specified in the orresponding shipping ocation he specific shipping location such as pool point or airport orresponding to the shipping ocation qualifier as sent by he customer on the TD5 egment This corresponds to he shipping location ualifier he transportation method as sent by the customer on the TD5 segmen
12. Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 3 Module List The Module List section briefly describes each of the Oracle Release Management applications modules This section lists forms reports and concurrent programs A form is a module comprised of closely related windows that are used together to perform a task For example the Enter Journals form in Oracle General Ledger includes the Enter Journals window the Batch window and the More Actions window The Enter Journals window is the main window and from it you can use buttons to navigate to other windows in the form The form name usually corresponds to the main window in the form and is frequently a window you can open directly from the Navigator The Reports and Concurrent Programs lists include processes you can submit from the Submit Requests window or other windows as well as processes that are submitted automatically by Oracle Release Management Use your user s guide to learn more about reports and concurrent processes Oracle Proprietary Confidential Information Use Restricted by Contract 2 4 Oracle Release Management Technical Reference Manual Database Diagramming Conventions We use the following notational conventions in our database diagrams Figure 2 1 Database Diagram Conventions Server Model Diagram Elements and Notation Title Bar Column attribute details section Relational Table
13. TERMEDIATE SHIP TO address line 4 as sent by the customer on the N3 segment TERMEDIATE SHIP TO address city as sent by the customer on the N4 segment 5 5 Oy HOS ja H Oos Oracle Proprietary Confidential Information Use Restricted by Contract NT NT TE TE TE TE TE TE TE TE TE TE TE TE TE TE TE RMD_ST_COUNTRY_EXT RMD_ST_COUNTY_EXT RMD ST NAME EXT RMD ST POSTAL CD EXT RMD ST PROVINCE EXT RMD ST STATE EXT RMD ST SITE USE ID CONTACT VA CONTACT VA DESCRIPTIO DETAIL QUA DETAIL REF CONTACT CODE 1 CONTACT CODE 2 LUE 1 LUE 2 _ EXT TETY CODE_1 DETAIL REF CODE 2 DETAIL REF CODE 3 DETAIL REF VALUE 1 DETAIL REF VALUE 2 DETAIL REF VALUE 3 NOTE TEXT ENG CNG LVL EXT MEASUREMENTS EXT VARC VARC VARC VARC VARC VARC AR2 3 AR2 25 AR2 60 AR2 15 AR2 10 AR2 10 NUMBER VARC VARC VARC VARC VARC AR2 3 AR2 3 AR2 80 AR2 80 AR2 80 NUMBER VARC VARC VARC VARC VARC VARC VARC VARC VARC AR2 3 AR2 3 AR2 3 AR2 35 AR2 35 AR2 35 AR2 35 AR2 240 AR2 240 NTERMEDIATE SHIP TO country as sent by the customer
14. You can refer to this High Level Design chapter to quickly acquaint yourself with the tables views and modules that comprise Oracle Release Management applications And you can prepare yourself to understand the detailed design and implementation of Oracle Release Management The Database Diagrams section graphically represents all Oracle Release Management applications tables and the relationships between them organized by building block Use this section to quickly learn what tables each Oracle Release Management application building block uses and how those tables interrelate Then you can refer to the Table and View Definitions sections of Chapter 3 for more detailed information about each of those tables The Table List sections list the Oracle Release Management applications tables Because a product might not include at least one table for each type this Oracle Release Management Technical Reference Manual might not include each of the following sections Public Tables Use the Public Table List section to quickly identify the tables you are most interested in Then you can refer to the Table and View Definitions sections of Chapter 3 for more detailed information about those tables In addition this manual may contain full documentation for one or more of the following Application Object Library tables FND_DUAL FND_CURRENCIES and FND_COMMON_LOOKUPS Oracle Proprietary Confidential Information Use Restricted by
15. AR2 50 Customer purchase order number AR2 30 Actual or Cumulative Validated against FND_LOOKUPS LOOKUP_TYPE RLM QTY TYPE CODE AR2 30 External value from which QTY TYPE CODE was derived in EDI Gateway Code Conversion AR2 35 Returnable container specified by customer for item shipment SCHEDULE LINE ID ULL NUMBER Schedule line unique identifier FK to RLM SCHEDULE LINES except for aggregated schedule lines ROUTING DESC EXT ULL VARCHAR2 35 The routing description as sent by the customer on the TD5 segment ROUTING SEQ CODE EXT NULL VARCHAR2 3 Code describing the relationship of a carrier toa specific shipment movement as sent by the customer on the TD5 segment CUST_PO_LINE_NUM ULL VARC CUST_PO_NUMBER NULL VARC QTY TYPE CODE ULL VARC QTY TYPE CODE EXT ULL VARC RETURN CONTAINER EXT ULL VARC Oracle Proprietary Confidential Information Use Restricted by Contract 3 40 Oracle Release Management Technical Reference Manual SCHEDULE_ITEM_NUM SHIP_DEL_PATTERN_EXT SHIP_DEL_TIME_CODE_EXT SHIP_DEL_RULE_NAME SHIP_FROM_ADDRESS_1_EXT SHIP_FROM_ADDRESS_2_EXT SHIP_FROM_ADDRESS_3_EXT SHIP_FROM_ADDRESS_4_EXT SHIP_FROM_CITY_EXT SHIP_FROM_COUNTRY_EXT SHIP_FROM_COUNTY_EXT SHIP_FROM_NAME_EXT SHIP_FROM_ORG_ID SHIP_FROM_POSTAL_CD_EXT SHIP_FROM_PROVINCE_EXT SHIP_FROM_STATE_EXT SHIP_LABEL_INFO_LINE_1 NULL NULL NULL NULL
16. For FBO Production Sequence sched les the ted by t 3rd sort key fying configurations he customer For FBO Production Sequence B u a B u identi a B schedu i a B les the ted by t 4th sort key fying configurations he customer For FBO Production Sequence schedu les the Sth sort key for for for for for identifying configurations indica Audit used w proces Audit used w ted by t trail of hen this sed trail of hen this he customer match across schedule was match within schedule was processed Audit trail exception of critical attributes key used when this schedule was processed An warning S generated if one of these is missing on Firm demand Standard Wh Standard Wh Standard Wh Standard Wh Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column o column o column o column o column flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Oracle Proprietary Confidential Information Use Restricted by Contract CREATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIB
17. Module List See Module Definitions Modules Tables used by 3 7 O Oracle7 sequences See Sequences Q QuickCodes 1 14 Columns that contain 3 4 R Report List See Report Definitions S Sequences 3 6 T Tables See also Table and View Definitions Column descriptions 3 4 Foreign keys 3 3 Indexes 3 6 Primary Keys 3 4 QuickCodes Columns 3 4 Who columns 3 5 U User Exit List See User Exit Definitions Index 1 V Views Derivation 3 7 Index 2 Oracle Application Object Library Workflow Technical Reference Manual Index 3 Index 4 Oracle Application Object Library Workflow Technical Reference Manual Reader s Comment Form Oracle Release Management Technical Reference Manual A83736 01 Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this publication Your input is an important part of the information we use for revision e Did you find any errors e ls the information clearly presented e Do you need more information If so where e Are the examples correct Do you need more examples e What features did you like most about this manual What did you like least about it If you find any errors or have any other suggestions for improvement please indicate the topic chapter and page number below Please send your comments to Oracle Applications Documentation Manager Oracle Corporation
18. Primary key column Mandatory column Recursive foreign key Pig s Ear Foreign key constraint Delete rule indicator EMPNO DEPTNO Values in the foreign key DEPTNO must match the primary key z DNAME Mandatory and Optional Foreign Keys A value entered in the column in the foreign key must match a value in the primary key column A value entered in the column in the foreign key must match either a value in the primary key column or else it must be null Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 5 2 6 Tables are the basic unit of storage in the database A hand symbol preceding the title in the table s title bar indicates that the table is not owned by this application but shared with another Foreign key constraint is a type of referential integrity constraint for checking the integrity of data entered in a specific column or set of columns This specified column or set of columns is known as the foreign key Delete rule indicator determines the action to be taken when an attempt is made to delete a related row in a join table A line through the foreign key constraint as shown on the above diagram indicates that this action is restricted Arcs specify that for any given row in a table a value must be entered in one of the arc columns The remaining columns within the arc must be null Oracle Proprietary Conf
19. SCHEDULE REFERENCE NUM SCHEDULE SOURCE REQUEST DATE START DATE TIME NDUSTRY_ATTRIBUTE1 SCHEDULE_DATE CUST_PO_NUMBER LAST_UPDATE_DATE CUSTOMER_DOCK_CODE CUST_PRODUCTION_LINE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE INVENTORY_ITEM SCHEDULE_LINE_NUMBER HORIZON_START_DATE NOT NOT NOT NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL G E E 22 zZ Z GGGGGGAAGAAAAAAG E E zZ G LL NULL VARCHAR2 30 LONG NUMBER NUMBER NUMBER NUMBER VARCHAR2 30 DATE NUMBER VARCHAR2 30 VARCHAR2 35 VARCHAR2 30 DATE DATE VARCHAR2 150 VARCHAR2 240 VARCHAR2 50 DATE VARCHAR2 35 VARCHAR2 50 UMBER DATE UMBER UMBER UMBER UMBER UMBER DATE VARCHAR2 50 UMBER DATE Actual or Cumulative Validated against FND LOOKUPS LOOKUP TYPE RLM QTY TYPE CODE Contains additional information related to the error encountered in Process Order API and specified in MESSAGE TEXT Interface header Unique Identifier Interface Line Unique Identifier This column will be null if an error or warning pertained to the schedule header Schedule header unique indentifier Schedule item unique identifier Schedule Type Planning Shipping or Sequenced Validated against FND LOOKUPS LOOKUP TYPE RLM SC
20. VARCHAR2 3 VARCHAR2 3 VARCHAR2 80 VARCHAR2 80 NUMBER NUMBER VARCHAR2 3 VARCHAR2 10 Customer part engineering change level included on schedule Item measurement information as sent by the customer on the MEA segments Free form item note text included in the schedule Reference code 1 included in customer EDI transaction Reference code 2 included in customer EDI transaction Reference code 3 included in customer EDI transaction Value associated with Reference code 1 Value associated with Reference code 2 Value associated with Reference code 3 Customer part release status included on schedule The lading quantity as sent by the customer on the TDI segment Customer letter of credit expiration date Customer letter of credit with international bank guaranteeing payment for international shipments Unique line identifier within an order for a transmission identifier Link to Immediate Parent line reference within an order for a transmission identifier Order header identifier FK to OE ORDER HEADERS Operating unit unique id FK to HR ORGANIZATION UNITS Other name code 1 included in customer EDI transaction Other name code 2 included in customer EDI transaction Values associated with Other name code 1 concatenation of name code and number Values associated with Other name code 2 concatenation of name code and number Size of supplier units in pack
21. as sent the customer on the N4 gment hip to country as sent by the ustomer on the N4 segment hip to county as sent by the tomer on the N4 segment hip to name as sent by the tomer on the N1 or N2 OK DK TI OK B D Jai DK Oo OK c n hip to address postal code as nt by the customer on the N4 hip to province as sent by he customer on the N4 segment hip to site use identifier to RA_SITE_USES Ship to state as sent by the customer on the N4 segment Customer specified date time as transmitted by the customer on the EDI transaction Hu TNNNDHNAURHRAN AV AHVUNATVN GBOEPHADNOGCANNTNNATHATHNNTN Oracle Proprietary Confidential Information Use Restricted by Contract 3 42 Oracle Release Management Technical Reference Manual SUBLINE ASSIGNED ID EXT SUBLINE CONFIG CODE EXT SUB SUB SUB SUB SUB E CUST ITEM EXT E CUST ITEM ID E MODEL NUM EXT E QUANTITY E UOM CODE SUPPLIER ITEM EXT TRANSIT TIME EXT TRANSIT TIME QUAL EXT TRANSPORT LOC QUAL EXT TRANSPORT LOCATION EXT TRANSPORT METHOD EXT UOM CODE WEIGHT EXT WEIGHT QUALIFIER EXT WEIGHT UOM EXT NULL NULL NULL NULL NULL NULL NULL VARCHAR2 20 VARCHAR2 3 VARCHAR2 50 NUMBER VARCHAR2 35 NUMBER VARCHAR2 3 VARCHAR2 35 VARCHAR2 22 VARCHAR2 3 VARCHAR2 3 VARCHAR2 35 VARCHAR2 3 VARCHAR2 3
22. as sent by the customer on the PO4 segment Number of inner pack units per out pack unit as sent by the customer on the PO4 segment Unit of measure of supplier units in the pack as sent by the customer in the P04 segment The packaging code as sent by the customer on TD1 segment Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 39 PARENT_LINK_LINE_REF NULL VARCHAR2 50 Line reference of top model for a transmission identifier for an order PRICE_LIST_ID NULL NUMBER Unique identifier for price list associated with customer item or agreement on which customer purchase order is associated FK to RA_PRICE_LISTS PRIMARY_QUANTITY NULL NUMBER Quantity in the primary UOM PRIMARY_UOM_CODE NULL VARCHAR2 3 Primary unit of measure FK to MTL_UNITS_OF_MEASURE PRIME_CONTRCTR_PART_EXT NULL VARCHAR2 35 The prime contractor part number as sent by the customer on the LIN segment of the 862 segment PROCESS_STATUS NULL NUMBER Indicates The current processing status of a record 1 do not process 2 waiting to be processed 3 in process 4 error 5 processed 6 processed with error s for headers with lines in error CUST_PO_RELEASE_NUM ULL VARCHAR2 35 Customer Purchase Order Release number included on schedule CUST_PO_DATE ULL DATE Customer specified effectivity date of Purchase Order number included on schedule AR2 35 Customer Purchase Order line number included on schedule
23. 50 50 50 50 50 50 VARCHAR2 25 NUMBER NUMBER VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 First day from the Shipping Schedule horizon start date from which demand will be considered Frozen cannot be changed Descriptive Flexfield context column Last day from the Shipping Schedule horizon start date to which demand will be considered Firm Shippable First day from the Shipping Schedule horizon start date from which demand will be considered Forecast Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Standard Who column Standard Who column Standard Who column Standard Who column Standard Who column Negative tolerance low end for changes to Customer Item demand Customer Contact FK to RA_CONTACTS Customer unique identifier FK to RA_CUSTOMERS Default freight code or carrier to be used by the demand processor to populate the freight carrier on the inbound demand This can be defaulted from the profile option RLM default carrier FK to ORG FREIGHT First day from the Planning Schedule horizon start date from which demand will be considered Firm Shippable Supplier Contac
24. CONFIGURATION KEY 2 FBO CONFIGURATION KEY 3 FBO CONFIGURATION KEY 4 FBO CONFIGURATION KEY 5 MATCH KEY ACROSS MATCH KEY WITHIN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL VARCHAR2 35 VARCHAR2 3 VARCHAR2 35 VARCHAR2 3 NUMBER VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC AR2 3 AR2 3 AR2 30 AR2 30 AR2 30 AR2 30 AR2 35 AR2 35 AR2 35 AR2 35 AR2 35 AR2 150 AR2 150 Customer Production Sequence Number The shipping location qualifier as sent by the customer on the TD5 segment This identifies the type of location which specified in the corresponding shipping location The specific shipping location such as pool point or airport corresponding to the shipping ocation qualifier as sent by he customer on the TD5 egment This corresponds to he shipping location ualifier he transportation method as ent by the customer on the TD5 egment he weight as sent by the ustomer on the TD1 segment he weight qualifier as sent y the customer on the TDI egment The unit of measure corresponding to shipment weight as sent by the customer on the TD1 segment External value from which ITEM DETAIL SUBTYPE was derived in EDI Gateway Code Conversion External value from which ITEM DETAIL TYPE
25. Contract 2 2 Oracle Release Management Technical Reference Manual View Lists Internal Tables This section includes a list of private internal tables used by Oracle Release Management we do not provide additional documentation for these tables The View List sections list the Oracle Release Management views with one section for each type of view Because a product might not include at least one view for each type this Oracle Release Management Technical Reference Manual might not include each of the following sections Use this section to quickly identify the views you are most interested in Then you can refer to the Table and View Definitions sections of Chapter 3 for more detailed information about those views Public Views This section lists views that may be useful for your custom reporting or other data requirements The list includes a description of the view and the page in Chapter 3 that gives detailed information about the public view Web Views This section lists views that you may need to configure your Self Service Web applications The list includes a description of the view and the page in Chapter 3 that gives detailed information about the web view Internal Views This section includes each private internal view that Oracle Release Management uses Multiple Reporting Currency Views This list includes views that were created to support the Multiple Reporting Currencies feature
26. Flexfield segment column Descriptive Flexfield segment column Standard Who column Standard Who column Standard Who column Standard Who column Standard Who column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Trading Partner Flexfield segment column Unique identifier of a line within a schedule Unique identifier for intermediate ship to organization which relates to INTERMEDIATE_SHIP_TO_ID if intermediate ship to address is specified FK to HR_ORGANIZATIONS Schedule Source at line level since lines can also be manually entered PREFERRED_GRADE NULL VARCHAR2 4 Preferred Grade Index Name Index Type Sequence Column Name RLM LINES INTERFACE Ul UNIQUE 5 LINE ID Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 45 RLM MESSAGE CATEGORY Column Descriptions Name Null Type Description
27. Information Use Restricted by Contract Detailed Design 3 29 RLM_INTERFACE_HEADERS_ALL Column Descriptions Name This table stores the header level details of the Release Management schedules It has details pertainig to the specific schedule and customer level information EDI Gateway will feed into this table for the demand transactions of Planning Shipping and Sequenced Schedules Null Type Description HEADER_ID CUST_ADDRESS_1_EXT CUST_ADDRESS_2_EXT CUST_ADDRESS_3_EXT CUST_ADDRESS_4_EXT CUST_CITY_EXT CUST_COUNTRY_EXT CUST_COUNTY_EXT CUSTOMER_EXT CUST NAME EXT CUST POSTAL CD EXT CUST PROVINCE EXT CUST STATE EXT CUSTOMER ID ECE PRIMARY ADDRESS ID ECE TP LOCATION CODE EXT ECE TP TRANSLATOR CODE EDI CONTROL NUM 1 NOT NULL NULL NULL NULL NUMBER VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC AR2 35 AR2 35 AR2 35 AR2 35 AR2 30 AR2 3 AR2 25 AR2 30 AR2 20 AR2 15 AR2 10 AR2 10 NUMBER NUMBER VARCHAR2 35 VARCHAR2 35 VARCHAR2 15 Sequence Generated Unique Identifier Customer address line 1 sent by the customer on the N3 segment Customer address line 2 sent by the customer on the N3 segment Customer address line 3 sent by the customer on the N3 segment Customer address line 4 sent by the customer on the N3 se
28. Module A module is a program or procedure that implements one or more business functions or parts of a business function within an application Modules include forms concurrent programs and reports and subroutines Application Building Block An application building block is a set of tables and modules forms reports and concurrent programs that implement closely related database objects and their associated processing Said another way an application building block is a logical unit of an application QuickCodes QuickCodes let you define general purpose static lists of values for window fields QuickCodes allow you to base your program logic on lookup codes while displaying user friendly names in a list of values Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 7 window QuickCodes simplify name and language changes by letting you change the names your end users see while the codes in your underlying programs remain the same Form A form is a module comprised of closely related windows that are used together to perform a task For example the Enter Journals form in Oracle General Ledger includes the Enter Journals window the Batch window and the More Actions window among others The Enter Journals window is the main window and from it you can use buttons to navigate to other windows in the form The form name usually corresponds to the main window in the form a
29. NUMBER NUMBER NUMBER VARCHAR2 30 VARCHAR2 30 VARCHAR2 1 DATE DATE Ship From Customer Item Unique Identifier Customer Item unique identifier FK to MTL CUSTOMER ITEMS Ship from organization unique identifier FK to RLM CUST SHIPTO TERMS ALL Address unique identifier FK to RLM CUST SHIPTO TERMS ALL Unique identifier of the sales order to which the customer item is linked Demand for this item is placed this sales order by the Release Management demand processor It will be cleared if the Sales Order is purged FK to OE ORDER HEADERS The Pricing Agreement contract with the customer The Demand Stream Processor will use this to determine Customer PO Number and pricing FK to SO_AGREEMENTS The future Pricing Agreement contract with the customer to be used when the current Pricing Agreement expires The Demand Stream Processor will use this to determine Customer PO Number and pricing FK to SO_AGREEMENTS Flag to indicate if the ship from is under cum management whether or not cums should be calculated for this particular item Current CUM calculation starting date if CUM_CONTROL_CODE CUM_UNTIL_MANUAL_RESET Previous CUM calculation starting date if CUM_CONTROL_CODE CUM_UNTIL_MANUAL_RESET To be used in building the CUM key if shipment date is earlier than Current CUM calculation starting date Oracle Proprietary Confidential Information Use Restricted by Co
30. ORIGIN EXT NULL VARC CUST ASSEMBLY EXT NULL VARC CUST ASSIGNED ID EXT NULL VARC CUST BILL TO EXT NULL VARC CUST CONTRACT NUM EXT NULL VARC CUSTOMER DOCK CODE NULL VARC Oracle Proprietary Confidential Information Use Restricted by Contract 3 52 Oracle Release Management Technical Reference Manual CUST_INTRMD_SHIP_TO_EXT CUST_ITEM_PRICE_EXT CUST_ITEM_PRICE_UOM_EXT CUSTOMER_ITEM_REVISION CUSTOMER_JOB CUST_MANUFACTURER_EXT CUST_MODEL_NUMBER_EXT CUST MODEL SERIAL NUMBER CUST ORDER NUM EXT CUST PROCESS NUM EXT CUST PRODUCTION LINE CUST SET NUM EXT CUST SHIP FROM ORG EXT CUST SHIP TO EXT CUST UOM EXT END DATE TIME EQUIPMENT CODE EXT EQUIPMENT NUMBER EXT HANDLING CODE EXT HAZARD CODE EXT HAZARD CODE QUAL EXT HAZARD DESCRIPTION EXT IMPORT LICENSE DATE EXT NULL NULL NULL VARCHAR2 35 NUMBER VARC AR2 3 VARC AR2 3 VARC VARC AR2 35 AR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARC VARC AR2 35 AR2 35 VARCHAR2 80 VARCHAR2 35 VARCHAR2 10 DATE VARCHAR2 3 VARCHAR2 35 VARC AR2 3 VARCHAR2 10 VARCHAR2 3 VARCHAR2 80 DATE External Intermediate ship to Cross Reference Price included on the customer EDI transaction UOM corresponding to the price included ont eh customer EDI transaction Customer part revisi
31. Stream Processor has new immediate firm demand since this type of demand cannot be accurately matched by date quantity Validated against FND LOOKUPS LOOKUP TYPE RLM FIRM DISP CODE Flag that indicates whether you want to used the ship delivery pattern code that the customer sends in on the EDI transactions if it is populated Positive tolerance high end for changes to Customer Item demand Negative tolerance low end for changes to Customer Item demand Date when this ship from ship to terms relationship is no longer active Unique identifier of the default sales order to which the customer item is linked Demand for items is placed on this sales order by the Release Management demand processor unless a different SO is specified at the ship from customer item level It will be cleared if the Sales Order is purged FK to OE_ORDER_HEADERS Operating unit unique ID FK to HR_ORGANIZATION_UNITS Unique identifier for default price list associated with this ship from ship to relationship if pricing agreement contract is not used FK to RA_PRICE_LISTS ASCII string of characters which identify the optional matching attributes which are enabled as critical attributes which must contain a value for the Demand Processor An exception warning will be generated if one of these is missing on Firm demand Customer Contact FK to RA_CONTACTS First day from the Planning Schedule horizon start date from which deman
32. Use Restricted by Contract Contents iii Oracle Proprietary Confidential Information Use Restricted by Contract iv Oracle Release Management Technical Reference Manual CHAPTER Introduction he Oracle Release Management Technical Reference Manual provides T the information you need to understand the underlying structure of Oracle Release Management After reading this manual you should be able to convert your existing applications data integrate your existing applications with your Oracle Release Management application and write custom reports for your Oracle Release Management application as well as read data that you need to perform other tasks This chapter introduces you to the Oracle Release Management Technical Reference Manual and explains how to use it Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 1 Introduction At Oracle we design and build applications using Oracle Designer our systems design technology that provides a complete environment to support developers through all stages of a systems life cycle Because we use a repository based design toolset all the information regarding the underlying structure and processing of our applications is available to us online Using Oracle Designer we can present this information to you in the form of a technical reference manual This Oracle Release Management Technical Reference Manual contains detailed up to date
33. VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC AR2 4 AR2 4 AR2 4 AR2 4 AR2 4 AR2 4 AR2 4 4 4 4 4 4 4 AR2 AR2 AR2 AR2 AR2 AR2 OO OOO Oo Oo OO Oo o 0 Industry Descriptive Flexfield Industry Descriptive Flexfield Industry Descriptive Flexfield Industry Descriptive Flexfield Industry Descriptive context Flexfield Customer Intermediate Ship to Destination unique identifier FK to RA_ADDRESSES Unique identifier for ship to organization which relates to SHIP_TO_ADDRESS_ID AR ORGANIZATIO as sent by the N4 segment segment as sent by the N4 segment segment identifier FK nventory item to MTE SYSTEM ntermediate Ship line 1 as sent by the customer on the N3 segment ntermediate Ship line 2 as sent by the customer on the N3 segment ntermediate Ship line 3 as sent by the customer on the N3 segment ntermediate Ship line 4 as sent by the customer on the N3 segment ntermediate Ship city as sent by the customer on the N4 segment ntermediate Ship ntermediate Ship To sent by the customer in the N1 and or N2 segment ntermediate Ship To address postal code as sent by the customer on the N4 segment ntermediate Ship To province FK to S o adaress o adaress o adaress o address 0 address 0 country customer on the ntermediate Ship To county as sent by the customer on the N4 Name as
34. When a database column contains a QuickCodes value which we implement using a foreign key to FND_LOOKUPS MFG_LOOKUPS or to some other lookup table we list the QuickCodes type lookup Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 3 type to which the QuickCodes value must belong and a complete list of QuickCodes values and meanings Some QuickCodes can be defined by you in the application These values are designated as User defined Column Descriptions We list the important characteristics of each column in a table or view These characteristics include whether the column is part of the table s primary key whether Oracle8i requires a value for this column and the data type of the column We also give you a brief description of how your Oracle Release Management application uses the column When a column is part of a table s primary key we append the notation PK to the name of that column To help you understand which columns your Oracle Release Management application uses and which columns it does not use we alert you to any unused column When no module uses a database column we show one of the following legends in the Description column Not currently Your Oracle Release Management application does used not use this column although the column might be used in a future release No longer used Your Oracle Release Management application no longer uses this column Au
35. for demand consumption from PLN SHP SEQ schedule Validated against FND LOOKUPS LOOKUP TYPE RLM SCHEDULE HIERARCHY Mandatory at Customer level Comments related to the Organization relationship to the Customer Ship To Address or Customer Item Optional at all levels Standard Who column Standard Who column Standard Who column Standard Who column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Descriptive Flexfield context column Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 23 3 24 ATTRIBUTE9 U ATTRIBUTE10 U ATTRIBUTE11 U ATTRIBUTE12 U ATTRIBUTE13 U ATTRIBUTE14 U ATTRIBUTE15 U LAST UPDATE LOGIN NU REQUEST ID NU PROGRAM APPLICATION ID U PROGRAM ID U PROGRAM UPDATE DATE U TP ATTRIBUTEL U TP ATTRIBUTE2 NU TP ATTRIBUTE3 U TP_ATTRIBUTE4 U TP_ATTRIBUTES NU TP_ATTRIBUTE6 U TP_ATTRIBUTE7 NU TP_ATTRIBUTE8 NU TP ATTRIBUTE9 NU TP ATTRIBUTE10 NU TP_ATTRIBUTE11 NU TP_ATTRIBUTE12 U TP_ATTRIBUTE13 U TP_ATTRIBUTE14 NU TP_ATTRIBUTE15 U TP_ATTRIBUTE_CATEGORY U MATCH_ACROSS_KEY NU VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150
36. not use this manual to plan modifications You should not use this manual to plan modifications to your Oracle Release Management application Modifying Oracle Release Management limits your ability to upgrade to future releases of your Oracle Release Management application In addition it interferes with our ability to give you the high quality support you deserve We have constructed your Oracle Release Management application so that you can customize it to fit your needs without programming and you can integrate it with your existing applications through interface tables However should you require program modifications you should contact our support team see Other Information Sources page 1 8 They can put you in touch with Oracle Services the professional consulting organization of Oracle Their team of experienced applications professionals can make the modifications you need while ensuring upward compatibility with future product releases Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 5 Do not write data into non interface tables Oracle reserves the right to change the structure of Oracle Applications tables and to change the meaning of add or delete lookup codes and data in future releases Do not write data directly into or change data in non interface tables using SQL Plus or other programming tools because you risk corrupting your database and interfering with our abili
37. on the N4 segment NTERMEDIATE SHIP TO county as sent by the customer on the N4 segment NTERMEDIATE SHIP TO Name as sent by the customer in the N1 and or N2 segment NTERMEDIATE SHIP TO address postal code as sent by the customer on the N4 segment NTERMEDIATE SHIP TO province as sent by the customer on the N4 segment NTERMEDIATE SHIP TO state as sent by the customer on the N4 segment ntermediate ship to site use identifier FK to RA SITE USES Contact code 1 included in customer EDI transaction Contact code 2 included in customer EDI transaction Values associated with Contact code 1 concatenation of name communication code and communication number Values associated with Contact code 2 concatenation of name communication code and communication number Item description included on schedule Requested quantity If Item Detail Type 0 1 2 this is the demand quantity If Item Detail Type 3 this is the authorization quantity If Item Detail Type 4 this is the shipped received or cum quantity f Item Detail Type 5 this is a miscellaneous quantity such as ahead behind inventory balance etc Reference code 1 included in customer EDI transaction Reference code 2 included in customer EDI transaction Reference code 3 included in customer EDI transaction Value associated with Reference code 1 Value associated with Reference code 2 Value associated with Reference code 3 Cust
38. operating unit query the _ALL table For example if you are running a cross organization report you probably want to query the ALL table However if you want to report against only a single organization or operating unit query the corresponding cross organizational view using the familiar 10 6 style table name The view definition will automatically retrieve only data for your current operating unit Additional Information Multiple Organizations in Oracle LE Applications Oracle Release Management uses the following Single Organization views RLM CUST ITE Q UM ADJ RLM CUST ITEM CUM KEYS RLM CUST ITE TERMS RLM INTERFACE HEADERS RLM INTERFACE LINES Oracle Proprietary Confidential Information Use Restricted by Contract 2 12 Oracle Release Management Technical Reference Manual Module List This section lists each form report and concurrent program comprising Oracle Release Management Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 13 Oracle Proprietary Confidential Information Use Restricted by Contract 2 14 Oracle Release Management Technical Reference Manual FEE Detailed Design CHAPTER his chapter presents a detailed design for implementing Oracle T Release Management It contains detailed definitions of tables and views that y
39. ormanually entered in the CUM Adjustment Transaction form This table has a child relationship to RLM_SHIP_FROM_CUST_ITEMS and a parent relationship to RLM_CUST_ITEM_CUM_AD J See page 3 10 This table contains new R 12 customer item attributes which are dependent upon the Ship From Customer Item relationship Some attributes from Phase 1 were carried forward from VEH_MTL_CUSTOMER_ITEMS which is being eliminated in Phase2 See page 3 14 This table contains new R 12 customer address attributes which are dependent upon the ship from ship to relationship Some attributes from Phase 1 were carried forward from VEH_RA_ADDRESSES which is being eliminated in Phase2 See page 3 19 This table contains Release Management Exception records See page 3 26 Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual RLM_INT ERFACE HEADERS_ALL RLM_INT ERFACE LIN ES ALL RLM MESSAGE RLM SCHE CATEGORY DULE ERS ALL RLM SCHE DULE LINES ALL RLM SHIP DEL RLM UI QUERIE IVERY CODES This table stores the header level details of the Release Management schedules It has details pertainig to the specific schedule and customer level information EDI Gateway will feed into this table for the demand transacti
40. other measures to ensure the safe use of such applications if the Programs are used for such purposes and Oracle disclaims liability for any damages caused by such use of the Programs Restricted Rights Legend This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are commercial computer software and use duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement Otherwise this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are restricted computer software and use duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52 227 14 Rights in Data General including Alternate III June 1987 Oracle Corporation 500 Oracle Parkway Redwood City CA 94065 Oracle is a registered trademark and CASE Exchange Enabling the Information Age Hyper SQL NLS Workbench Oracle7 Oracle8 Oracle 8i Oracle Access Oracle Application Object Library Oracle Discoverer Oracle Financials Oracle Quality Oracle Web Customers Oracle Web Employees Oracle Work in Process Oracle Workflow PL SQL Pro Ada Pro C Pro COBOL Pro FORTRAN Pro Pascal Pro PL I SmartClient SQL Connect SQL Forms SQL Loader SQL Menu SQL Net SQL Plus and SQL Report are trademarks or registere
41. which are used in Release Workbench It stores information about the Query such as the Owner of the Query whether Query can be deleted or not Seepage 3 66 Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 9 RLM_UI_QUERY_COLUMNS This table stores the details of Query Criteria for each of the Query in RLM_UI_QUERIES See page 3 67 Oracle Proprietary Confidential Information Use Restricted by Contract 2 10 Oracle Release Management Technical Reference Manual Forms and Table View List This section lists supplementary views that are not essential to the Release 11i data model but simplify coding or improve performance of Developer For example many of these views are used as base tables in Oracle Release Management forms A Warning We do not recommend you query or alter data using these views Furthermore these views may change dramatically in subsequent minor or major releases of Oracle Release Management Oracle Release Management uses the following Forms and Table views RLM CUM ADJ DETAILS V RLM CUM SHIPFR CUST ITEMS V RLM CUM SHIPFR SHIPTO V RLM CUM SHIP DETAILS V RLM CUM SITE USES V RLM CUSTOMERS V RLM CUSTOMER TE
42. 14 ATTRIBUTE15 LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE TP ATTRIBUTEL TP ATTRIBUTE2 TP ATTRIBUTE3 TP_ATTRIBUTE4 TP_ATTRIBUTES TP_ATTRIBUTE6 TP_ATTRIBUTE7 TP_ATTRIBUTE8 NOT NOT NOT NOT NULL et E o eee ae Gaqaqaa qaqaqaaqaqaag E G VARCHAR2 150 DATE NUMBER DATE NUMBER VARCHAR2 30 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 NUMBER NUMBER NUMBER NUMBER DATE VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 Audit trail of critical attributes key used when this schedule was processed An exception w generated if one of these is missing on Firm demand Standard Who Standard Who Standard Who Standard Who Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column tive tive tive tive tive tive tive tive tive tive tive tive tive tive tive tive Standard Who
43. 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 NUMBER NUMBER NUMBER NUMBER DATE VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 30 Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Standard Who Standard Who Standard Who Standard Who Standard Who Flexfield Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie Flexfie column column column column column segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield ner Flexfield Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment colum
44. 3 included in customer EDI transaction Value associated with Reference code 1 Value associated with Reference code 2 Value associated with Reference code 3 Operating unit unique ID FK to HR ORGANIZATION UNITS Indicates the current processing status of a record 1 do not process 2 waiting to be processed 3 in process 4 error 5 processed 6 processed with error s for headers with lines in error Schedule header unique identifier FK to RLM_SCHEDULE_HEADERS Schedule Type Planning Shipping or Sequenced Validated against FND_LOOKUPS LOOKUP_TYPE RLM_SCHEDULE_TYPE E R L D T fan xternal value from which LM SCHEDULE TYPE was derived n EDI Gateway Code Conversion ate customer generated either he schedule or the planning information on the schedule Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 31 SCHED_HORIZON_END_DATE NULL DATE Schedule horizon end date to be derived based on demand contained within the schedule if not specified SCHED_HORIZON_START_DATE NULL DATE Schedule horizon start date to be derived based on demand contained within the schedule if not specified SCHEDULE_PURPOSE NULL VARCHAR2 30 Schedule purpose code i e Original Replace Cancellation etc Validated against FND_LOOKUPS LOOKUP_TYPE RLM_SCHEDULE_PURPOSE SCHEDULE_PURPOSE_EXT NULL VARCHAR2 30 External va
45. 4 segment external value Name as sent by the in the N1 and or N2 Customer Customer customer segment Customer address postal code as sent by the customer on the N4 segment Customer province as sent by the customer on the N4 segment Customer state as sent by the customer on the N4 segment Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 47 ECE PRIMARY ADDRESS ID ECE TP LOCATION CODE EXT ECE TP TRANSLATOR CODE EDI CONTROL NUM 1 EDI CONTROL NUM 2 EDI CONTROL NUM 3 EDI TEST INDICATOR HEADER CONTACT CODE 1 HEADER CONTACT CODE 2 HEADER CONTACT VALUE 1 HEADER CONTACT VALUE 2 HEADER NOTE TEXT HEADER REF CODE 1 HEADER REF CODE 2 HEADER REF CODE 3 HEADER REF VALUE 1 HEADER REF VALUE 2 HEADER REF VALUE 3 ORG ID SCHEDULE TYPE EXT SCHED GENERATION DATE SCHEDULE PURPOSE EXT NU NU NU NU NU NU NU NU NU NU NU NU NU NU NU NUMBER VARC AR2 35 VARC AR2 35 VARCHAR2 15 VARCHAR2 15 VARCHAR2 15 VARCHAR2 1 VARCHAR2 3 VARCHAR2 3 VARC AR2 80 VARC AR2 80 VARCHAR2 240 VARCHAR2 3 VARCHAR2 3 VARCHAR2 3 VARC AR2 35 VARC AR2 35 VARC AR2 35 NUMBER VARCHAR2 30 DATE VARCHAR2 30 Customer Primary Address ID populated by EDI Gateway code conver
46. 50 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 Standard Who Standard Who Standard Who Standard Who Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Standard Who Standard Who Standard Who Standard Who Standard Who Trading Part column Trading Part column Trading Part column Trading Part column Trading Part column Trading Part column Trading Part column Trading Part column Trading Part column Trading Part column column column column column Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield column column column column column context segment segment segment segment segment segment segment segment segment segment segment segment segment segment segment ner flexfield ner flexfield ner flexfield ner flexfield ner flexfield ner flexfield ner flexfield ner flexfield ner flexfield ner flexfield Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 49
47. 500 Oracle Parkway Redwood Shores CA 94065 USA Phone 650 506 7000 Fax 650 506 7200 If you would like a reply please give your name address and telephone number below Thank you for helping us improve our documentation CAUTION This document contains proprietary confidential information that is the exclusive property of Oracle Corporation If you are an Oracle customer this numbered copy is registered in your site s name Use duplication and disclosure are severely restricted and subject to restrictions stated in your contract with Oracle Corporation If you are an Oracle employee this numbered copy is registered in your name and must be returned if you leave the company It is your responsibility not to disclose this information to anyone outside of Oracle who is not licensed to use this product If you have a prospect who needs to see this information contact mailid APPSAPP to obtain a special nondisclosure agreement If you are neither an Oracle customer with a valid contract for the use of this document nor an Oracle employee then you received this document in an unauthorized manner and are not legally entitled to possess or read it Please return it immediately to Oracle You may call collect to the office of the Executive Vice President Applications Division to arrange its return Copy ORACLE TO 9ELE8Y NU MA O
48. AR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 30 NUMBER NUMBER VARCHAR2 30 NUMBER VARCHAR2 4 Sequence rading Partner flexfield segment column 1 Partner flexfield column Partner flexfield column Partner flexfield column Partner flexfield column Partner flexfield column Partner flexfield column Trading Partner flexfield context column ntermediate ship to address line 1 as sent by the customer on the N3 segment Unique identifier for intermediate ship to organization which relates to INTERMEDIATE SHIP TO ID if intermediate ship to address is specified FK to HR ORGANIZATIONS Schedule source for individual line since lines can entered manually too Unique Order Header identifier indicating the Order that the schedule line is linked to FK to OE ORDER HEADERS Preferred Grade radin segmen radin segmen radin segmen ta tQ taQ radin segmen radin segmen AQ IQ radin segmen TO AQ c Column Name RLM_SCHEDULE_LINE_N1 RLM_SCHEDULE_LINE_U1 NOT UNIQUE 5 NOT UNIQUE 5 HEADER ID LINE ID Oracle Proprietary Confidential Information Use Restricted by Contract 3 62 Oracle Release Management Technical Reference Manual RLM_SHIP_DELIVERY_CODES This table stores the optional Shipment Delivery Pattern Rules which can then be associated with the customer item destination They are used in the Demand Stre
49. Applications wide post install tasks Using the AD Utilities This manual contains how to steps screen shots and other information required to run the various AD utilities such as Autolnstall AutoPatch AD Administration AD Controller Relink and so on It also contains information about when and why you should use these utilities Upgrading Oracle Applications This manual contains all the product specific pre and post upgrade steps that are required to upgrade products from Release 10 7 NCA SC and character mode or Release 11 of Oracle Applications This manual also contains an overview chapter that describes all the tasks necessary to prepare and complete a upgrade of Oracle Applications Oracle Applications System Administrator s Guide This manual provides planning and reference information for the Oracle Applications System Administrator It contains information on how to define security customize menus and manage concurrent processing Oracle Applications Product Update Notes This book contains a summary of each new feature we added since Release 11 as well as information about database changes and seed data changes that may affect your operations or any custom reports you have written If you are upgrading from Release 10 7 you also need to read Oracle Applications Product Update Notes Release 11 Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 11 Other Inf
50. CHAR2 80 VARCHAR2 80 VARC AR2 80 NUMBER VARCHAR2 3 VARCHAR2 3 VARCHAR2 3 VARCHAR2 35 VARC AR2 35 VARC AR2 35 VARC AR2 30 VARCHAR2 30 VARCHAR2 30 VARCHAR2 30 Accounting Flexfiel Accounting Flexfiel Accounting Flexfiel Accounting Flexfiel Accounting Flexfiel Accounting Flexfiel Accounting Flexfiel Contact code 1 included in customer EDI transaction Contact code 2 included in customer EDI transaction Values associated with Contact code 1 concatenation of name communication code and communication number Values associated with Contact code 2 concatenation of name communication code and communication number Item description included on schedule Requested quantity If Item_Detail_Type 0 1 2 this is the demand quantity If Item_Detail_Type 3 this is the authorization quantity If Item_Detail_Type 4 this is the shipped received or cum quantity If Item_Detail_Type 5 this is a miscellaneous quantity such as ahead behind inventory balance etc Reference code 1 included in customer EDI transaction Reference code 2 included in customer EDI transaction Reference code 3 included in customer EDI transaction Value associated with Reference code 1 Value associated with Reference code 2 Value associated with Reference code 3 Schedule item detail row sub type For form or forecast demand Bucket type associated
51. ECAST_DAY_TO ULL NUMBER SEQ_MRP_FORECAST_DAY_FROM ULL NUMBER SEQ_MRP_FORECAST_DAY_TO NULL NUMBER Indexes Index Name Index Type Sequence Column Name RLM_CUST_ITEM_TERMS_N1 NOT UNIQUE 5 CUSTOMER_ITEM_ID RLM CUST ITEM TERMS Ul UNIQUE 5 CUST ITEM TERMS ID RLM CUST ITEM TERMS U2 NOT UNIQUE 1 CUSTOMER ITEM ID 2 SHIP FROM ORG ID 3 CUSTOMER ID 4 ADDRESS ID Oracle Proprietary Confidential Information Use Restricted by Contract 3 18 Oracle Release Management Technical Reference Manual RLM_CUST_SHIPTO_TERMS_ALL Column Descriptions Name This table contains new R 12 customer address attributes which are dependent upon the ship from ship to relationship Some attributes from Phase 1 were carried forward from VEH RA ADDRESSES which is being eliminated in Phase 2 This table has one row for each ship from location associated with a ship to address Type Description CUST SHIPTO TERMS ID ADDRESS ID CUSTOMER ID SHIP FROM ORG ID CUM CONTROL CODE SHIP METHOD INTRANSIT TIME TIME UOM CODE SHIP DELIVERY RULE NAME CUM CURRENT RECORD YEAR CUM PREVIOUS RECORD YEAR CUM CURRENT START DATE NOT NOT NOT NULL NULL NULL NULL NULL NULL NULL NUMBER NUMBER NUMBER NUMBER VARCHAR2 30 VARCHAR2 30 NUMBER VARCHAR2 3 VARCHAR2 30 VARCHAR2 35 VARCHAR2 240 DATE Customer Ship To Terms Identifier Ship To Address unique identifier FK to RA ADDRES
52. G VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 NUMBER NUMBER NUMBER NUMBER DATE VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 30 Descrip column Descrip column Descrip column Descrip column Descrip column Descrip column tive tive tive tive tive tive Standard Who Standard Who Standard Who Standard Who Standard Who Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment partner fl column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield column partner flexfield F F F Fl F F lexfield lexfield lexfield exfield lexfiel
53. HEDULE TYPE Date customer generated either the schedule or the planning information on the schedule Schedule Item Numbe the means to identify how item demand and information is grouped by the customer within the schedule Schedule purpose code i e Original Replace Cancellation etc Validated against FND LOOKUPS LOOKUP TYPE RLM SCHEDULE PURPOSE Customer assigned schedule reference or release number EDI or manual transaction source for this schedule i e 830 862 866 DELFOR MANUAL etc Request Date Customer specified date time as transmitted by the customer on the EDI transaction Industry Attributel Also Customer Record Year Schedule Date Customer Purchase Order Number Standard who column Customer Dock Code Customer Production Line Standard Who column Standard Who column Standard Who column Standard Who column Request Identifier Standard Who column Standard Who column Inventory Item Number Schedule Line Number Horizon Start Date Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual HORIZON_END_DATE NULL DATE Horizon End Date ORDER_HEADER_ID NULL NUMBER Order Header Identifier ORDER_LINE_ID NULL NUMBER Order Line Identifier Indexes Index Name Index Type Sequence Column Name RLM_DEMAND_EXCEPTIONS_N1 NOT UNIQUE 2 REQUEST_ID RLM_DEMAND_EXCEPTIONS_U1 UNIQUE 2 EXCEPTION_ID Oracle Proprietary Confidential
54. IBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTES ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 NOT NOT NOT NOT NULL VARCHAR2 30 NULL NUMBER NULL VARCHAR2 30 NULL NULL NULL GGGGG E E NUMBER VARCHAR2 240 VARCHAR2 240 NUMBER DATE DATE NUMBER VARCHAR2 30 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 The default Pricing Agreement contract associated with this ship from ship to relationship The Demand Processor will use this to determine Customer PO Number and pricing unless a different Pricing Agreement is specified at the ship from customer item level FK to SO AGREEMENTS This If the requirements should be rounded up to standard packs in the Demand Processor the quantity per pack expressed in the customer UOM The future default Pricing Agreement contract associated with this ship from ship to relationship to be used when the current Pricing Agreement expires The Demand Processor will use this to determine Customer PO Number and pricing if demand is dated after the expiration date of the current Pricing Agreement unless a different future Pricing Agreement is specified at the ship from customer item level FK to SO AGREEMENTS First day from the Shipping Schedule horizon start date from which demand will be considered Forecast Hierarchy of schedule types
55. L NULL NULL qaqaqaa 3 E NUMBER NUMBER DATE VARCHAR2 35 NUMBER VARCHAR2 50 VARCHAR2 3 NUMBER NUMBER NUMBER DATE DATE NUMBER DATE NUMBER VARCHAR2 30 VARCHAR2 150 VARCHAR2 150 Intermediate Ship to Address unique ID if the customer side CUM Org Level defined for the Ship from Ship to relationship to which this cum key belongs is Intermediate Ship to One of the three address Ids Ship to Bill to or Intermediate Ship to must be specified Ship from organization unique ID FK to MTL_PARAMETERS Null only if CUM Org Level is SHIP_TO_ALL_SHIP_FROMS S I N hip from organization unique D FK to MTL PARAMETERS ull only if CUM Org Level is SHIP TO ALL SHIP FROMS If CUM management is being done with Record keeping year significance the specific record keeping year associated with the cum period Operating unit unique ID FK to HR ORGANIZATION UNITS If CUM management is being done with purchase order significance the specific PO to which this CUM belongs Unit of measure used for CUM calculations related to this CUM Key FK to MTL UNITS OF MEASURE Indicates CUM calculated quantity as per shipment inclusion rule This column can be used directly without any further processing to display current CUM Indicates all shipments made for this CUM Key which are not included in CUM QTY due to shipment inclusion rule and not include
56. L_UNITS_OF_MEASURE Primary unit of measure FK to MTL_UNITS_OF_MEASURE Oracle Proprietary Confidential Information Use Restricted by Contract PRIME CONTRCTR PART EXT PROCESS STATUS PULLSIGNAL END SERIAL PULLSIGNAL REF NUM PULLSIGNAL START SERIAL CUST PO RELEASE NUM CUST PO DATE CUST PO LINE NUM CUST PO NUMBER RETURN CONTAINER EXT ROUTING DESC EXT ROUTING SEQ CODE EXT SCHEDULE ITEM NUM SHIP DEL PATTERN EXT SHIP DEL TIME CODE EXT SHIP FROM ADDRESS 1 EXT NULL NULL NULL NULL NULL NULL VARCHAR2 35 NUMBER VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 DATE VARCHAR2 35 VARCHAR2 50 VARCHAR2 35 VARCHAR2 35 VARC AR2 3 NUMBER VARCHAR2 3 VARCHAR2 3 VARCHAR2 35 The prime contractor part number as sent by the customer on the LIN segment of the 862 segment Indicates the current processing status of a record 1 do not process 2 waiting to be processed 3 in process 4 error 5 processed 6 processed with error s for headers with lines in error Pull Signal Ending Serial Number Pull Signal Reference Number Pull Signal Starting Serial Number Customer Purchase Order Release number included on schedule Customer specified effectivity date of Purchase Order number included on schedule Customer Purchase Order line number included on schedule Customer Purchase Order number inclu
57. NU NU NU NU NU NU NU NU NU NU NU NU NU UMBER UMBER UMBER UMBER VARCHAR2 150 NUMBER NUMBER VARCHAR2 150 NUMBER NUMBER VARCHAR2 150 NUMBER NUMBER VARCHAR2 150 NUMBER NUMBER VARCHAR2 150 NUMBER First day from the Planning Schedule horizon start date from which demand will be considered Forecast Last day from the Planning Schedule horizon start date to which demand will be considered Forecast Last day from the Planning Schedule horizon start date to which demand will be considered Forecas First day from the Planning Schedule horizon start date from which demand will be considered Frozen cannot be changed Descriptive Flexfield context column First day from the Sequenced Schedule horizon start date from which demand will be considered Firm Shippable Last day from the Sequenced Schedule horizon start date to which demand will be considered Firm Shippable Descriptive Flexfield context column Last day from the Sequenced Schedule horizon start date to which demand will be considered Forecast First day from the Sequenced Schedule horizon start date from which demand will be considered Forecast Descriptive Flexfield context column First day from the Sequenced Schedule horizon start date from which demand will be considered Frozen cannot be changed Last day from the Sequenced Schedule ho
58. NUL OT NUL OT NUL OT NUL OT NUL OT NUL OT NUL NOT NUL NUMBER NUMBER VARCHAR2 30 DATE DATE VARCHAR2 30 VARCHAR2 30 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 30 VARC AR2 3 VARCHAR2 25 VARC VARC AR2 35 AR2 60 VARCHAR2 15 VARCHAR2 10 VARCHAR2 10 Schedule unique identifier Ship to Customer unique identifier FK to RA CUSTOMERS Schedule Type Planning Shipping or Sequenced Validated against FND LOOKUPS LOOKUP TYPE RLM SCHEDULE TYPE Schedule horizon end date Schedule horizon start date EDI or manual transaction source identifier for this schedule i e 830 862 DELFOR MANUAL etc Schedule purpose code Original Replace Cancellation etc Validated against FND LOOKUPS LOOKUP TYPE RLM SCHEDULE PURPOSE Customer assigned schedule reference or release number Customer address line 1 as sent by the customer on the N3 segment Customer address line 2 as sent by the customer on the N3 segment 866 i e Customer address line 3 as sent by the customer on the N3 segment Customer address line 4 as sent by the customer on the N3 segment Customer address city as sent by the customer on the N4 segment Customer country the Customer customer as sent by customer on the N4 segment county as sent by the on the N
59. Object Library is a collection of pre built application components and facilities for building Oracle Applications and extensions to Oracle Applications Oracle Application Coding Standards use the Oracle Application Object Library and contains shared components including but not limited to forms subroutines concurrent programs and reports database tables and objects messages menus responsibilities flexfield definitions and online help Oracle Proprietary Confidential Information Use Restricted by Contract 1 6 Oracle Release Management Technical Reference Manual I Attention Oracle does not support any customization of Oracle Application Object Library tables or modules not even by Oracle consultants Oracle Application Object Library tables generally have names beginning with FND Accordingly this manual does not contain detailed information about most Oracle Application Object Library tables used by your Oracle Release Management application A Few Words About Terminology The following list provides you with definitions for terms that we use throughout this manual Relationship A relationship describes any significant way in which two tables may be associated For example rows in the Journal Headers table may have a one to many relationship with rows in the Journal Lines table Database Diagram A database diagram is a graphic representation of application tables and the relationships between them
60. Oracle Release Management CAUTION This document contains proprietary confidential information that is the exclusive property of Oracle Corporation See back cover for important information Oracle Release Management Technical Reference Manual RELEASE 11i March 2000 Oracle Release Management Technical Reference Manual Release 11i To order this book ask for Part No A83736_01 Copyright 2000 Oracle Corporation All rights reserved Major Contributors Sai Addepalli Ashwin Kulkarni Anil Verma Contributors Zoe Mitchell Dave Reitan Richard Sears Elizabeth Looney This Technical Reference Manual TRM in any form software or printed matter contains proprietary information of Oracle Corporation it is provided under an Oracle Corporation agreement containing restrictions on use and disclosure and is also protected by copyright patent and other intellectual property law Restrictions applicable to this TRM include but are not limited to a exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care whichever is greater b maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle Corporation and instructing such employees and agents of these requirements for this TRM c restr
61. Oracle Forms 6 Oracle Release Management applications User Guide Your user guide provides you with all the information you need to use your Release 11i Oracle Release Management application Each user guide is organized for fast easy access to detailed information in a function and task oriented organization Oracle Self Service Web Applications Online Documentation This documentation describes how Oracle Self Service Web Applications enable companies to provide a self service and secure Web interface for employees customers and suppliers Employees can change their personal status submit expense reports or request supplies Customers can check on their orders and suppliers can share production schedules with their trading partners This documentation is available in HTML only Oracle Applications Flexfields Guide This guide provides flexfields planning setup and reference information for the Oracle Release Management implementation team as well as for users responsible for the ongoing maintenance of Oracle Applications product data This manual also provides information on creating custom reports on flexfields data Oracle Workflow Guide This manual explains how to define new workflow business processes as well as customize existing Oracle Applications embedded workflow processes You also use this guide to complete the setup steps necessary for any Oracle Applications product that includes workflow enabled proce
62. RMS V RLM CUST INV ITEM V RLM CUST ITEM CUM ADJ V RLM CUST ITEM CUM DETAILS V RLM CUST ITEM CUM KEYS V RLM CUST ITEM TERMS V RLM CUST SHIPTO TERMS V RLM HRZ SCHEDULE LINES V RLM OE ORDER LINES V RLM SCHEDULE DATES V RLM SCHEDULE INTERFACE HDR V RLM SCHEDULE INTERFACE LINES V RLM SCHEDULE ITEMS V RLM SCHEDULE LINE CUM V RLM SHIPTO ITEM TERMS V Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 11 Single Organization View List Multi Organization Support is a feature that allows you to implement multiple sets of books within a single installation of Oracle Payables Oracle Receivables Oracle Purchasing and Oracle Order Entry Shipping Instead of using multiple installations to provide data security data is secured by operating unit In Release 10 7 we added a column ORG_ID to each base table that requires partitioning by operating unit including all transaction tables and many reference tables then renamed these tables to end with the suffix ALL Then to take the place of the renamed table we create a view named like the Release 10 6 or earlier table containing a WHERE clause that automatically restricts data to a single operating unit The WHERE clause relies upon the value of an Oracle global variable to indicate the current organization If you want to retrieve all information regardless of
63. ROVINCE EXT P FROM STATE EXT P LABEL INFO LINE 1 P LABEL INFO LINE 10 P LABEL INFO LINE 2 P LABEL INFO LINE 3 P LABEL INFO LINE 4 P LABEL INFO LINE 5 P LABEL INFO LINE 6 P LABEL INFO LINE 7 P LABEL INFO LINE 8 P LABEL INFO LINE 9 P TO ADDRESS 1 EXT P TO ADDRESS 2 EXT P TO ADDRESS 3 EXT P TO ADDRESS 4 EXT NU NU NU NU NU NU NU NU NU NU NU NU NU NU NU VARC VARC VARC VARC VARC VARC VARC AR2 35 AR2 35 AR2 35 AR2 30 AR2 3 AR2 25 AR2 60 NUMBER VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC VARC AR2 15 AR2 10 AR2 10 AR2 80 AR2 80 AR2 80 AR2 80 AR2 80 AR2 80 AR2 80 AR2 80 AR2 80 AR2 80 AR2 35 AR2 35 AR2 35 AR2 35 P FROM address line 2 as nt by the customer on the N3 gment P FROM address line 3 as nt by the customer on the N3 gment P_FROM address line 4 as nt by the customer on the N3 gment P_FROM address city as sent the customer on the N4 gment HIP_FROM country as sent by he customer on the N4 segment HIP_FROM county as sent by he customer on the N4 segment HIP_FROM Name as sent by the ustomer in the NI and or N2 egment hip from organization ID e
64. SES FK unique Customer unique identifier to RA CUSTOMERS Ship from Organization unique identifier FK to MTL PARAMETERS CUM Management Determines if and how CUM Management is done with this customer address shipments CUM Management is done by Purchase Order the PO number must be included for every item in shipment If CUM Management is done by Record keeping year the current Record keeping year t be included in every hipment Validated against D LOOKUPS LOOKUP TYPE LM CUM CONTROL CODE nique identifier for the pment method FK to INTERORG SHIP METHODS transit Lead Time between hip from and ship to ocations based on default hip method and expressed in time UOM UOM in which in transit lead time is expressed Default shipment delivery rule name for this customer address FK to RLM SHIP DELIVERY CODES Customer Current Record keeping year code if applicable to CUM CONTROL CODE value It will be attached to all items on ASNs to this destination Customer Previous Record keeping year code if applicable to CUM CONTROL CODE value It will be attached to all items on ASNs to this destination Current CUM calculation starting date if applicable to CUM CONTROL CODE value It will be attached to all items on ASNs to this destination control code EE a u Hp H p 5 I ukLkunHERUca mu53 Oracle Proprietary Confidential Information Use Restricted by Contract Detaile
65. Standard Who Standard Who Standard Who Standard Who Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Trading segment Part colu Part colu Part colu Part colu Part colu Part colu Part colu Part colu arning is column column column column Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield Flexfield column column column column column ner flexfield mn ner flexfield mn ner flexfield mn ner flexfield mn ner flexfield mn ner flexfield mn ner flexfield mn ner flexfield mn Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design context segment segment segment segment segment segment segment segment segment segment segment segment segment segment segment 3 61 TP ATTRIBUTE9 TP ATTRIBUTE10 TP_ATTRIBUTE11 TP_ATTRIBUTE12 TP_ATTRIBUTE13 TP_ATTRIBUTE14 TP_ATTRIBUTE15 TP_ATTRIBUTE_CATEGORY LINE_NUMBER INTMED_SHIP_TO_ORG_ID LINE_SOURCE ORDER HEADER ID PREFERRED GRADE Indexes Index Name NULL NULL NULL Index Type VARC AR2 150 VARC AR2 150 VARC AR2 150 VARC AR2 150 VARC
66. T NULL VARCHAR2 30 The exception code FK to FND_NEW_MESSAGES EXCEPTION_LEVEL NOT NULL VARCHAR2 1 Indicates whether the exception is a warning W an error E or information I CUST BILL TO EXT ULL VARCHAR2 35 Bill To Location CUST INTERMD SHIPTO EXT ULL VARCHAR2 35 External Customer Bill To Cross Reference CUST ITEM DESCRIPTION ULL VARCHAR2 80 Customer Item Description CUST JOB NUMBER ULL VARCHAR2 50 Customer Job Number CUST MODEL SERIAL NUM ULL VARCHAR2 35 Customer s Vehicle Identification Number for this sequenced detail e g VIN or Chassis ID CUST_NAME_EXT ULL VARCHAR2 60 Customer Name as sent by the customer in the NI and or N2 segment CUSTOMER_PROD_SEQ_NUM ULL VARCHAR2 35 Customer Production Sequence Number or Delivery Number CUST_SHIP_FROM_ORG_EXT ULL VARCHAR2 80 External Inventory Organization Cross Reference CUST_SHIP_TO_EXT ULL VARCHAR2 35 External Ship To Address Cross Reference CUST_UOM_EXT ULL VARCHAR2 10 External Customer Unit of Measure Cross Reference CUSTOMER_ITEM_EXT ULL VARCHAR2 50 External Customer Part Number Cross Reference DATE_TYPE_CODE ULL VARCHAR2 30 Type of Start End Date e g Ship Delivery Pull Signal Cumulative Validated against FND_LOOKUPS LOOKUP_TYPE RLM_DATE_TYPE_CODE ECE_TP_LOCATION_CODE_EXT NULL VARCHAR2 35 For EDI transactions only ED Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Comm
67. TE14 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP ATTRIBUTE15 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP ATTRIBUTE CATEGORY ULL VARCHAR2 30 Trading Partner Flexfield segment column Oracle Proprietary Confidential Information Use Restricted by Contract 3 64 Oracle Release Management Technical Reference Manual Indexes Index Name Index Type Sequence Column Name RLM_SHIP_DELIVERY_CODES_U1 NOT UNIQUE 5 SHIP_DELIVERY_RULE_NAME Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 65 RLM_UI_QUERIES Column Descriptions Name Null Type Description QUERY_ID NOT NUL NUMBER Unique ID assigned to each Query QUERY_NAME NOT NUL VARCHAR2 240 Name Assigned by User to the Query USER_ID ULL NUMBER User id of the Application User who created the Query DELETE_FLAG UL VARCHAR2 1 Flag which tells whether Query can be deleted or not CREATION_DATE NOT NUL DATE Standard Who column CREATED_BY NOT NUL NUMBER Standard Who column LAST_UPDATE_DATE NOT NUL DATE Standard Who column LAST_UPDATED_BY NOT NUL NUMBER Standard Who column LAST_UPDATE_LOGIN NOT NUL NUMBER Standard Who column Oracle Proprietary Confidential Information Use Restricted by Contract 3 66 Oracle Release Management Technical Reference Manual RLM_UI_QUERY_COLUMNS This table stores the details of Query Criteria for each of the Query in RLM_UI_QUERIES For ea
68. THODS n transit Lead Time between hip from and ship to ocations based on default hip method and expressed in ime UOM f the requirements should be ounded up to standard packs in he Demand Processor the uantity per pack expressed in he customer UOM UOM in which in transit lead time is expressed Operating unit unique ID FK to HR ORGANIZATION UNITS Unique identifier for price list associated with customer item if pricing agreement is not used FK to RA PRICE LISTS Positive tolerance high end for changes to Customer Item demand Flag that indicates whether you want to used the ship delivery pattern code that the customer sends in on the EDI transactions if it is populated Standard Who column Standard Who column Standard Who column Standard Who column Last day from the Planning Schedule horizon start date to which demand will be considered Firm Shippable Descriptive Flexfield context column tatkrHtukLnHELGtttutnu Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 15 3 16 PLN_FORECAST_DAY_FROM PLN_FORECAST_DAY_TO PLN_FROZEN_DAY_TO PLN_FROZEN_DAY_FROM ATTRIBUTE1 SEQ_FIRM_DAY_FROM SEQ_FIRM_DAY_TO ATTRIBUTE2 SEQ_FORECAST_DAY_TO SEQ_FORECAST_DAY_FROM ATTRIBUTE3 SEQ_FROZEN_DAY_FROM SEQ_FROZEN_DAY_TO ATTRIBUTE4 SHP_FIRM_DAY_FROM SHP_FIRM_DAY_TO ATTRIBUTES SHP_FROZEN_DAY_TO NU NU NU NU NU
69. ULE TYPE was derived in EDI Gateway Code Conversion Date customer generated either the schedule or the planning information on the schedule External value from which SCHEDULE PURPOSE was derived in EDI Gateway Code Conversion Oracle Proprietary Confidential Information Use Restricted by Contract 3 48 Oracle Release Management Technical Reference Manual LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTES ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM ID PROGRAM UPDATE DATE TP ATTRIBUTEL TP ATTRIBUTE2 TP ATTRIBUTE3 TP_ATTRIBUTE4 TP_ATTRIBUTES TP_ATTRIBUTE6 TP_ATTRIBUTE7 TP_ATTRIBUTE8 TP_ATTRIBUTE9 TP_ATTRIBUTE10 NOT NOT NOT NOT Di C ee ee ae GGGGGEG aGGaGGG a E DATE NUMBER DATE NUMBER VARCHAR2 30 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 NUMBER NUMBER NUMBER NUMBER DATE VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 1
70. UTE3 ATTRIBUTE 4 ATTRIBUTES ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 3 44 Oracle Release Management Technical Reference Manual contex segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen segmen key key ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE TP_ATTR TP_ATTR TP_ATTR TP_ATTR TP_ATTR TP_ATTR TP_ATTR TP_ATTR TP ATTR TP ATTR TP ATTR TP ATTR TP ATTR TP ATTR TP ATTR TP ATTR BUT BUT BUT BUT BUT BUT BUT BUT BUT BUT BUT BUT BUT BUT BUT TE TE TE TE TE TE TE TE TE TE TE TE TE TE TE BUT TE LINE_NUMBER 1 2 3 4 5 6 7 8 9 CATEGORY INTMED SHIP TO ORG ID LINE SOURCE Indexes pan G aS GE GGGGGG NU LL VARCHAR2 150 LL VARCHAR2 150 LL NUMBER LL NUMBER LL NUMBER LL NUMBER LL DATE LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 150 LL VARCHAR2 30 LL NUMBER LL NUMBER LL VARCHAR2 30 Descriptive
71. UTE5 BUTE6 BUTE7 BUTE8 BUTE9 ITEM_DETAIL_QUANTITY ITEM_DETAIL_SUBTYPE ITEM_DETAIL_TYPE MESSAGE_TEXT NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL VARCHAR2 NULL VARCHAR2 NULL VARCHAR2 NULL VARCHARZ2 NULL VARCHAR2 NULL VARCHAR2 NULL VARCHAR2 NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL VARC AR2 NULL NUMBER 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 NULL VARCHAR2 30 NULL VARCHAR2 30 ti X Q oO ption place holder field not standard AOL xception place holder field not standard AOL ption place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder field not standard AOL xception place holder lexfield not standard AOL ption place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not sta
72. VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 NUMBER NUMBER NUMBER NUMBER DATE VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 30 VARCHAR2 240 Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Descriptive column Standard Who Standard Who Standard Who Standard Who Standard Who Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu Trading Part Segment colu ASCII string Flexfield contex Flexfield contex Flexfield contex Flexfield contex Flexfield contex Flexfield contex Flexfield contex column column column column column ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfield mn ner Flexfiel
73. ains database diagrams and lists each database table and view that Oracle Release Management uses This chapter also has a list of modules Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 3 Detailed Design This section Chapter 3 contains a detailed description of the Oracle Release Management database design including information about each database table and view you might need for your custom reporting or other data requirements Oracle Proprietary Confidential Information Use Restricted by Contract 1 4 Oracle Release Management Technical Reference Manual How to Use This Manual The Oracle Release Management Technical Reference Manual is a single centralized source for all the information you need to know about the underlying structure and processing of your Oracle Release Management application For example you can use this manual when you need to e Convert existing application data e Integrate your Oracle Release Management application with your other applications systems e Write custom reports e Define alerts against Oracle Applications tables e Configure your Oracle Self Service Web Applications e Create views for decision support queries using query tools e Create business views for Oracle Discoverer You need not read this manual cover to cover Use the table of contents and index to quickly locate the information you need How Not To Use This Manual Do
74. al We appreciate your comments and feedback At the back of this manual is a Reader s Comment Form that you can use to explain what you like or dislike about your Oracle Release Management application or this technical reference manual Mail your comments to the following address or call us directly at 650 506 7000 Oracle Applications Documentation Manager Oracle Corporation 500 Oracle Parkway Redwood Shores California 94065 USA Or send electronic mail to appsdoc us oracle com Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 13 Oracle Proprietary Confidential Information Use Restricted by Contract 1 14 Oracle Release Management Technical Reference Manual CHAPTER High Level Design his chapter presents a high level design for Oracle Release Management that satisfies the business needs we specify during Strategy and Analysis It contains database diagrams for Oracle Release Management application building blocks lists of database tables and views and a list of modules Oracle Proprietary Confidential Information Use Restricted by Contract High Level Design 2 1 Overview of High Level Design Database Diagrams Table Lists During High Level Design we define the application components tables views and modules we need to build our application We specify what application components should do without specifying the details of how they should do it
75. am Processor for splitting or consolidating daily or weekly customer requirements from planning and shipping schedules into discrete shipment date quantity groups which consistently and accurately reflect the customer s expected shipment or delivery patterns The Rule is in context of the customer given date qualifier i e delivery or shipment Column Descriptions Name Null Type Description SHIP_DELIVERY_RULE_NAME NOT NULL VARCHAR2 30 Unique shipment delivery rule name DESCRIPTION NULL VARCHAR2 240 Rule description MONDAY_PERCENT NULL UMBER f splitting weekly buckets the percent of customer requirement quantity which is to be allocated to Monday TUESDAY_PERCENT NULL UMBER f splitting weekly buckets the percent of customer requirement quantity which is to be allocated to Tuesday WEDNESDAY_PERCENT NULL UMBER f splitting weekly buckets the percent of customer requirement quantity which is to be allocated to Wednesday THURSDAY_PERCENT NULL UMBER f splitting weekly buckets the percent of customer requirement quantity which is to be allocated to Thursday FRIDAY_PERCENT NULL UMBER f splitting weekly buckets the percent of customer requirement quantity which is to be allocated to Friday SATURDAY_PERCENT NULL UMBER f splitting weekly buckets the percent of customer requirement quantity which is to be allocated to Saturday SUNDAY_PERCENT NULL UMBER f splitting weekly buckets
76. and Oracle s large staff of consultants and support specialists with expertise in your business area managing an Oracle server and your hardware and software environment Oracle Proprietary Confidential Information Use Restricted by Contract 1 12 Oracle Release Management Technical Reference Manual About Oracle Thank You Oracle Corporation develops and markets an integrated line of software products for database management applications development decision support and office automation as well as Oracle Applications an integrated suite of more than 75 software modules for financial management supply chain management manufacturing project systems human resources and sales and service management Oracle products are available for mainframes minicomputers personal computers network computers and personal digital assistants allowing organizations to integrate different computers different operating systems different networks and even different database management systems into a single unified computing and information resource Oracle is the world s leading supplier of software for information management and the world s second largest software company Oracle offers its database tools and applications products along with related consulting education and support services in over 145 countries around the world Thanks for using Oracle Release Management applications and this technical reference manu
77. cations table uses an Oracle8i index we list the database columns that comprise that index in sequential order Note The indexes we document in this manual correspond to unique keys we specified during product development and testing In some cases we may add additional indexes during the porting process to fine tune performance on specific platforms therefore there may be minor differences between the indexes documented in this book and the indexes for production versions of Oracle Release Management Sequences Your Oracle Release Management application uses Oracle8i sequence generators to generate unique integers If any table column gets its value from an Oracle8i sequence generator we list the name of the corresponding sequence generator and the name of the column that stores the unique integer Database Triggers If a table has one or more active database triggers we provide a brief explanation of each database trigger and when it fires View Derivation For each Oracle Release Management applications view you may need to reference we include important elements from the SQL statement Oracle Proprietary Confidential Information Use Restricted by Contract 3 6 Oracle Release Management Technical Reference Manual that defines or creates a view By studying this view definition you can understand exactly how a view derives its contents Oracle Proprietary Confidential Information Use Restricted by Contract De
78. ch of the field in the Release Workbench Find Window this table stores a record which has foreign key relationship with RLM_UI_QUERIES Column Descriptions Name Null Type Description QUERY_ID NOT NULL NUMBER ID for the Query for which Criteria is being stored COLUMN_NAME NOT NULL VARCHAR2 240 Name of the fileld on Find Window whose criteria is being stored COLUMN_TYPE NULL VARCHAR2 200 Data Type of the Field on Find Window whose criteria is being stored COLUMN_VALUE NULL VARCHAR2 2000 Query Crtieria for the Field used on Find Window of Release Workbench CREATION_DATE OT NULL DATE Standard Who column CREATED_BY OT NULL NUMBER Standard Who column LAST_UPDATE_DATE OT NULL DATE Standard Who column LAST_UPDATED_BY OT NULL NUMBER Standard Who column LAST_UPDATE_LOGIN OT NULL NUMBER Standard Who column Indexes Index Name ndex Type Sequence Column Name RLM_UI_QUERY_COLUMNS_N1 NOT UNIQUE 5 QUERY_ID Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 67 Oracle Proprietary Confidential Information Use Restricted by Contract 3 68 Oracle Release Management Technical Reference Manual Index C Column descriptions 3 4 Columns Who 3 5 Concurrent Program List See Concurrent Program Definitions D Database triggers 3 7 F Foreign keys 3 3 Form List See Form Definitions I Indexes 3 6 L Lookup types See QuickCodes M
79. cle Proprietary Confidential Information Use Restricted by Contract 3 2 Oracle Release Management Technical Reference Manual Table and View Definitions This section contains a detailed description of each Oracle Release Management table and view that you may need to reference For each table it presents detailed information about e Primary keys e Foreign keys e Column descriptions e Indexes e Oracle sequences e Triggers e View derivations Because Oracle does not support customization of Oracle Application Object Library tables we do not provide you with detailed information about them Consequently this section does not document all the FND_ tables your Oracle Release Management application uses The following sections appear in each table or view description Foreign Keys To help you understand the relationships between tables we list each foreign key contained in a table For each foreign key in a table we list the primary key table name the table to which a foreign key refers its corresponding primary key columns and the foreign key columns that refer to those primary key columns When the primary key table has a composite primary key we list each column of the composite key sequentially If a table contains two or more distinct foreign keys that refer to the same primary key table we repeat the primary key table name and list each of the distinct foreign keys separately QuickCodes Columns
80. cluded in customer EDI transaction Value associated with Reference code 1 Value associated with Reference code 2 Value associated with Reference code 3 Customer part release status included on schedule The lading quantity as sent by the customer on the TD1 segment Customer letter of credit expiration date included on the shipping schedule and must be sent back on the ship notice Customer letter of credit with international bank guaranteeing payment for international shipments included on the shipping schedule and must be sent back on the ship notice Unique line identifier within an order for a transmission identifier Link to Immediate Parent_line_reference within an order for a transmission identifier Operating unit unique ID Validated against HR_ORGANIZATION_UNITS Other name code 1 included in customer EDI transaction Other name code 2 included in customer EDI transaction Values associated with Other name code 1 concatenation of mame code and number Values associated with Other name code 2 concatenation of name code and number Size of supplier units in pack as sent by the customer on the PO4 segment Number of inner pack units per out pack unit as sent by the customer on the PO4 segment Unit of measure of supplier units in the pack as sent by the customer in the P04 segment The packaging code as sent by the customer on TD1 segment Quantity in the primary UOM FK to MT
81. d Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE7 DUSTRY_ATTRIBUTE8 DUSTRY_ATTRIBUTE9 INDUSTRY_CONTEXT IN IN IN SH N N N N N N TRM TRM TRM TRM NTRM NTRM NTRM NTRM TRM TRM TRM TRM NVENTORY_ITEM_SEG VENTORY_ITEM_SEG VENTORY_ITEM_SEG NVENTORY_ITEM_SEGMENT NVENTORY_ITEM_SEG VENTORY_ITEM_SEG VENTORY ITEM SEG NVENTORY ITEM SEGMENT NVENTORY ITEM SEGMENT VENTORY ITEM SEG NVENTORY ITEM SEG NVENTORY ITEM SEGMENT2 VENTORY ITEM SEG TRMD SHIP TO ID P TO ORG ID D ST ADDRESS 1 D ST ADDRESS 2 D ST ADDRESS 3 D ST ADDRESS 4 D ST CITY EXT D ST COUNTRY E D ST COUNTY EX D ST NAME EXT D ST POSTAL CD D ST PROVINCE D ST STATE EXT D ST SITE USE VENTORY ITEM ID _EXT _EXT EXT _EXT XT T _EXT EXT ID ENT ENT ENT ENT ENT ENT ENT ENT ga a a UBWNEF O ENT20 ee ae TR Gaqaaa 2 Gq oe elr er a e a GGGGGG GGAGAGAAGAAE E VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 30 NUMBER NUMBER VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 30 VARC AR2 3 VARCHAR2 25 VARCHAR2 60 VARCHAR2 15 VARCHAR2 10 VARCHAR2 10 NUMBER NUMBER VARC VARC
82. d lexfield column column Column column column column Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design segment segment segment segment segment segment exfield 3 9 RLM_CUST_ITEM_CUM_KEYS_ALL Column Descriptions This table stores the CUM key values associated with a particular ship to ship from item combination according to the CUM Management rules defined for the trading partners which are supported in Oracle Release Management If CUM Management is enabled this table defines the entity for which a CUM would be calculated i e there is one row in this table for every bill to ship to ship from item CUM key combination The CUM key will vary by customer in addition to ship to ship from and item it could include any combination of CUM starting date Purchase Order Number or Record keeping year If CUM Management is enabled related child rows in RLM_CUST_ITEM_CUM_AD J will indicate all adjustment transactions between the two trading partners related to this specific customer defined accumulation grouping only e g for this PO only for this record keeping year only If CUM Management is disabled this table is not populated In an FBO environment there would be a row for each component used for the customer since the top model number i e end item does not need cum management Rows in this table are automatically inserted as n
83. d mn ner Flexfield mn ner Flexfield mn ner Flexfield mn of characters which identify the enabled optional demand matching attributes when demand from different schedule types is being compar ed The ASCII character assigned to the matching column is stored in FND LOOKUPS LOOKUP CODE after the comma delimiter Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual MATCH_WITHIN_KEY NULL VARCHAR2 240 ASCII string of characters which identify the enabled optional demand matching attributes when demand from the same schedule type is being compared The ASCII character assigned to the matching column is stored in FND_LOOKUPS LOOKUP_CODE after the comma delimiter PLN_MRP_FORECAST_DAY_FROM NULL NUMBER PLN_MRP_FORECAST_DAY_TO NULL NUMBER SHP_MRP_FORECAST_DAY_FROM NULL NUMBER SHP_MRP_FORECAST_DAY_TO NULL NUMBER SEQ_MRP_FORECAST_DAY_FROM NULL NUMBER SEQ_MRP_FORECAST_DAY_TO NULL NUMBER Indexes Index Name Index Type Sequence Column Name RLM CUST SHIPTO TERMS Ul UNIQUE 3 CUSTOMER ID 6 ADDRESS ID 7 SHIP FROM ORG ID RLM CUST SHIPTO TERMS U2 NOT UNIQUE 5 CUST SHIPTO TERMS ID Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 25 RLM_DEMAND_EXCEPTIONS Column Descriptions Name Null Type Description EXCEPTION_ID NOT NULL NUMBER Exception Unique Identifier MESSAGE_NAME NO
84. d Design 3 19 CUM_PREVIOUS_START_DATE CUM_ORG_LEVEL_CODE CUM_SHIPMENT_RULE_CODE CUM_YESTERD_TIME_CUTOFF CUST_ASSIGN_SUPPLIER_CD CUSTOMER_RCV_CALENDAR_CD FREIGHT_CODE SUPPLIER_SHP_CALENDAR_CD UNSHIP_FIRM_CUTOFF_DAYS NULL NULL NULL NULL NULL NULL NULL NULL NULL DATE VARCHAR2 30 VARCHAR2 30 NUMBER VARCHAR2 35 VARCHAR2 10 VARCHAR2 25 VARCHAR2 10 NUMBER Previous CUM calculation starting date if applicable to CUM CONTROL CODE value To be used in building the CUM key if shipment date is earlier than Current CUM calculation starting date If CUM Management is on is the business entity levels at which he cum is calculated between he customer and supplier alidated against D LOOKUPS LOOKUP TYPE LM CUM ORG LEVEL f CUM Management is on this pecifies the most recent hipment which should be ncluded in CUM current last r yesterday shipment alidated against D LOOKUPS LOOKUP TYPE LM CUM SHIPMENT RULE f CUM Management is on and esterday shipment is the last hipment to include this is he cutoff time for yesterday hipments to be included he code the customer uses to dentify you as a supplier ransmitted by the customer in he N1 segment ustomer receiving calendar ode Used in conjunction with he supplier shipment calendar ode If populated the Demand tream Processor will use this alendar when applying hip delivery pattern rules to ens
85. d in CUM QTY AFTER CUTOFF This quantity gets added to CUM QTY on next shipment or next day depending on the shipment inclusion rule when LAST CUM QTY UPDATE DATE is less than the CUM as of date and time The date time when CUM QTY was last updated by shipments and adjustments Standard Who column Standard Who column Standard Who column Standard Who column Descriptive Flexfield context column Descriptive Flexfield segment column Descriptive Flexfield segment column Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 11 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTES ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST U PDATE LOGIN REQUEST ID PROGRA PROGRA PROGRA TP_ATT LP ATT TP_ATT TP_ATT TP_ATT TP_ATT TP_ATT TP_ATT TP_ATT TP ATT TP_ATT TP_ATT TP_ATT TP_ATT TP_ATT TP_ATT 3 12 APPLICATION_ID ID UPDATE DATE RIBUTE1 RIBUTE2 RIBUTE3 RIBUTE4 RIBUTES RIBUTE6 RIBUTE7 RIBUTE8 RIBUTE9 RIBUTE10 RIBUTE11 RIBUTE12 RIBUTE13 RIBUTE14 RIBUTE15 RIBUTE CATEGORY G 22 Gaqaqaqa NU NU NU NU NU VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2
86. d trademarks of Oracle Corporation Other names may be trademarks of their respective owners FT CAUTION his Technical Reference Manual in any form software or T printed matter contains proprietary confidential information that is the exclusive property of Oracle Corporation If you do not have a valid contract with Oracle for the use of this Technical Reference Manual or have not signed a non disclosure agreement with Oracle covering this Technical Reference Manual then you received this document in an unauthorized manner and are not legally entitled to possess or read it Use duplication and disclosure are subject to restrictions stated in your contract with Oracle Corporation Contents Chapter 1 Introduction 2 0 0 cc cece ccc cece cece eee eee eee ERN 1 1 Introduction eek fu BAe oct na at e budet eat 1 2 Chapter 2 High Level Design auunnnnnnnnnnnnnnnnnnnnnnnnnenen 2 1 Overview of High Level Design 0 00 c cece eee 2 2 Chapter 3 Detailed Design aaunnuunnnnnnnnnnnnnnnnnnnnnnnnnenne 3 1 Overview of Detailed Design aavvnnnnnnavvannnnnnn 3 2 Table and View Definitions 0 0 00 c cece eee eee 3 3 Oracle Proprietary Confidential Information Use Restricted by Contract Contents i ii Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual Oracle Proprietary Confidential Information
87. d will be considered Firm Shippable Last day from the Planning Schedule horizon start date to which demand will be considered Firm Shippable First day from the Planning Schedule horizon start date from which demand will be considered Forecas Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 21 PLN_FORECAST_DAY_TO NULL NUMBER Last day from the Planning Schedule horizon start date to which demand will be considered Forecast PLN_FROZEN_DAY_TO NULL NUMBER Last day from the Planning Schedule horizon start date to which demand will be considered Frozen cannot be changed PLN_FROZEN_DAY_FROM NULL NUMBER First day from the Planning Schedule horizon start date from which demand will be considered Frozen cannot be changed SEQ FIRM DAY FROM NULL UMBER First day from the Sequenced Schedule horizon start date from which demand will be considered Firm Shippable SEQ FIRM DAY TO NULL UMBER Last day from the Sequenced Schedule horizon start date to which demand will be considered Firm Shippable SEQ FORECAST DAY TO NULL UMBER Last day from the Sequenced Schedule horizon start date to which demand will be considered Forecast SEQ FORECAST DAY FROM NULL UMBER First day from the Sequenced Schedule horizon start date from which demand will be considered Forecast SEQ FROZEN DAY FROM NULL UMBER First day from the Sequenced Schedule horizon start date from which demand will b
88. ded on schedule should link to a valid agreement Returnable container specified by customer for item shipment The routing description as sent by the customer on the TD5 segment Code describing the relationship of a carrier toa specific shipment movement as sent by the customer on the TD5 segment Schedule Item Number the means to identify how item demand and information is grouped by the customer within the schedule For sequenced schedules it is equal to CUSTOMER_PROD_SEQ_NUM For EDI planning and shipping schedules it is incremented in the EDI Gateway when each 2000 record is encountered on an inbound SPSI or SSSI transaction This number is assigned for manually entered schedules All interface lines with the same Schedule Item number are validated together and pass or fail validation as a group Customer ship delivery pattern code for this item not integrated with delivery rules for date qty calculation Customer ship delivery time code for this item not integrated with delivery rules for date qty calculation SHIP_FROM address line 1 as sent by the customer on the N3 segment Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 57 3 58 P FROM ADDRESS 2 EXT P FROM ADDRESS 3 EXT P FROM ADDRESS 4 EXT P FROM CITY EXT P FROM COUNTRY EXT P FROM COUNTY EXT P FROM NAME EXT P FROM ORG ID P FROM POSTAL CD EXT P FROM P
89. e Customer specified country of origin The customer assembly identification as sent on the LIN segment of the 866 txn Customer assigned identification for differentiation within a transaction set from LINO1 External Customer Bill To Cross Reference The customer contract number as sent on the LIN segment of the 830 txn Customer dock code External Intermediate ship to Cross Reference Price included on the customer EDI transaction UOM corresponding to the price included on teh customer EDI transaction Customer part revision included on schedule Customer job number The manufacturer as sent by the customer on the LIN segment of the 866 txn Customer Model Number for this sequenced detail Customer Vehicle Identification Number for this sequenced detail e g VIN or Chassis ID The order number as sent by the customer on the LIN segment of the 866 and 830 txn The process number as sent by the customer on the LIN segment of the 866 and 862 transaction Customer production line Customer Production Sequence Number or Delivery Number The customer set number as sent on the LIN segment of the 862 and 866 txns External Inventory Organization Cross Reference External Ship to address Cross Reference External Customer unit of measure cross reference External Customer part number Cross Reference Customer item identifier FK to MTL_CUSTOMER_ITEMS Oracle Proprietary Confidential Information U
90. e considered Frozen cannot be changed SEQ FROZEN DAY TO NULL UMBER Last day from the Sequenced Schedule horizon start date to which demand will be considered Frozen cannot be changed P FIRM DAY FROM NULL NUMBER First day from the Shipping Schedule horizon start date from which demand will be considered Firm Shippable SHP FIRM DAY TO NULL NUMBER Last day from the Shipping Schedule horizon start date to which demand will be considered Firm Shippable P FROZEN DAY TO NULL NUMBER Last day from the Shipping Schedule horizon start date to which demand will be considered Frozen cannot be changed SHP FROZEN DAY FROM NULL NUMBER First day from the Shipping Schedule horizon start date from which demand will be considered Frozen cannot be changed SHP FORECAST DAY TO NULL NUMBER Last day from the Shipping Schedule horizon start date to which demand will be considered un I Wn I Forecast ROUND TO STD PACK FLAG NULL VARCHAR2 1 Round to Standard Pack Flag SUPPLIER CONTACT ID NULL NUMBER Supplier Contact FK to PER PEOPLE F Oracle Proprietary Confidential Information Use Restricted by Contract 3 22 Oracle Release Management Technical Reference Manual AGREEMENT NAME STD PACK QTY FUTURE AGREEMENT NAME SHP FORECAST DAY FROM SCHEDULE HIERARCHY CODE COMMENTS LAST UPDATED BY LAST UPDATE DATE CREATION DATE CREATED BY ATTRIBUTE CATEGORY ATTR
91. eeded by the Shipping functions or manually entered in the CUM Adjustment Transaction form This table has a child relationship to RLM_SHIP_FROM_CUST_ITEMS and a parent relationship to RLM_CUST_ITEM_CUM_AD J Name Null Type Description CUM KEY ID NOT NULL NUMBER Customer Item cum KEY unique ID CUSTOMER ITEM ID NOT NULL NUMBER Customer Item unique ID FK to MTL CUSTOMER ITEMS SHIP TO ADDRESS ID NULL NUMBER Ship to Address unique ID if BILL TO ADDRESS ID the customer side CUM Org Level defined for the Ship from Ship to relationship to which this cum key belongs is Ship to One of the three address Ids Ship to Bill to or Intermediate Ship to must be specified NULL NUMBER Bill to Address unique ID if the customer side CUM Org Level defined for the Ship from Ship to relationship to which this cum key belongs is Bill to One of the three address Ids Ship to Bill to or Intermediate Ship to must be specified Oracle Proprietary Confidential Information Use Restricted by Contract 3 10 Oracle Release Management Technical Reference Manual INTRMD_SHIP_TO_ID SHIP_FROM_ORG_ID CUM_START_DATE CUST_RECORD_YEAR ORG_ID PURCHASE_ORDER_NUMBER CUST_UOM_CODE CUM_OTY CUM_OTY_AFTER_CUTOFF CUM QTY TO BE ACCUMULATED LAST CUM QTY UPDATE DATE LAST UPDATE DATE LAST UPDATED BY CREATION DATE CREATED BY ATTRIBUTE CATEGORY ATTRIBUTE1 ATTRIBUTE2 NOT NOT NOT NOT NULL NULL NULL NUL
92. ense for shipment destination country included on the shipping schedule and must be sent back on the ship notice Record keeping or model year ndustry Attribute Descriptive flexfield ndustry Attribute Descriptive flexfield ndustry Attribute Descriptive flexfield ndustry Attribute Descriptive flexfield ndustry Attribute Descriptive flexfield ndustry Attribute Descriptive flexfield Unused Customer Schedule Number Schedule reference num on the RLM SCHEDULE HEADERS Industry Attribute Descriptive flexfield Industry Attribute Descriptive flexfield Industry Attribute Descriptive flexfield Calculated CUM This is updated after an order line has been shipped It will be used on the ASN and on the packing list to indicate the CUM UOM for Calculated CUM in NDUSTRY_ATTRIBUTE7 This is updated after an order line has been shipped It will be used on the ASN and on the packing list ndustry Attribute Descriptive flexfield ndustry Attribute Descriptive flexfield context column Customer Intermediate Ship to Destination unique identifier FK to RA_ADDRESSES Unique identifier for ship to organization which relates to SHIP TO ADDRESS ID FK to HR ORGANIZATIONS TERMEDIATE SHIP TO address line 1 as sent by the customer on Et 3 segment TERMEDIATE SHIP TO address line 2 as sent by the customer on E 3 segment TERMEDIATE SHIP TO address line 3 as sent by the customer on t 3 segment
93. ent by the customer in the N1 and or N2 segment AR2 15 Bill To address postal code as sent by the customer on the N4 segment AR2 10 Bill To province as sent by the customer on the N4 segment BILL_TO_SITE_USE_ID ULL NUMBER Bill To site use identifier FK to RA_SITE_USES AR2 10 Bill To state as sent by the customer on the N4 segment AR2 35 The carrier id as sent by the customer on the TD5 segment AR2 3 The carrier qualifier as sent by the customer on the TD5 segment AR2 35 Customer specified commodity code AR2 35 Customer specified country of origin AR2 30 The customer assembly identification as sent on the LIN segment of the 866 txn AR2 20 Customer assigned identification for differentiation within a transaction set from LINO1 AR2 35 External Customer Bill To Cross Reference AR2 35 The customer contract number as sent on the LIN segment of the 830 txn AR2 35 Customer dock code BILL_TO_ADDRESS_1_EXT ULL VARC BILL_TO_ADDRESS_2_EXT ULL VARC BILL_TO_ADDRESS_3_EXT ULL VARC BILL_TO_ADDRESS_4_EXT ULL VARC BILL_TO_CITY_EXT NULL VARC BILL_TO_COUNTRY_EXT NULL VARC BILL_TO_COUNTY_EXT NULL VARC BILL TO NAME EXT NULL VARC BILL TO POSTAL CD EXT ULL VARC BILL TO PROVINCE EXT ULL VARC BILL TO STATE EXT NULL VARC CARRIER ID CODE EXT ULL VARC CARRIER QUALIFIER EXT NULL VARC COMMODITY EXT NULL VARC COUNTRY OF
94. field segmen column ATTRIBUTE13 ULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE14 NULL VARCHAR2 150 Descriptive Flexfield segmen column ATTRIBUTE15 ULL VARCHAR2 150 Descriptive Flexfield segmen column LAST_UPDATE_LOGIN ULL NUMBER Standard Who column REQUEST_ID ULL NUMBER Standard Who column PROGRAM_APPLICATION_ID NULL NUMBER Standard Who column PROGRAM_ID NULL NUMBER Standard Who column PROGRAM_UPDATE_DATE ULL DATE Standard Who column TP_ATTRIBUTE1 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE2 NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE3 NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE4 NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTES5S NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE6 NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE7 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE8 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE9 NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE10 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE11 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE12 NULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBUTE13 ULL VARCHAR2 150 Trading Partner Flexfield segment column TP_ATTRIBU
95. gment Customer address city as sent by the customer on the N4 segment Customer country as sent by the customer on the N4 segment Customer county as sent by the customer on the N4 segment Trading Partner designator Cross Reference Customer Name as sent by the customer in the NI and or N2 segment Customer address postal code as sent by the customer on the N4 segment Customer province as sent by the customer on the N4 segment Customer state as sent by the customer on the N4 segment Customer Identifier FK to RA_CUSTOMERS Customer Primary Address ID populated by EDI Gateway code conversion of external Trading Partner Location Code FK to RA ADDRESSES For EDI transactions only external Trading Partner Location Code assigned to the location in the EDI Gateway Common Control Record For EDI transactions only EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record EDI control number 1 ISA assigned by the customer EDI translator for audit Oracle Proprietary Confidential Information Use Restricted by Contract 3 30 Oracle Release Management Technical Reference Manual EDI_CONTROL_NUM_2 EDI_CONTROL_NUM_3 EDI_TEST_INDICATOR ORG_ID PROCESS_STATUS EADER CONTACT CO EADER CONTACT CO EADER CONTACT VA EADER CONTACT VA HEADER NOTE TEXT HEADER REF CODE HEADER REF CODE HEADER REF CODE DE 1
96. icting disclosure of this TRM to those of your employees who have a need to know consistent with the purposes for which this TRM was disclosed to you d maintaining this TRM at all times on your premises e not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form software or printed matter and f not reproducing or transmitting this TRM in any form or by any means electronic or mechanical for any purpose without the express written permission of Oracle Corporation You should not use this TRM in any form software or printed matter to create software that performs the same or similar functions as any Oracle Corporation products The information in this TRM is subject to change without notice If you find any problems in the TRM in any form software or printed matter please report them to us in writing Oracle Corporation does not warrant that this TRM is error free This TRM is provided to customer as is with no warranty of any kind This TRM does not constitute Documentation as that term is defined in Oracle s agreements Reverse engineering of the Programs software and documentation associated with this TRM are prohibited The Programs associated with this TRM are not intended for use in any nuclear aviation mass transit medical or other inherently dangerous applications It shall be licensee s responsibility to take all appropriate fail safe back up redundancy and
97. idential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual Public Table List Table Name This section lists each public database table that Oracle Release Management uses and provides a brief description of each of those tables The page reference is to the table description in Chapter 3 Note that public tables are not necessarily intended for write access by custom code Oracle Corporation supports write access using only standard Oracle Applications forms reports and programs or any SQL write access to tables explicitly documented as API tables For more information see the How Not To Use This Manual section of this book s Introduction Oracle Release Management uses the following Public tables RLM CUST IT EM CUM ADJ ALL Description This table stores adjustments to the cum for all RLM customer destination items It has a child relationship to RLM CUST ITEM CUM KEYS The adjustments reflect manual CUM adjustment via a form in the Release Management module If CUMManagement is enabled the adjustments in this table along with the shipping transaction information from the Shipping Module are used in the Demand Stream Processor and Shipping applications to dynamically calculate the supplier CUMaccording to the CUM calculation rules defined for the customer destination The contents of this table are displayed in the CUM Management Workbench See page 3 8
98. igned identification from the SLNOL Related to but not necessarily equivalent to the baseline number assigned identification from LINO1 For example 1 1 or 1A might be used as a subline number to relate to baseline number 1 he Subline Configuration Code s sent by the customer on the LN segment indicating the lationship of th esubline em to the baseline item bline customer item number sent by the customer on the segment NDWGONTNHHNMNNAANAWAWNNAANAK ACG FON Hue cto ustomer Item unique dentifier FK to LM_SHIP_FROM_CUST_ITEM ubline customer model number s sent by the customer on the LN segment he subline quantity as sent y the customer on the SLN egment he subline unit of measure internal cross referenced rom the UOM sent by the ustomer on the SLN segment to MTL UNITS OF MEASURE upplier item number specified y customer he transit time as sent by he customer on the TD5 egment The transit time qualifier as sent by the customer on the TD 5 segment utHOUnHEAHAaSH0nOUHUnrnDIHLEQO UPU KHRODH Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 59 3 60 CUST_PRODUCTION_SEQ_NUM TRANSPORT_LOC_QUAL_EXT TRANSPORT_LOCATION_EXT TRANSPORT_METHOD_EXT WEIGHT_EXT WEIGHT QUALIFIER EXT WEIGHT UOM EXT ITEM DETAIL SUBTYPE EXT ITEM DETAIL TYPE EXT QTY TYPE CODE EXT DATE TYPE CODE EXT FBO CONFIGURATION KEY 1 FBO
99. information about the underlying structure of Oracle Release Management As we design and build new releases of Oracle Release Management applications we update our Oracle Designer repository to reflect our enhancements As a result we can always provide you with an Oracle Release Management Technical Reference Manual that contains the latest technical information as of the publication date Note that after the publication date we may have added new indexes to Oracle Release Management to improve performance About this Manual This manual describes the Oracle Applications Release 11i data model as used by Oracle Release Management it discusses the database we include with a fresh install of Oracle Applications Release 11i If you have not yet upgraded to Release 11i your database may differ from the database we document in this book If you have upgraded from a previous release you might find it helpful to use this manual with the appropriate Oracle Applications Product Update Notes manual The product update notes list database changes and seed data changes in Oracle Release Management between releases The Oracle Applications Product Update Notes Release 11 manual describes the changes between Release 10 7 and Release 11 and the Oracle Applications Product Update Notes Release 11i manual describes the changes between Release 11 and Release 11i You can contact your Oracle representative to confirm that you have the latest technical
100. information for Oracle Release Management You can also use OracleMetaLink which is accessible through Oracle s Support Web Center http www oracle com support elec_sup Oracle Proprietary Confidential Information Use Restricted by Contract J 2 Oracle Release Management Technical Reference Manual Finding the Latest Information Audience How This Manual is O The Oracle Release Management Technical Reference Manual contains the latest information as of the publication date For the latest information we encourage you to use OracleMetaLink which is accessible through Oracle s Support Web Center http www oracle com support elec_sup The Oracle Release Management Technical Reference Manual provides useful guidance and assistance to e Technical End Users e Consultants e Systems Analysts e System Administrators e Other MIS professionals This manual assumes that you have a basic understanding of structured analysis and design and of relational databases It also assumes that you are familiar with Oracle Application Object Library and your Oracle Release Management application If you are not familiar with the above products we suggest that you attend one or more of the training classes available through Oracle Education see Other Information Sources page 1 8 rganized This manual contains two major sections High Level Design and Detailed Design High Level Design This section Chapter 2 cont
101. ive Validated against FND LOOKUPS LOOKUP TYPE RLM DATE TYPE CODE External value from which DATE TYPE CODE was derived in EDI Gateway Code Conversion For demand lines the difference between arrival and shipment dates based on default shipping method between the ship from and ship to locations This is determined by the Calculate Ship Date routine and passed into Order Import Customer specified optional end date time applicable for flexible bucketed requirements and cumulative information such as authorizations and shipped received The equipment code as sent by the customer on the TD3 segment The equipment number as sent by the customer on the TD3 segment Special handling code as sent by the customer in the TD4 segment Hazardous Material Code corresponding to the Hazardous Material Code Qualifier as sent by the customer in the TD4 segment Hazardous Material Code Qualifier as sent by the customer in the TD4 segment Hazardous Material Description as sent by the customer in the TD4 segment Customer Import License Date Customer Import License for shipment destination country Record keeping or model year ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfield ndustry Descriptive Flexfiel
102. lue from which SCHEDULE_PURPOSE was derived in EDI Gateway Code Conversion SCHEDULE_REFERENCE_NUM NULL VARCHAR2 35 Customer assigned schedule reference or release number SCHEDULE_SOURCE NULL VARCHAR2 30 EDI or manual transaction source for this schedule i e 830 862 866 DELFOR MANUAL etc LAST_UPDATE_DATE NOT NULL DATE Standard Who column LAST_UPDATED_BY NOT NULL NUMBER Standard Who column CREATION_DATE NOT NULL DATE Standard Who column CREATED_BY NOT NULL NUMBER Standard Who column ATTRIBUTE_CATEGORY ULL VARCHAR2 30 Descriptive Flexfield context column ATTRIBUTE1 ULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE2 NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE3 ULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE4 ULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTES NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE6 ULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE7 ULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE8 NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE9 NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE10 NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE11 NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE12 ULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE13 ULL VARCHAR2 150 Descriptive Flexfield con
103. mn TP_ATTRIBUTE14 NULL VARCHAR2 150 Trading Partner flexfield column TP ATTRIBUTE15 NULL VARCHAR2 150 Trading Partner flexfield column TP ATTRIBUTE CATEGORY NULL VARCHAR2 30 Trading Partner flexfield context column Indexes Index Name Index Type Sequence Column Name RLM_HEADERS_INTERFACE_U1 UNIQUE 5 HEADER_ID Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 33 RLM_INTERFACE_LINES_ALL This table stores the item and item detail level information associated with customer planning shipping or production sequenced schedules For production sequence schedules the item represents the feature not the configuration This table stores all details for scheduled items dated demand authorizations and customer shipment receipt information It has a child relationship to R LM INTERFACE HEADERS Column Descriptions Name Null Type Description LINE_ID NOT HEADER_ID NOT AGREEMENT_ID ATO_DATA_TYPE BILL_TO_ADDRESS_1_EXT BILL_TO_ADDRESS_2_EXT BILL_TO_ADDRESS_3_EXT BILL_TO_ADDRESS_4_EXT BILL_TO_ADDRESS_ID INVOICE_TO_ORG_ID BILL_TO_CITY_EXT BILL_TO_COUNTRY_EXT BILL_TO_COUNTY_EXT BILL_TO_NAME_EXT BILL_TO_POSTAL_CD_EXT BILL_TO_PROVINCE_EXT BILL_TO_SITE_USE_ID UL L NUMBER NUMBER NUMBER VARCHAR2 30 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 NUMBER
104. mns has several foreign keys to the tables FND_USER and FND_LOGINS we do not include the foreign key columns LAST UPDATED BY CREATED BY or LAST UPDATE LOGIN in a table s list of foreign keys Additional Who Columns for Concurrent Programs Some Oracle Release Management applications tables also contain several additional Who columns to distinguish between changes a user makes with a form and changes a concurrent program makes When a concurrent program updates or inserts a row in a table the concurrent program populates the following additional Who columns REQUEST_ID Concurrent request ID of program that last updated this row foreign key to FND_CONCURRENT_REQUESTS RE QUEST_ID PROGRAM APPLICATION ID Application ID of program that last updated this row foreign key to FND APPLICATION APPLICATION ID PROGRAM ID Program ID of program that last updated this row foreign key to FND CONCUR RENT PROGRAM CONCURRENT PRO GRAM ID PROGRAM UPDATE DATE Date when a program last updated this row Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 5 Since every table containing these additional Who columns has several foreign keys to the tables FND_CONCURRENT_REQUESTS FND_APPLICATION and FND_CONCURRENT_PROGRAM we do not include the foreign key columns REQUEST_ID PROGRAM APPLICATION ID or PROGRAM ID in a table s list of foreign keys Indexes If an Oracle Release Management appli
105. n Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Trading Part segment column Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual Indexes Index Name Index Type Sequence Column Name RLM_CUST_ITEM_CUM_KEYS_U1 UNIQUE D SHIP FROM ORG ID 10 SHIP TO ADDRESS ID 15 BILL_TO_ADDRESS_ID 20 INTRMD_SHIP_TO_ID 25 CUSTOMER_ITEM_ID 30 CUM_START_DATE 35 CUST RECORD YEAR 40 PURCHASE ORDER NUMBER Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 13 RLM_CUST_ITEM_TERMS_ALL Column Descriptions Name This table contains new R 12 customer item attributes which are dependent upon the Ship From Customer Item relationship Some attributes from Phase 1 were carried forward from VEH_MTL_CUSTOMER_ITEMS which is being eliminated in Phase 2 Null Type Description CUST ITEM TERMS ID CUSTOMER ITEM ID SHIP FROM ORG ID ADDRESS ID HEADER ID AGREEMENT NAME FUTURE AGREEMENT NAME CALC CUM FLAG CUM CURRENT START DATE CUM PREVIOUS START DATE NOT NULL NOT NULL NOT NULL NULL NULL NULL NULL NULL NULL NUMBER NUMBER
106. nd is frequently a window you open directly from the Navigator Other Information Sources There are additional information sources including other documentation training and support services that you can use to increase your knowledge and understanding of Oracle Designer Oracle Application Object Library and your Oracle Release Management application We want to make these products easy for you and your staff to understand and use Oracle Designer Online Documentation The online help for Oracle Designer describes how you can use Oracle Designer for your development needs Oracle Applications Developer s Guide This guide contains the coding standards followed by the Oracle Applications development staff It describes the Oracle Application Object Library components needed to implement the Oracle Applications user interface described in the Oracle Applications User Interface Standards It also provides information to help you build your custom Developer forms so that they integrate with Oracle Applications Oracle Applications User Interface Standards This manual contains the user interface UI standards followed by the Oracle Applications development staff It describes the UI for the Oracle Proprietary Confidential Information Use Restricted by Contract 1 8 Oracle Release Management Technical Reference Manual Oracle Applications products and how to apply this UI to the design of an application built using
107. nd with your other systems This documentation includes open interfaces found in Oracle Manufacturing Oracle Applications Messages Manual The Oracle Applications Messages Manual contains the text of numbered error messages in Oracle Applications Oracle Applications messages begin with the prefix APP It also provides information on the actions you take if you get a message Note This manual is available only in HTML format Installation and System Administration Oracle Applications Installation Release Notes This manual contains a road map to the components of the release including instructions about where to access the Release 11i documentation set Oracle Proprietary Confidential Information Use Restricted by Contract 1 10 Oracle Release Management Technical Reference Manual Oracle Applications Concepts Designed to be the first book the user reads to prepare for an installation of Oracle Applications It explains the technology stack architecture features and terminology for Oracle Applications Release 11i This book also introduces the concepts behind and major uses of Applications wide features such as MRC BIS languages and character sets NLS MLS BIS Self Service Web Applications and so on Installing Oracle Applications Describes the One Hour Install process the method by which Release 11i will be installed This manual includes all how to steps screen shots and information about
108. ndard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL xception place holder lexfield not standard AOL Requested quantity If Item_Detail_Type 0 1 2 this is the demand quantity If Item_Detail_Type 3 this is the authorization quantity If Item_Detail_Type 4 this is the shipped received or CUM quantity If Item_Detail_Type 5 this is a miscellaneous quantity such as ahead behind inventory balance etc Schedule item detail row sub type For form or forecase demand Bucket type associated with the demand date quantity for authorizations the type of authorizations the type of authorization for shipment receipt cumulative or last Validated against FND_LOOKUPS Schedule item detail row type 0 Past Due Firm 1 Firm Demand 2 Forecast Demand 3 Authorization 4 Shipment Receipt Info 5 OtherValidated against FND LOOKUPS LOOKUP TYPE RLM DETAIL TYPE CODE o x x H Qa 0 0 xX HE AA AeA HE he HE Hm HE h o x mh GA X Q oO m m HE Haf m m HA Hri HE HE NULL VARCHAR2 3999 Exception message Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 27 3 28 QTY_TYPE_CODE REPORT_SUMMARY INTERFACE_HEADER_ID INTERFACE LINE ID SCHEDULE HEADER ID SCHEDULE LINE ID SCHEDULE TYPE SCHED GENERATION DATE SCHEDULE ITEM NUM SCHEDULE PURPOSE
109. nformation Use Restricted by Contract 3 34 Oracle Release Management Technical Reference Manual BIL CAR CAR COMI COU L TO STATE EXT RIER ID CODE EXT RIER QUALIFIER EXT ODITY EXT TRY OF ORIGIN EXT CUST ASSEMBLY EXT CUST ASSIGNED ID EXT CUST BILL TO EXT CUST CONTRACT NUM EXT CUSTOMER DOCK CODE CUST INTRMD SHIP TO EXT CUST ITEM PRICE EXT CUST ITEM PRICE UOM EXT CUSTOMER ITEM REVISION CUSTOMER JOB CUST MANUFACTURER EXT CUST MODEL NUMBER EXT CUST MODEL SERIAL NUMBER CUST ORDER NUM EXT CUST PROCESS NUM EXT CUST PRODUCTION LINE CUST PRODUCTION SEQ NUM CUST SET NUM EXT CUST SHIP FROM ORG EXT CUST SHIP TO EXT CUST UOM EXT CUSTOMER ITEM EXT CUSTOMER ITEM ID E Ea Ga VARCHAR2 10 VARCHAR2 35 VARC AR2 3 VARCHAR2 35 VARCHAR2 35 VARCHAR2 30 VARCHAR2 20 VARCHAR2 35 VARCHAR2 35 VARC VARC AR2 50 AR2 35 NUMBER VARCHAR2 3 VARC AR2 3 VARC VARC AR2 50 AR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARC VARC AR2 50 AR2 35 VARCHAR2 35 VARCHAR2 80 VARCHAR2 35 VARCHAR2 10 VARCHAR2 50 NUMBER Bill To state as sent by the customer on the N4 segment The carrier id as sent by the customer on the TD5 segment The carrier qualifier as sent by the customer on the TD5 segment Customer specified commodity cod
110. notice Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 53 IMPORT_LICENSE_EXT NDUST DUST DUST DUST DUST DUST DUST DUST DUST DUST DUST DUST DUST DUST RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT RY_AT TR TR TR TR TR TR TR TR TR TR TR TR TR TR BUTE BUTE BUTE BUTE BUTE BUTE BUTE BUTE2 BUTE3 BUTE4 BUTES BUTE6 BUTE7 BUTE8 INDUSTRY_ATTRIBUTE9 INDUSTRY_CONTEXT INTRMD_SHIP_TO_ID SHIP_TO_ORG_ID 3 54 Oracle Release Management Technical Reference Manual NTRMD ST ADDRESS 1 EXT TRMD ST ADDRESS 2 EXT TRMD ST ADDRESS 3 EXT TRMD ST ADDRESS 4 EXT TRMD ST CITY EXT NULL G E E NULL NULL NULL NULL NULL NULL NULL NULL NULL VARCHAR2 35 VARC VARC AR2 AR2 VARCHAR2 VARCHAR2 VARC AR2 VARC AR2 VARC AR2 VARC VARC AR2 AR2 VARC AR2 VARC AR2 VARC AR2 VARC AR2 VARCHAR2 50 50 50 50 50 50 50 50 50 50 VARCHAR2 150 VARCHAR2 30 NUMBER NUMBER VARC VARC VARC VARC VARC AR2 35 AR2 35 AR2 35 AR2 35 AR2 30 Customer Import Lic
111. ntract 3 14 Oracle Release Management Technical Reference Manual CUST_ITEM_STATUS_CODE ROUND_TO_STD_PACK_FLAG SHIP_DELIVERY_RULE_NAME SHIP_METHOD INTRANSIT_TIME STD_PACK_OTY TIME_UOM_CODE ORG_ID PRICE_LIST_ID DEMAND_TOLERANCE_ABOVE USE_EDI_SDP_CODE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY PLN_FIRM_DAY_TO ATTRIBUTE_CATEGORY NOT NOT NOT NOT NOT NULL NULL NULL NULL NULL NULL CEG G G E E VARCHAR2 25 VARCHAR2 1 VARCHAR2 30 VARCHAR2 30 NUMBER NUMBER VARCHAR2 3 NUMBER NUMBER NUMBER VARCHAR2 1 DATE NUMBER DATE NUMBER NUMBER VARCHAR2 30 Current Release status of the item e g prototype production non carryover for reporting purposes this is updated by the material planner not the EDI transaction This column can be a selection criteria for future RLM reports This column is a foreign key to the MTL_ITEM_STATUS table Indicates whether requirements should be rounded up to standard packs If set on the additional quantity to fill the std pack is subtracted from the next oldest requirement to avoid most overshipments If populated identifies the hipment delivery pattern code o be used when calculating the pecific shipment dates from he customer release ransactions for this item FK o RLM_SHIP_DELIVERY_CODES nique identifier for the hipment method FK to TL INTERORG SHIP ME
112. omer part engineering change level included on schedule Item measurement information as sent by the customer on the MEA segments Free form item note text included in the schedule Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 55 TEM_REF_CO TEM_REF_CO TEM_REF_CO TEM_REF_VA TEM_REF_VA TEM_REF_VA LETTER_CRED LETTER_CRED DE_1 DE_2 DE_3 LUE_1 LUE_2 LUE 3 TEM RELEASE STATUS EXT LADING QUANTITY EXT IT EXPDT EXT IT EXT LINE REFERENCE LINK TO LINE REF ORG ID OTHER NAME CODE 1 OTHER NAME CODE 2 OTHER NAME VALUE 1 OTHER NAME VALUE 2 PACK SIZE EXT PACK UNITS PER PACK EXT PACK UOM CODE EXT PACKAGING CODE EXT PRIMARY QUANTITY PRIMARY UOM CODE 3 56 Oracle Release Management Technical Reference Manual NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL VARCHAR2 3 VARCHAR2 3 VARCHAR2 3 VARCHAR2 35 VARCHAR2 35 VARC AR2 35 VARC AR2 3 NUMBER DATE VARCHAR2 35 VARCHAR2 50 VARCHAR2 50 NUMBER VARCHAR2 3 VARCHAR2 3 VARCHAR2 80 VARCHAR2 80 NUMBER NUMBER VARCHAR2 3 VARCHAR2 10 NUMBER VARCHAR2 3 Reference code 1 included in customer EDI transaction Reference code 2 included in customer EDI transaction Reference code 3 in
113. omponents LAST UPDATE DATE NOT NU DATE Standard Who column LAST UPDATED BY NOT NU NUMBER Standard Who column CREATION DATE NOT NU DATE Standard Who column CREATED BY NOT NU NUMBER Standard Who column ATTRIBUTE CATEGORY U VARCHAR2 30 Descriptive Flexfiled context column ATTRIBUTEL U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE2 U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE3 U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE4 U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTES U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE6 U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE7 U VARCHAR2 150 Descriptive Flexfield segment column ATTRIBUTE8 U VARCHAR2 150 Descriptive Flexfield segment column Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE TP ATTRIBUTEL TP ATTRIBUTE2 TP ATTRIBUTE3 TP_ATTRIBUTE4 TP_ATTRIBUTES TP_ATTRIBUTE6 TP_ATTRIBUTE7 TP_ATTRIBUTE8 TP_ATTRIBUTE9 TP_ATTRIBUTE10 TP_ATTRIBUTE11 TP_ATTRIBUTE12 TP_ATTRIBUTE13 TP_ATTRIBUTE14 TP ATTRIBUTE15 TP ATTRIBUTE CATEGORY rd ea DEE ENER Gaaqaqaaqaaa
114. on Control Record ECE TP TRANSLATOR CODE NULL VARCHAR2 35 For EDI transactions only ED Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record EDI CONTROL NUM 3 NULL VARCHAR2 15 EDI control number 3 ST assigned by the customer s ED translator for audit EDI TEST INDICATOR NULL VARCHAR2 1 EDI Test Production trasaction indicator T or P assigned by the customer s EDI translator EDI Gateway rules determine the handling of test transactions within the Demand Processor EXCEPTION_ATTRIBUTE1 NULL VARCHAR2 150 Exception place holder flexfield not standard AOL EXCEPTION_ATTRIBUTE10 NULL VARCHAR2 150 Exception place holder flexfield not standard AOL Oracle Proprietary Confidential Information Use Restricted by Contract 3 26 Oracle Release Management Technical Reference Manual EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT EXCEPT ON_AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT ON AT TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR BUTE11 BUTE12 BUTE13 BUTE14 BUTE15 BUTE16 BUTE17 BUTE18 BUTE19 BUTE2 BUTE20 BUTE3 BUTE4 B
115. on included on schedule Customer job number The manufacturer as sent by the customer on the LIN segment of the 866 txn Customer Model Number for this sequenced detail Customer Vehicle Identification Number for this sequenced detail e g VIN or Chassis ID The order number as sent by the customer on the LIN segment of the 866 and 830 txn The process number as sent by the customer on the LIN segment of the 866 and 862 transaction Customer production line The customer set number as sent on the LIN segment of the 862 and 866 txns External Inventory Organization Cross Reference External Ship to address Cross Reference External Customer unit of measure cross reference Customer specified optional end date time applicable for flexible bucketed requirements and cumulative information such as authorizations and shipped received The equipment code as sent by the customer on the TD3 segment The equipment number as sent by the customer on the TD3 segment Special handling code as sent by the customer in the TD4 segment Hazardous Material Code corresponding to the Hazardous Material Code Qualifier as sent by the customer in the TD4 segment Hazardous Material Code Qualifier as sent by the customer in the TD4 segment Hazardous Material Description as sent by the customer in the TD4 segment Customer Import License Date included on the shipping schedule and must be sent back on the ship
116. ons ofPlanning Shipping and Sequenced Schedules See page 3 30 EDI Inbound Gateway feeds into this table which stores the item and item detail level information associated with customer planning shipping or production sequenced schedules See page 3 34 Release Management Message Category used by Exception Report See page 3 46 This table stores the header level details of the Release Management schedules It has details pertainig to the specific schedule and customer level information Release Management demand Processor uses this table to maintain a currentpicture of demand schedule headers See page 3 47 This table stores the item and item detail level information associated with customer planning shipping or production sequenced schedules For production sequence schedules the item represents the feature not theconfiguration See page 3 51 This table stores the optional Shipment Delivery Pattern Rules which can then be associated with the customer item destination They are used in the Demand Stream Processor for splitting or consolidating daily or weekly customerrequirements from planning and shipping schedules into discrete shipment date quantity groups which consistently and accurately reflect the customer s expected shipment or delivery patterns The Rule is in context of the customer givendate qualifier i e delivery or shipment See page 3 63 This table stores the Names of all the Queries
117. ormation Oracle Self Service Web Applications Implementation Manual This manual describes the setup steps for Oracle Self Service Web Applications and the Web Applications Dictionary Oracle Applications Implementation Wizard User Guide If you are implementing more than one Oracle product you can use the Oracle Applications Implementation Wizard to coordinate your setup activities This guide describes how to use the wizard Training Oracle Education offers a complete set of training courses to help you and your staff master Oracle Applications We can help you develop a training plan that provides thorough training for both your project team and your end users We will work with you to organize courses appropriate to your job or area of responsibility Training professionals can show you how to plan your training throughout the implementation process so that the right amount of information is delivered to key people when they need it the most You can attend courses at any one of our many Educational Centers or you can arrange for our trainers to teach at your facility In addition we can tailor standard courses or develop custom courses to meet your needs Support From on site support to central support our team of experienced professionals provides the help and information you need to keep your Oracle Release Management application working for you This team includes your Technical Representative Account Manager
118. ou may need to reference to write custom reports or use for other data extraction Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 1 Overview of Detailed Design During Detailed Design we specify in detail how each applications component should work We prepare detailed definitions of tables and views You can refer to this Detailed Design chapter to gain a detailed understanding of the underlying structure and processing of Oracle Release Management that enables you to e Convert existing application data e Integrate your Oracle Release Management application with your other applications systems e Write custom reports e Define alerts against Oracle Applications tables e Create views for decision support queries using query tools e Configure your Oracle Self Service Web Applications Table and View Definitions The Table and View Definitions section contains a detailed definition of Oracle Release Management applications tables For each table it provides information about primary keys foreign keys QuickCodes indexes triggers and sequences It also gives you a detailed description of each column and its characteristics In addition it provides the SQL statement that defines each view Review this section to get a detailed understanding of what tables your Oracle Release Management application contains and how it uses them to hold and access the information it needs Ora
119. rived from the ship from code n the schedule or the customer ite default warehouse FK to TL_PARAMETERS and R_ORGANIZATIONS HIP_FROM address postal code s sent by the customer on the 4 segment HIP_FROM province as sent by he customer on the N4 segment SHIP_FROM state as sent by the customer on the N4 segment Pull signal bar code label routing information line 1 Pull signal bar code label routing information line 10 Pull signal bar code label routing information line 2 Pull signal bar code label routing information line 3 Pull signal bar code label routing information line 4 Pull signal bar code label routing information line 5 Pull signal bar code label routing information line 6 Pull signal bar code label routing information line 7 Pull signal bar code label routing information line 8 Pull signal bar code label routing information line 9 orooro OK tn ZYP U TZUOQU HANAN TAHAHATHUNAHNHUAHAANHNUWAUHAN Ship to address line 1l as sent by the customer on the N3 segment Ship to address line 2 as sent by the customer on the N3 segment Ship to address line 3 as sent by the customer on the N3 segment Ship to address line 4 as sent by the customer on the N3 segment Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual SH P TO ADDRESS ID DELIVER TO ORG ID
120. rizon start date to which demand will be considered Frozen cannot be changed Descriptive Flexfield context column First day from the Shipping Schedule horizon start date from which demand will be considered Firm Shippable Last day from the Shipping Schedule horizon start date to which demand will be considered Firm Shippable Descriptive Flexfield context column Last day from the Shipping Schedule horizon start date to which demand will be considered Forecast Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual SHP_FROZEN_DAY_FROM ATTRIBUTE6 SHP_FORECAST_DAY_TO SHP_FORECAST_DAY_FROM ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE DEMAND_TOLERANCE_BELOW CUSTOMER CONTACT ID CUSTOMER ID FREIGHT CODE PLN FIRM DAY FROM SUPPLIER CONTACT ID TP ATTRIBUTEL TP ATTRIBUTE2 TP ATTRIBUTE3 NOT NULL rs E E E ter ae ae ae ae Gaqaaa NUMBER VARCHAR2 150 NUMBER NUMBER VARC AR2 VARC AR2 VARC AR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 VARCHAR2 NUMBE NUMBE NUMBE NUMBE DATE NUMBER D NN N A NUMBER NUMBER 50 50 50
121. se Restricted by Contract Detailed Design 3 35 REQUEST_DATE SCHEDULE_DATE DATE_TYPE_CODE DATE_TYPE_CODE_EXT DELIVERY_LEAD_TIME END_DATE_TIME EQUIPMENT_CODE_EXT EQUIPMENT_NUMBER_EXT HANDLING_CODE_EXT HAZARD_CODE_EXT HAZARD_CODE_QUAL_EXT HAZARD_DESCRIPTION_EXT DUST DUST DUST DUST DUST DUST NDUST DUST DUST NDUST DUST 3 36 RY AT RY AT RY AT RY AT RY AT RY AT RY AT RY AT RY AT RY AT RY AT TR TR TR TR TR TR TR TR TR TR TR BUTE BUTE BUTE BUTE BUTE BUTE BUTE BUTE2 BUTE3 BUTE4 BUTES PORT_LICENSE_DATE_EXT PORT_LICENSE_EXT oO PWNEF Oo NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL GG E E 22 zZ zZ qqqcaqqqqaqaqaaaG E E DATE DATE VARCHAR2 30 VARCHAR2 30 NUMBER DATE VARCHAR2 3 VARCHAR2 35 VARCHAR2 3 VARCHAR2 10 VARCHAR2 3 VARCHAR2 80 DATE VARCHAR2 35 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 The date and time the customer wants the material delivered or shipped based on whether the requirements are delivery based or ship based Planned shipment date and time request date delivery lead time if delivery based Type of start end date e g ship deliver Pull signal Cumulat
122. sion FK to RA ADDRESSES For EDI transactions only external Trading Partner Location Code assigned to the transaction For EDI transactions only EDI Gateway Trading Partner Code assigned to the transaction EDI control number 1 ISA assigned by the customer EDI translator for audit EDI control number 2 GS assigned by the customer EDI translator for audit EDI control number 3 ST assigned by the customer EDI translator for audit EDI Test Production transaction indicator T or P assigned by the customer EDI translator EDI Gateway rules determine the handling of test transactions within the Demand Processor Contact code 1 included in customer EDI transaction not validated Contact code 2 included in customer EDI transaction not validated Values associated with Contact code 1 concatenation of name communication code and communication number Values associated with Contact code 2 concatenation of name communication code and communication number Free form note text included in the schedule at the header level Reference code 1 included in customer EDI transaction Reference code 2 included in customer EDI transaction Reference code 3 included in customer EDI transaction Value associated with Reference code 1 Value associated with Reference code 2 Value associated with Reference code 3 Operating unit unique ID FK to HR ORGANIZATION UNITS External value from which RLM SCHED
123. sses Oracle Alert User Guide This manual explains how to define periodic and event alerts to monitor the status of your Oracle Applications data Multiple Reporting Currencies in Oracle Applications If you use the Multiple Reporting Currencies feature to report and maintain accounting records in more than one currency use this Oracle Proprietary Confidential Information Use Restricted by Contract Introduction 1 9 manual before implementing Oracle Release Management This manual details additional steps and setup considerations for implementing Oracle Release Management with this feature Multiple Organizations in Oracle Applications If you use the Oracle Applications Multiple Organization Support feature to use multiple sets of books for one Oracle Release Management installation use this guide to learn about setting up and using Oracle Release Management with this feature This book describes the Oracle Applications organization model which defines business units and the relationships between them in an arbitrarily complex enterprise Functional and technical overviews of multiple organizations are presented as well as information about how to set up and implement this feature set in the relevant Oracle Applications products Oracle Manufacturing Distribution Sales and Service Open Interfaces Manual This manual contains up to date information about integrating with other Oracle Manufacturing applications a
124. t Abbreviated unit of measure code FK to MTL UNITS OF MEASURE The weight as sent by the customer on the TD1 segment The weight qualifier as sent by the customer on the TD1 segment The unit of measure corresponding to shipment weight as sent by the customer on the TD1 segment HQtntHrOARHFPOHPHAQH HHH wta TW HPAMAH WOH Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 43 FBO CONFIGURATION FBO CONFIGURATION FBO CONFIGURATION FBO CONFIGURATION FBO CONFIGURATION MATCH KEY ACROSS MATCH KEY WITHIN CRITICAL KEY ATTRIBUTES LAST UPDATE DATE LAST UPDATED BY CREATION DATE BY EY BY BY EX NOT NOT NOT NOT NU NU NU NU NU NU NU NU C GAGE G NU VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 DATE NUMBER DATE NUMBER VARCHAR2 30 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 VARCHAR2 150 For FBO Production Sequence schedu les the ist sort key identifying configurations indica ted by t he customer For FBO Production Sequence sched les the ted by t 2nd sort key fying configurations he customer
125. t FK to PER PEOPLE F Trading Partner Flexfield Segment column Trading Partner Flexfield Segment column Trading Partner Flexfield Segment column Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 17 TP_ATTRIBUTE4 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE5 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE6 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE7 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE8 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE9 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE10 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE11 NULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE12 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE13 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE14 NULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE15 ULL VARCHAR2 150 Trading Partner Flexfield Segment column TP_ATTRIBUTE_CATEGORY ULL VARCHAR2 30 Trading Partner Flexfield Segment column INACTIVE_DATE NULL DATE COMMENTS NULL VARCHAR2 240 PLN_MRP_FORECAST_DAY_FROM ULL NUMBER PLN_MRP_FORECAST_DAY_TO ULL NUMBER SHP_MRP_FORECAST_DAY_FROM ULL NUMBER SHP_MRP_FOR
126. tailed Design 3 7 RLM_CUST_ITEM_CUM_ADJ_ALL Column Descriptions 3 8 This table stores adjustments to the cum for all RLM customer destination items It has a child relationship to RLM_CUST_ITEM_CUM_KEYS The adjustments reflect manual CUM adjustment via a form in the Release Management module If CUM Management is enabled the adjustments in this table along with the shipping transaction information from the Shipping Module are used in the Demand Stream Processor and Shipping applications to dynamically calculate the supplier CUM according to the CUM calculation rules defined for the customer destination The contents of this table are displayed in the CUM Management Workbench Name Null Type Description CUM_ADJ_ID NOT NU NUMBER Unique identifier for CUM Adjustment transaction CUM_KEY_ID NOT NU NUMBER Customer Item cum KEY unique ID FK to RLM CUST ITEM CUM KEYS TRANSACTION DATE TIME NOT NU DATE Transaction date time ADJUSTMENT REASON U VARCHAR2 30 Validated against MTL TRANSACTION REASONS REASON NAME ORG ID U NUMBER Operating unit ID ADJUSTMENT REFERENCE U VARCHAR2 240 Comment field TRANSACTION QTY U NUMBER Transaction quantity expressed in the UOM on the CUM Key for shipment transactions this is the summarized quantity of all order lines shipped for this item associated with the shipment number for ATO items the summary of the features c
127. text column ATTRIBUTE14 NULL VARCHAR2 150 Descriptive Flexfield context column ATTRIBUTE15 ULL VARCHAR2 150 Descriptive Flexfield context column LAST_UPDATE_LOGIN ULL NUMBER Standard Who column REQUEST_ID NULL NUMBER Standard Who column PROGRAM_APPLICATION_ID NULL NUMBER Standard Who column PROGRAM_ID ULL NUMBER Standard Who column PROGRAM_UPDATE_DATE ULL DATE Standard Who column Oracle Proprietary Confidential Information Use Restricted by Contract 3 32 Oracle Release Management Technical Reference Manual TP_ATTRIBUTE1 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE2 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE3 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE4 NULL VARCHAR2 150 Trading Partner flexfield column TP ATTRIBUTE5 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE6 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE7 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE8 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE9 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE10 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE11 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE12 NULL VARCHAR2 150 Trading Partner flexfield column TP_ATTRIBUTE13 NULL VARCHAR2 150 Trading Partner flexfield colu
128. the customer on the N3 egment P_FROM address city as sent the customer on the N4 gment HIP_FROM country as sent by he customer on the N4 segment HIP_FROM county as sent by he customer on the N4 segment HIP_FROM Name as sent by the ustomer in the N1 and or N2 egment hip from organization entifier FK to L PARAMETERS and _ ORGANIZATIONS HIP_FROM address postal ode as sent by the customer on he N4 segment HIP_FROM province as sent by he customer on the N4 segment HIP_FROM state as sent by the ustomer on the N4 segment Pull signal bar code label routing information line 1 OK JHA GU Ata tO Mme Ea u OUt ta unG uU a o A aya am a a a a A er Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 41 SHIP_LABEL_INFO_LINE_10 SHIP_LABEL_INFO_LINE_2 SHIP_LABEL_INFO_LINE_3 SHIP_LABEL_INFO_LINE_4 SHIP_LABEL_INFO_LINE_5 SHIP_LABEL_INFO_LINE_6 SHIP_LABEL_INFO_LINE_7 SHIP_LABEL_INFO_LINE_8 SHIP_LABEL_INFO_LINE_9 SHIP TO ADDRESS 1 EXT SHIP TO ADDRESS 2 EXT SHIP TO ADDRESS 3 EXT SHIP TO ADDRESS 4 EXT SHIP TO ADDRESS ID DELIVER TO ORG ID SHIP TO CITY EXT SHIP TO COUNTRY EXT SHIP TO COUNTY EXT SHIP TO NAME EXT SHIP TO POSTAL CD EXT SHIP TO PROVINCE EXT SHIP TO SITE USE ID SHIP TO STATE EXT START DATE TIME NU NU NU NU
129. tive Validated against FND LOOKUPS LOOKUP TYPE RLM QTY TYPE CODE Sequence Generated Unique Identifier foreign key to the RLM SCHEDULE HEADERS ALL Interface Line unique identifier FK to RLM INTERFACE LINES Customer specified start date time applicable whenever a discrete date quantity is indicated Customer specified unit of measure FK to MTL UNITS OF MEASURE Oracle Proprietary Confidential Information Use Restricted by Contract Detailed Design 3 51 ATO_DATA_TYPE NULL VARCHAR2 25 Code to describe what type of data is included for the ATO item 1 Model and Options 2 Model 3 Options Validated against FND_LOOKUPS LOOKUP_TYPE RLM_ITEM_METHOD_TYPE AR2 35 Bill To address line 1 as sent by the customer on the N3 segment AR2 35 Bill To address line 2 as sent by the customer on the N3 segment AR2 35 Bill To address line 3 as sent by the customer on the N3 segment AR2 35 Bill To address line 4 as sent by the customer on the N3 segment BILL_TO_ADDRESS_ID NULL NUMBER Bill To address identifier FK to RA_ADDRESSES INVOICE_TO_ORG_ID NULL NUMBER Unique identifier for invoice to organization which relates to BILL_TO_ADDRESS_ID FK to HR_ORGANIZATIONS AR2 30 Bill To address city as sent by the customer on the N4 segment AR2 3 Bill To country as sent by the customer on the N4 segment AR2 25 Bill To county as sent by the customer on the N4 segment AR2 60 Bill To Name as s
130. tolnstall installs this column Subsequent versions of your Oracle Release Management application might not include this column No longer Your Oracle Release Management application no installed longer uses this column If you upgraded your software from an earlier version you may still have this column depending upon whether you chose to delete it during an upgrade process If you install your Oracle Release Management application you do not have this column Standard Who Columns Most Oracle Release Management applications tables contain standard columns to support Row Who When your program or SQL Plus Oracle Proprietary Confidential Information Use Restricted by Contract 3 4 Oracle Release Management Technical Reference Manual command selects a row from a table use these columns to determine who last updated the row If your program or SQL Plus command updates or inserts a row in an interface table you must populate each of the five standard Who columns LAST_UPDATE_DATE Date when a user last updated this row LAST_UPDATED_BY User who last updated this row foreign key to FND_USER USER_ID CREATION_DATE Date when this row was created CREATED_BY User who created this row foreign key to FND_USER USER_ID LAST_UPDATE_LOGIN Operating system login of user who last updated this row foreign key to FND_LOGINS LOGIN_ID You should set this to NULL or to 0 if NULL is not allowed Since every table containing Who colu
131. tomer shipment receipt information It has a child relationship to RLM_SCHEDULE_HEADERS Null Type Description LINE_ID CUSTOMER_ITEM_EXT CUSTOMER_ITEM_ID DATE_TYPE_CODE INVENTORY_ITEM_ID ITEM DETAIL SUBTYPE ITEM DETAIL TYPE QTY TYPE CODE HEADER ID INTERFACE LINE ID START DATE TIME UOM CODE NOT NULL NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NUMBER VARCHAR2 35 NUMBER VARCHAR2 30 NUMBER VARCHAR2 30 VARCHAR2 30 VARCHAR2 30 NUMBER NUMBER DATE VARCHAR2 3 Sequence Generated Unique Identifier for Schedule Line Customer item number Customer item unique identifier FK to MTL CUSTOMER ITEMS Type of start end date e g ship deliver Pull signal Cumulative Validated against FND LOOKUPS LOOKUP TYPE RLM DATE TYPE CODE Inventory item unique identifier FK to MTL SYSTEM ITEMS Schedule item detail row sub type For form or forecast demand Bucket type associated with the demand date quantity for authorizations the type of authorization for shipment receipt cumulative or last Validated against FND LOOKUPS LOOKUP TYPE RLM DETAIL TYPE CODE Schedule item detail row type 0 Past Due Firml Firm Demand 2 Forecast Demand 3 Authorization 4 Shipment Receipt Info 5 OtherValidated against FND LOOKUPS LOOKUP TYPE RLM DETAIL TYPE CODE Actual or Cumula
132. ty to support you Moreover this version of the Oracle Release Management Technical Reference Manual does not contain complete information about the dependencies between Oracle Release Management applications tables Therefore you should write data into only those tables we identify as interface tables If you write data into other non interface tables you risk violating your data integrity since you might not fulfill all the data dependencies in your Oracle Release Management application You are responsible for the support and upgrade of the logic within the procedures that you write which may be affected by changes between releases of Oracle Applications Do not rely on upward compatibility of the data model Oracle reserves the right to change the structure of Oracle Release Management applications tables and to change the meaning of add or delete lookup codes and other data in future releases We do not guarantee the upward compatibility of the Oracle Release Management applications data model For example if you write a report that identifies concurrent requests that end in Error status by selecting directly from Oracle Application Object Library tables we do not guarantee that your report will work properly after an upgrade About Oracle Application Object Library The Oracle Release Management Technical Reference Manual may contain references to tables that belong to Oracle Application Object Library Oracle Application
133. ure the customer site is open for receiving on a calculated shipment arrival date FK to BOM_CALENDARS Default freight code to be used by the demand processor to populate the freight carrier on the inbound demand This can be defaulted from the profile option RLM default carrier FK to ORG FREIGHT Supplier shipping calendar code If populated the Demand Stream Processor will use this calendar when applying ship delivery pattern rules and lead time offsets to ensure the supplier site is available for shipping on calculated scheduled shipment date FK to BOM CALENDARS If UNSHIPPED FIRM DISP CD DELETE AFTER N DAYS the number of days before the current date where the requirement is eligible for cancellation HNANATAA wH H WNWAHKH DASGCOKRVDOH DWACtcet Oracle Proprietary Confidential Information Use Restricted by Contract 3 20 Oracle Release Management Technical Reference Manual UNSHIPPED_FIRM_DISP_CD USE_EDI_SDP_CODE_FLAG DEMAND_TOLERANCE_ABOVE DEMAND_TOLERANCE_BELOW INACTIVE_DATE HEADER_ID ORG_ID PRICE_LIST_ID CRITICAL_ATTRIBUTE_KEY CUSTOMER CONTACT ID PLN FIRM DAY FROM PLN FIRM DAY TO PLN FORECAST DAY FROM NOT NULL NULL NULL NULL NULL VARCHAR2 30 VARCHAR2 1 NUMBER NUMBER DATE NUMBER NUMBER NUMBER VARCHAR2 80 NUMBER NUMBER NUMBER NUMBER Indicates disposition of old unshipped firm demand when the Demand
134. was derived in EDI Gateway Code Conversion External value from which QTY TYPE CODE was derived in EDI Gateway Code Conversion External value from which DATE TYPE CODE was derived in EDI Gateway Code Conversion For FBO Production Sequence schedules the 1st sort key for identifying configurations indicated by the customer For FBO Production Sequence schedules the 2nd sort key for identifying configurations indicated by the customer For FBO Production Sequence schedules the 3rd sort key for identifying configurations indicated by the customer For FBO Production Sequence schedules the 4th sort key for identifying configurations indicated by the customer For FBO Production Sequence schedules the 5th sort key for identifying configurations indicated by the customer Audit trail of match across key used when this schedule was processed Audit trail of match within key used when this schedule was processed DOHAH DDH Qeuncet u i a B u i a B u a B u i a B Oracle Proprietary Confidential Information Use Restricted by Contract Oracle Release Management Technical Reference Manual CRITICAL_KEY_ATTRIBUTES LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTES ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE
135. with the demand date quantity for authorizations the type of authorization for shipment receipt cumulative or last External value from which ITEM_DETAIL_SUBTYPE was derived in EDI Gateway Code Conversion Schedule item detail row type 0 Past Due Firml Firm Demand 2 Forecast Demand 3 Authorization 4 Shipment Receipt Info 5 OtherValidated against FND LOOKUPS LOOKUP TYPE RLM DETAIL TYPE CODE External value from which ITEM DETAIL TYPE was derived in EDI Gateway Code Conversion Qagaqaagaa Oracle Proprietary Confidential Information Use Restricted by Contract 3 38 Oracle Release Management Technical Reference Manual TEM_ENG_CNG_LVL_EXT TEM_MEASUREMENTS_EXT TEM_NOTE_TEXT TEM_REF_CODE_1 TEM_REF_CODE_2 TEM_REF_CODE_3 TEM_REF_VALUE_1 TEM_REF_VALUE_2 TEM_REF_VALUE_3 TEM_RELEASE_STATUS_EXT LADING_QUANTITY_EXT LETTER_CREDIT_EXPDT_EXT LETTER_CREDIT_EXT LINE_REFERENCE LINK_TO_LINE_REF ORDER HEADER ID ORG ID OTHER NAME CODE 1 OTHER NAME CODE 2 OTHER NAME VALUE 1 OTHER NAME VALUE 2 PACK SIZE EXT PACK UNITS PER PACK EXT PACK UOM CODE EXT PACKAGING CODE EXT VARCHAR2 35 VARCHAR2 240 VARC AR2 240 VARC AR2 3 VARCHAR2 3 VARCHAR2 3 VARCHAR2 35 VARCHAR2 35 VARCHAR2 35 VARCHAR2 3 NUMBER DATE VARCHAR2 35 VARCHAR2 50 VARCHAR2 50 NUMBER NUMBER

Oracle Release Management Technical Reference Manual

Contents

Download Pdf Manuals

Related Search

Related Contents