Exceptions in Shipping Execution

1. The "Pick Selection List Generation" concurrent program complete with Error.

     Error message:

     Cause:

     solution: Specify the "Release Sequence Rule" & "Pick Slip Grouping Rule" in Picking Release Form.

2. The "Pick Selection List Generation" current program complete successfully, and Shipping Transaction List Status is "Released to Warehouse", 

    but the move order is not created.

    Error Message: ---

    Cause:  Checked the move order line is created in mtl_txn_request_lines but the Header_id is null.

                    The Shipping Inventory Organization is not defined in Shipping Parameters Form.

                     (Navigation: Order Management -> Shipping -> Setup -> Shipping Parameters)

    Solution:  

3. Perform Ship Confirm successfully, Shipping Transaction List Status: Shipped, Next Step: Run Interfaces, 

    "Interface Trip Stop" concurrent program complete with Warning.

    Error Message:

    

[25-JUL-13 09:48:40] INV_TXN_MANAGER_PUB: -----Inside process_Transactions-------.trxhdr=606401877[25-JUL-13 09:48:40] INV_TXN_MANAGER_PUB: Inv Batch size:0[25-JUL-13 09:48:40] INV_TXN_MANAGER_PUB: MTI Rows cnt before Validation=1[25-JUL-13 09:48:40] INV_TXN_MANAGER_GRP: wip_constants.DMF_PATCHSET_LEVEL115.1[25-JUL-13 09:48:40] INV_TXN_MANAGER_GRP: wip_constants.DMF_PATCHSET_J_VALUE115.1[25-JUL-13 09:48:40] INV_TXN_MANAGER_GRP: Validating specified item 0 failed[25-JUL-13 09:48:40] INV_TXN_MANAGER_GRP: Validating specified item 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating for layer cost update 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating lot/serial/revision control for direct inter-org transfers 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating item against xfer org 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating subinventory code 1 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating xfer subinventory code 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating restricted subinventories 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating xfer res subs 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating subs else 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating transaction source 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating transaction type 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating transaction action 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating ORG 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating xfer ORG 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating revisions 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating reasons 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating transaction uom 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating transaction quantity 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: start of OPM validations within (validate_group)[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating overcompletion quantity 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating distribution account 0 failed[25-JUL-13 09:48:41] INV_TXN_MANAGER_GRP: Validating freight account 0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating cost group 0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating xfer cost group 0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating group Plann Org:Supplier0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating group Planning Org:Inventory Org0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating group LPN:LPN_ID0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating group LPN:XFER_LPN_ID0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating group LPN:Content_LPN_ID0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_GRP: Validating rebuild items 0 failed[25-JUL-13 09:48:42] INV_TXN_MANAGER_PUB: Group validation complete [25-JUL-13 09:48:42] INV_TXN_MANAGER_PUB: All records failed after line validation[25-JUL-13 09:48:42] INVTXNB: Error from INV worker : error_code : Invalid subinventory, err_expl :Subinventory code is either not entered or not valid for the given organization

    Cause: The "Inactive On" date of Staging subinventory is out of expired date.

    Solution: 

                     

4. Fail to create internal AP Invoice against "Create Intercompany AP Invoices", which completed with warning.

    Error Message:    

        (Note that the l_gl_ccid is 0 here)

....Call inv_workflow.call_generate_cogsl_gl_ccid is 0API inv_workflow.call_generate_cogs returned failure.Message Dictionary couldn't open the ORA-20002: 3136: Item 'INVFLXWF/23047392' cannot be accessed while synchronous process in progress. application message file.  Message Dictionary Error- A file pathname could not be constructed for the application ORA-20002: 3136: Item 'INVFLXWF/23047392' cannot be accessed while synchronous process in progress..  This error often indicates that the Application Basepath (e.g. FND_TOP) or Subdirectory (APPLMSG) environment variables do not have a valid value.Warning: Invoice creation abortedEnd of Processing Invoice Line ID: 125281549.000000 Invoice Line ID: 125281549.000000 Status: FAILUREEnd of Processing Invoice ID: 2684798 ===================================== End of Transaction =================================================================================================================      2 Invoice Selected      0 invoice(s) processed.      2 Invoice Rejected ....

Turn on the INV debug mode, below is the external debug message(Note that the CCID is 0 here):

[08-AUG-13 08:52:36] 9: Getting the transaction flow header Id and trxDate from MMT[08-AUG-13 08:52:36] 9: After getting transaction flow header id from MMT[08-AUG-13 08:52:36] 9: Transaction date, Transaction Source Id and Transaction Action Id are: 05-AUG-13, 8 and 21[08-AUG-13 08:52:36] 9: TrxFlowHeaderId = 0 in MMT/RAE, getting it from mtl_transaction_flows_v or  mtl_transaction_flow_headers[08-AUG-13 08:52:36] 9: No data found from MTFV with inv org id[08-AUG-13 08:52:36] 9: l_trxFlowHeaderId = 1371[08-AUG-13 08:52:36] 9: l_logicalTrxTypeCode = 0[08-AUG-13 08:52:36] 9: l_new_accounting_flag = 1[08-AUG-13 08:52:36] 9: l_inv_cur = 1[08-AUG-13 08:52:36] 9: Assigning the local variables to the C local variables[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: FB_FLEX_NUM: 50310[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_CUSTOMER_ID: 10485[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_ITEM_ID: 40525[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_ORDER_HEADER_ID: 1057753[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_ORDER_LINE_ID: 3267428[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_ORDER_TYPE_ID: 4055[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_SELL_OPER_UNIT: 621[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_TO_INV_ORGANIZATION_ID: 639[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: V_CCID: 0[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: FB_FLEX_SEG: [08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: FB_ERROR_MSG: [08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Calling Workflow Initialize[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Created itemkey :23047392[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: IC_ITEMS_COGS: 243025[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Found v_doc_type_id: 2[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Found v_order_type_cogs: 0[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: V_ORGANIZATION_COGS: 243025[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Initilizing Workflow Item Attributes[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Calling FND_ELEX_WORKFLOW.GENERATE with Parameters:[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: Itemtype: INVFLXWF[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: itemkey: 23047392[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: ccid: 0[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: FND_ELEX_WORKFLOW.GENERATE returned ccid0[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: FND_ELEX_WORKFLOW.GENERATE returned v_concat_segs[08-AUG-13 08:52:36] INV_WORKFLOW.GENERATE_COGS: FND_FLEX_WORKFLOW.GENERATE returned FALSE with error: ORA-20002: 3136: Item 'INVFLXWF/23047392' cannot be accessed while synchronous process in progress.

    Cause: The CGSA account in Order transaction type is not maintained.

    Solution: