Posts

Showing posts from November, 2019

How do Internal Orders process through Purchasing, Order Entry and Inventory?

The internal order process can start with Inventory, MRP or it can start in the purchasing module. All requisitions imported from Inventory or MRP will be loaded with an AUTHORIZATION_STATUS='APPROVED' unless the requisitions are created by Inventory's Min-Max Planning Report and those can only have an AUTHORIZATION_STATUS='INCOMPLETE' when the profile option called 'INV: Minmax Reorder Approval to Approved' is set to prevent requisitions from being created in an approved status. The Min-Max Planning Report must be run with the Restock parameter set to Yes in order for the requisitions to be imported. For the requisitions created from the MRP and Inventory modules, the Requisition Import program must be run in order to move records from the requisition interface tables to the historical PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL. All internal requisitions created in the Purchasing module will directly insert into th...

Oracle BI Publisher Tags For-each grouping for Matrix report

For-Each Extensions For-each tags can be confusing.  We will be going over the following tags:     For-each@ section :    For-each@ cell   For-each- group :   field1; field2;     For-each-group: current-group() ;field3;   For-each-group@ column       Sample XML:  <CORPORATION>      <NAME>Vision</NAME>     <DEPT>     <DEPT_NAME>IT</DEPT_NAME>      <EMPLOYEE>         <EMPNO>6</EMPNO>        <ENAME>Rich Walker</ENAME>        <JOB>CLERK</JOB>        <SAL>100</SAL>     </<EMPLOYEE>>     <EMPLOYEE>        ...