Skip to main content

How can Create Document Sequence in r12 for Order Management Transaction Type like "Mixed"








Document Sequence

Go to 

Order management Responsibility < Orders, Returns < Sales Order 





Make a sales Order for Check the Sales Order Number for Mixed transaction type.










Now Sales Order Number Series are 1000. And we want to start sales order number with 1.




Now Go to

Setup < Documents < Define

Define sequence with the name “Doc_Seq_Mixed” And create a sequence with initial value ‘1’.

Note -: You can manage it accordingly and if you want to make it manual then select TYPE Manual.














Now Save it.




Go to

Setup < Documents < Assign







Select Categories Mixed for Transaction Type “MIXED”.







Select Ledger name “Vision Operation (USA)”.







Now Go to Assignment tab .







Assigned Define sequence “Doc_Seq_Mixed”.








Note -: If there are any existing Sequence for the particular time period then firstly fill end date for that sequence.

Now Again Create the Sales Order and check the Series number for transaction type “MIXED”.














Thus we can change the sequence number for any transaction type in order management and another application also.

Now enjoy your Successful development.


For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide

Comments

Popular posts from this blog

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set property for your responsibility

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set the property for your responsibility. Solution-:      (1)  Go to System administrator > Profile > System       (2) Now Search “ HR: User Type ” Profile option at Responsibility level with Respective Responsibility. And Click On FIND Button. Now Select HR: User Type Value “HR with Payroll User” (you can choose another option as well accordingly). And SAVE. Now check your responsibility, error removed. Go ahead with your next step and enjoy Oracle Apps. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.

Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)

Error "You have exceeded the transaction quantity".  Applies to:  Information in this document applies to any platform. FORM:RCVRCERC.FMB - Enter Receipts GUI FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI FORM:RCVTXERE.FMB - Enter Returns GUI FORM:RCVTXECO.FMB - Enter Corrections GUI "You have exceeded the transaction quantity" Symptoms: "You have exceeded the transaction quantity" Note: Internal error message may indicate this message: INV_QUANTITY_TOO_BIG Steps: Go to Receiving Screen Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005) Go to Lot/Serial form Enter lot number and qty as 7200.00001 (which was rounded to 5 digits) The message "you have exceeded the transaction quantity " Cause Can Be-: a) Restriction of precision support up to 6 decimal places was added for the quantity field  b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to...

Script to insert on hand quantity in to MTL_TRANSACTIONS_INTERFACE

Script to insert on hand  quantity   into MTL_TRANSACTIONS_INTERFACE To insert on hand  quantity    into  MTL_TRANSACTIONS_INTERFACE INSERT INTO MTL_TRANSACTIONS_INTERFACE                             (     TRANSACTION_INTERFACE_ID,                    SOURCE_CODE,                             SOURCE_LINE_ID,                             SOURCE_HEADER_ID,                             PROCESS_FLAG,                             VALIDATION_REQUIRED,                             TRANSACTI...